Public School Information System (PSIS) Report

Select Schools

If run at the district level, choose one of the following:

• Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included.
• All Schools – Run the report for the entire district.

If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.

Select Students

Indicate which students to include in the report by selecting one of the following options:

• The selected [number] students only – Run the report for students in the current selection.
• All students – Run the report for all students in the current school or district that meet the selection criteria.

Note: If running the report for a single student, or group of students, select the students prior to running report.

Enrollment Snapshot Date

Enter the data you want the report to use for enrollment level data. This value determines which enrollment record to use for point in time data from either Students or Reenrollments.

ADA/ADM Start Date

Enter the date you want the report to use as the start date for calculating attendance and membership data for each student.

ADA/ADM End Date

Enter the date you want the report to use as the end date for calculating attendance and membership data for each student.

Display Headers?

Choose Yes or No from the drop down menu to determine whether to display header fields in the extract. Headers display the name of each data element for each record extracted. Use headers for troubleshooting purposes.

Extract Format

Choose whether to extract the records in comma-delimited format for troubleshooting purposes or in positional format for submission to the state.

1

State Assigned Student ID (SASID)

The student’s state-assigned student ID number.

[Students] State_StudentNumber

[S_CT_STU_X]State_Student_ID

Numeric

10

1–10

2

Reporting District

The three-digit code for the reporting school district.

[Prefs]Value where [Prefs]Name=districtnumber

Alpha-numeric

3

11–13

3

Nexus District

The district that has the legal responsibility to pay for a special education student.

[S_CT_STU_SPED_X]NexusDistrict

Alpha-numeric

3

14–16

4

Resident Town

The resident town that is fiscally responsible for this student, if the resident town is different from the reporting district. If the resident town and reporting district are the same, then this field should be blank.

This is applicable to students who attend your school at the expense of another town.

[S_CT_STU_Demographics_X] ResidentTown

Alpha-numeric

3

17–19

5

Facility Code 1

The school attended by the student; or, if the student changes schools, the report will pull the correct code for the school respective to the enrollment dates.

[S_CT_STU_X]FacilityCode1 or

[S_CT_REN_X]FacilityCode1

Or

[Schools]Alternate_School_Number

Or

[Schools]School_umber

Alpha-numeric

7

20–26

6

Facility Code 2

For a student who attends two facilities, enter the second school attended by that student. You must enter this field if one of the following is true:

• The special program code assigned to this student requires that the student attend another school on a part-time basis.
• The student attends a part-time magnet school or vocational agriculture classes through a shared-time arrangement.

[S_CT_STU_X]FacilityCode2

Alpha-numeric

7

27–33

7

Legal Last Name

The student’s legal last name.

[S_CT_STU_Demographics_X] BirthLastName or [Students]Last_Name

Alpha-numeric

35

34–68

8

Legal First Name

The student’s legal first name.

[S_CT_STU_Demographics_X] BirthFirstName or [Students]First_Name

Alpha-numeric

20

69–88

9

Legal Middle Name

The student’s legal middle name or initial.

[S_CT_STU_Demographics_X] BirthMiddleName or [Students]Middle_Name

Alpha-numeric

20

89–108

10

Generation Suffix

The student’s name suffix, if applicable.

[S_CT_STU_Demographics_X] GenerationSuffix

Alpha-numeric

4

109–112

11

Date of Birth

The student’s date of birth.

[Students]DOB

Alpha-numeric

8

113–120

12

Grade Code

The student’s grade level as of the reporting period.

If a value is entered for the Pre-Kindergarten/Kindergarten Grade Code, then that value is reported. Otherwise, the Grade Level value is reported.

[Students]Grade_Level

[ReEnrollments]Grade_Level

[S_CT_STU_PreKKG_X] PreKKGGradeCode

[S_CT_REN_X]PK_KGGrade

Alpha-numeric

2

121–122

13

Native Language Code

The student’s primary language.

[Students]primarylanguage

Alpha-numeric

3

123–125

14

EL/ML Status

Indicates (Y/N) if the student qualifies as an English Learner.

[S_CT_STU_Language_X] ELLIndicator

Alpha-numeric

1

126

15

English Learners/Multilingual Learners (ELs/MLs) Program Code

The English Learner Program for which this student qualifies.

See the Appendix for valid values.

[S_CT_STU_Language_X] ELLCode

Alpha-numeric

2

127–128

16

Special Education

Indicates (Y/N) for any student who has an active Individual Education Program (IEP) and receives special education instruction in the reporting period.

[S_CT_STU_SPED_X] SpecialEducation

Alpha-numeric

1

129

17

Eligible for free/reduced price meals

Valid values:

• F - Free
• R - Reduced
• N - No

[Students]lunchstatus

Alpha-numeric

1

130

18

Enrolled at No Local Expense Code

Indicates if the student is enrolled in the school at no local expense. If 00 displays or this field is blank, the student receives some local funding.

See the Appendix for valid values.

[S_CT_STU_X] EnrollNoLocalExpense

Alpha-numeric

2

131–132

19

Special Program Status Code

The special program in which this student participates.

See the Appendix for valid values.

[S_CT_STU_X] SpecialProgramStatusCode

Alpha-numeric

2

133–134

20

PreK Program Status Code

If the student is enrolled in a pre-kindergarten program, this is the student’s specific program or combination of programs.

• This field only extracts a value if a student's grade level is PreK or lower.
• If the field PreK KG Grade Code is blank but the students grade level is -1, PreK Program Status Code extracts 'PK'
• If the field PreK KG Grade Code is blank but the student grade level is -2 or below, PreK Program Status Code extracts 'P3'

See the Appendix  for valid values.

Note: If the ‘PreK Program Status Code’ on the student’s PreK/Kdg tab is set to ‘Not Pre-Kindergarten’, which is stored as a blank, it will default and output the code set in the field ‘Default Value of PreK Program Status Code’ in the school record associated with the student.

If Student is Kindergartarten or above, this field to be set to blank

[S_CT_STU_PreKKG_X] PreKProgramCode

Or

[S_CT_SCH_X]PreKProgramStatusCode

Alpha-numeric

2

135–136

21

Length of PreK Program Day in Hours

If the student is enrolled in a pre-kindergarten program, this is the amount of time the student spends in that program. Values are rounded to the nearest 15-minute increment.

If a value is entered for the student in the “Length of PreK Program Day in Hours” field (State/Province – CT page), then that value is extracted. Otherwise, the default value for the school is extracted from the Schools/School Info page.

[S_CT_STU_PreKKG_X] PreKHoursPerDay

[S_CT_SCH_X] PreKHoursPerDay

Alpha-numeric

5

137–141

22

Number of PreK Program Days per Year

If the student is enrolled in a pre-kindergarten program, this is the number of days per school year that the student spends in the program.

If a value is entered for the student in the “Number of PreK Days per Year” field (State/Province – CT page), then that value is extracted. Otherwise, the default value for the school is extracted from the Schools/School Info page.

[S_CT_STU_PreKKG_X] PreKDaysPerYear

[S_CT_SCH_X] PreKDaysPerYear

Alpha-numeric

3

142–144

23

District Student ID

The student’s district or locally assigned ID number.

[Students]Student_Number

Alpha-numeric

20

145–164

24

Group Name

This optional field is typically used to pass on to Harcourt for sorting of CMT labels.

[S_CT_STU_X]GroupName

Alpha-numeric

20

165–184

25

Group code

This optional field is typically used to pass on to Harcourt for sorting of CMT labels.

[S_CT_STU_X]GroupCode

Alpha-numeric

10

185–194

26

Migrant

A value of “Y” is reported if the student qualifies as a migrant student. The student must be from a family that is identified as having moved within the past 36 months across state or district boundaries to obtain temporary or seasonal employment in agriculture, fishing, or related food processing activities.

[S_CT_STU_Demographics_X] Migrant

Alpha-numeric

1

195

27

Gifted and Talented

The Gifted and Talented code that applies to the student.

See the Appendix for valid values.

[S_CT_STU_Demographics_X] GiftedTalented

Alpha-numeric

2

196–197

28

Homeless

Indicates if the student is homeless. If this field equals 00 or is blank, then the student is not homeless.

See the Appendix for valid values.

[S_CT_STU_Demographics_X] Homeless

Alpha-numeric

2

198–199

29

Number of Days of Membership

The number of instructional days that the student is enrolled in the school during the current school year.

Membership days begin accruing on the student’s first date of enrollment for the current school year and end with the report end date.

[S_CT_STU_X]DaysInMembership or calculated based on:

[PS_ADAADM_Defaults_All] Potential_AttendanceValue

[PS_ADAADM_Defaults_All] CalendarDate

based on the dates entered in the report parameters for:

ADA/ADM Start Date

ADA/ADM End Date

Numeric

3

200–202

30

Number of Days in Attendance

The number of instructional days that the student was present at the school during the current school year.

Attendance days are reported in whole numbers and must be equal to or less than the student’s membership days.

[S_CT_STU_X]DaysInAttendance or calculated based on:

[PS_ADAADM_Defaults_All] Potential_AttendanceValue

[PS_ADAADM_Defaults_All] CalendarDate

based on the dates entered in the report parameters for:

ADA/ADM Start Date

ADA/ADM End Date

Numeric

3

203–205

Indicates if the student is from a Military family.

Note: If field is 'N' or blank, then 'N' is reported.

Indicates the Title 1 Participant ( 'Y' or 'N'). 

If Title 1 Program Type at school level is 01

• If student Title1 is 'Y' then value 'Y' 
• If Course/section of student has value in 'Title 1 Services' then value 'Y'
• Else student Title1 is 'N' then value 'N'

If Title 1 Program Type at school level is 02 then value 'Y' 

If Title 1 Program Type at school level is 03 then value 'N'

 [S_CT_STU_Demographics_X] 

or 'Y' or 'N' based on criteria satisfied

If Title 1 Program Type at school level is 01

• If student Title1 is 'Y' then value 01
• Else student Title1 is 'N' then value blank

If Title 1 Program Type at school level is 02 then value 02

If Title 1 Program Type at school level is Not Eligible, then value blank

[S_CT_SCH_X] SCHOOLTITLEONEPROGRAM

or blank based on criteria satisfied