Classic View: CT State Reporting > PSIS State Extract
Search Term: PSIS State Extract
This tool extracts data to complete the Connecticut state-defined PSIS reporting extract. This extract reports all students currently enrolled on the Effective Date chosen on the editor.
Choose State Format (Fixed Width) to generate the file in the state defined file format. Otherwise, choose the CSV or HTML formats for testing purposes.
Report Layout
Seq | Element Name | Description | Campus Location | ||||||
---|---|---|---|---|---|---|---|---|---|
1 | SASID | A unique number assigned to a student by the state Department of Education. Numeric, 10 characters | Census > People > Demographics > StateID Person.stateID | ||||||
2 | reportingDistrict | The number assigned by a State to identify a School District. Numeric, 3 digits | System Administration > Resources > District information > District Info > State District Number District.number | ||||||
3 | nexusDistrict | The Nexus District is the district that has the legal responsibility to identify, educate, and pay for a special education student under the Individuals with Disabilities Education Act (IDEA). This element only reports when the student is active in Special Education; i.e., the Special Ed Status field reports Y. To report, the following conditions must be met.
Numeric, 3 digits | Student Information > General > Enrollments > State Reporting Fields > Nexus District EnrollmentCT.nexusDistrict | ||||||
4 | residentTown | The code for the town of fiscal responsibility. Alphanumeric, 3 characters | Student Information > General > Enrollments > State Reporting > Resident Town CustomStudent.value | ||||||
5 | facilityCode1 | The code for the school attended by the student. If the Facility Code Override field on the Enrollments tab is null, this field reports from the State District Code, School Code and Institutional Code fields on the School tab. Alphanumeric, 7 characters | Student Information > General > Enrollments > State Reporting > Facility Code Override System Admin > Resources > School > State District Code, School Code, Institution Code CustomStudent.value | ||||||
6 | facilityCode2 | The code for the school attended by the student. This field reports for students attending two facilities in accordance with an IEP or other special circumstances; e.g., attending part-time magnets, participating in the OPEN Choice program who are attending a private special education facility, or RESC-operated special education facility as a result of IEP. Alphanumeric, 7 characters | Student Information > General > Enrollments > State Reporting > Facility Code 2 CustomStudent.value | ||||||
7 | lastName | The student's last name. Alphanumeric, 35 characters | Census > People > Identities > Current Identity > Last Name Identity.lastName | ||||||
8 | firstName | The student's first name. Alphanumeric, 20 characters | Census > People > Demographics > Person Information > First Name Identity.firstName | ||||||
9 | middleName | The student's middle name. Alphanumeric, 20 characters | Census > People > Demographics > Person Information > Middle Name Identity.middleName | ||||||
10 | suffix | Indicates the person's name contains a generational indicator (Jr., Sr., etc.). Alphanumeric, 20 characters | Census > Demographics > Person Information > Suffix Identity.suffix | ||||||
11 | birthdate | The numeric representation of the date on which the student was born. Date field, 10 characters MM/DD/YYYY | Census > People > Identities > Birth Date Identity.birthDate | ||||||
12 | gradeCode | The grade the student will be entering at the Facility Code 1 school. Alphanumeric, 2 characters | Student Information > General > Enrollments > Grade Enrollment.grade | ||||||
13 | languageCode | The dominant language spoken by the student. Alphanumeric, 3 characters | Identity > Home Primary Language Identity.home | ||||||
14 | ellStatus | The student's EL status. This field reports Y if the Program Status is set to EL or Exited EL. The status date must be less than or equal to the Effective Date selected on the report editor. The Exited date must be NULL, greater than, or equal to he Effective Date selected on the report editor. Alphanumeric, 3 characters | Student Information > Program Participation > English Learners (EL) > EL > Program Status Lep.programStatus | ||||||
15 | ellProgramCode | The student's ELL Program Code. Alphanumeric, 2 characters | Student Information > Program Participation > English Learners (EL) > EL Services > Service Type LepServiceType.code | ||||||
16 | specialEdStatus | The student's special education status. This field reports Y for any student who has an active IEP and receives special education instruction as of the reporting period.
All others report N. Alphanumeric, 1 character | Student Information > General > Enrollments > Special Ed Fields > Special Ed Status Enrollment.specialEdStatus | ||||||
17 | mealStatus | Indicates whether the student is eligible for free or reduced price meals or free milk according to the Income Guidelines from the National School Lunch Program. This field reports F for Free Eligible or R for reduced. Alphanumeric, 1 character | FRAM > Eligibility > State Eligibility Code POSEligibilty.eligibility | ||||||
18 | NoLocalExpense | This field reflects the student’s status for Facility Code 1. Reports a two-digit code for students enrolled at no local expense. Alphanumeric, 2 characters | Student Information > General > Enrollments > State Reporting Fields > No Local Expense Enrollment.stateFundingCode | ||||||
19 | specialProgram | The Special Program that the student is attending. Special programs include Vocational Agriculture, OPEN Choice, Magnets, Interdistrict Cooperative Arrangements, Designated High School Arrangements, Bristol Technical Education Center (BTEC), Homebound, and Municipal Detention Center. Alphanumeric, 2 characters | Student Information > General > State Reporting Fields > Special Program Attendance CustomStudent.value | ||||||
20 | preKindergartenStatus | The Pre-K program in which the student is enrolled. Only students enrolled into a State Grade Level of PK or P3 report in this field. The first code entered in the PreK Program Status field reports when the student's Early Learning record has
The student's enrollment must have
Alphanumeric, 2 characters | Student Information > Program Participation > Early Learning > PreK Program Status Enrollment.preKindergartenStatus | ||||||
21 | preKDayInHours | The amount of time the student spends in their Pre-K program.
Alphanumeric, 5 characters | System Administration > Calendar > Calendar > Student Day GradeLevel.standardDay Calendar.studentDay | ||||||
22 | preKDaysPerYear | The number of Pre-K program days per year.
Alphanumeric, 20 characters | N/A | ||||||
23 | studentID | A code assigned and maintained by the local school district that is unique for each student in the district over time. Alphanumeric, 20 characters | Census > People > Demographics > Person Identifiers > Local Student Number Person.studentNumber | ||||||
24 | groupName | This field reports blank. | N/A | ||||||
25 | groupCode | This field reports blank. | N/A | ||||||
26 | migrant | Identifies a student who is or whose parent or spouse is a migratory agricultural worker and who has moved within the past 36 months across state or district boundaries to obtain temporary or seasonal employment. This field reports Yes or No.
Alphanumeric, 1 character Y or N | Student Information > General > Enrollments > State Reporting Fields > Migrant Enrollment.migrant | ||||||
27 | giftedTalented | Indicates whether the student is considered Gifted. Alphanumeric, 2 characters | Student Information > General > Enrollments > State Reporting Fields > Gifted/Talented Status Enrollment.giftedTalented | ||||||
28 | homeless | Describes the student's homeless status. See the following table for the Homeless Codes that report. Alphanumeric, 2 characters | Student Information > General > Enrollments > State Reporting > Homeless Enrollment.homeless | ||||||
29 | membershipDays | The total number of distinct membership days for the student in the calendar and school year being reported as of the effective date entered on the editor. Any day with a Day Event on the day that has a Standard Code of 99 in the Attribute/Dictionary (Day.eventType) is NOT counted. Override Logic: Reports the Membership Days Override from the Enrollment tool. Otherwise, the calculation above is used. Alphanumeric, 3 characters | Student Information > General > Enrollments > State Reported fields > Membership Days Override | ||||||
30 | attendanceDays | The total number of instructional days a student has been present for the current school year.
Override Logic: Reports the Attendance Days Override from the Enrollment tool. Otherwise, the calculation above is used. Alphanumeric, 3 characters | Student Information > General > Enrollments > State Reported fields > Attendance Days Override | ||||||
31 | immigrantStatus | Indicates the student's immigrant status. This field reports Y when
Otherwise, N reports. Alphanumeric, 1 character | Census > People > Demographics > Birth Country Census > People > Demographics > Date Entered US School | ||||||
32 | militaryFamily | Indicates whether the student's parent(s) or legal guardian(s) are military personnel. This field reports Y when the student has an active Guardian relationship with a Military Connections record that includes the following:
Otherwise, N reports. Alphanumeric, 1 character | Census > People > Military Connections | ||||||
33 | Title 1 Participation | Indicates whether a student is a Title I eligible to receive Title I services between September of the current year and August of the following year including summer activities.
Alphanumeric, 1 character | Student Information > Program Participation > Title I CustomStudent.value | ||||||
34 | Title 1 Program Type | The title 1 status is for the school.
Alphanumeric, 2 characters | System Administration > Resources > School > School History SchoolAttribute.title1 | ||||||
35 | Truant | Determine dates of absences found based on the Attendance Days. Sum of unexcused absence minutes must be greater than or equal to Whole Day Absence on grade level/calendar.
| Student Information > General > Enrollments > State Reported fields > Truant Override | ||||||
36 | endOfRecordMarker | The letter X reports in this field to mark the end of each record. Alphanumeric, 1 character | N/A |
Homeless Codes
Code | Description |
---|---|
0 | Not homeless |
1 | Shelters |
2 | Doubled up |
3 | Unsheltered |
4 | Hotel/Motel |
5 | Other |
6 | Unknown |
11 | Shelters/Unaccompanied Youth |
12 | Doubled up/Unaccompanied Youth |
13 | Unsheltered/Unaccompanied Youth |
14 | Hotel/Motel//Unaccompanied Youth |