Classic View: CT State Reporting > SASID Import
Search Term: SASID Import
This tool imports SASID State ID values from CSV files in the PSIS register format. The import will match students based on the local student numbers in the file and will produce a report of errors, unmatched students, and successful updates.
SASID Import
Importing a File
- Click Browse to select a file to be imported.
- Once a file is chosen, click Upload to import the file.
Upload Layout
| Element | Description | Type, Format, and Length | Campus Database | Campus Interface |
|---|---|---|---|---|
| Record Type | Identifies the type of record:
| Alphanumeric, 1 character | N/A | N/A |
| State Assigned Student ID (SASID) | The Student State ID for the student being reported. | Alphanumeric, 10 characters | Person.stateID | Census > People > Demographics > Student State ID |
| Reporting District | Three-digit code for the district of attendance. | Alphanumeric, 3 characters | District.number | System Administration > Resources > District information > District Info > State District Number |
| Reporting District Entry Date | The date at which the student first entered a school and began membership in your district. If a student has re-entered your district, it reflects the date of re-entry. | Date field, 8 characters | Enrollment.startDate | Calendar > Calendar Start Date OR Student Information > General > Enrollments > enrollment Editor > Start Date |
| Resident Town | The three digit code for the town of fiscal responsibility. This field always reports blank for the Unregister report type. | Alphanumeric, 3 characters | CustomStudent.value | Student Information > General > Enrollments > State Reporting > Resident Town |
| Facility Code 1 | Seven-digit code of the school attended by the student. If the Facility Code Override field is blank, this column is created by combining the following fields: State District Number + State School Number + Institution Code This field always reports blank for the Unregister report type. | Alphanumeric, 7 characters | CustomStudent.value | Student Information > Genera l> Enrollments > State Reporting Fields > Facility Code Override OR System Administration > Resources > District Info> State District Number System Administration > Resources > School > School Editor > School Detail > State School Number System Administration > Resources > School Editor > School Detail > Institution code |
| Facility Code 2 | Seven-digit code of the school attended by the student. This field always reports blank for the Unregister report type. | Alphanumeric, 7 characters | CustomStudent.value | Student Information > Genera l> Enrollments > State Reporting Fields > Facility Code 2 |
| Legal Last Name | The student's legal last name. This field always reports blank for the Unregister report type. | Alphanumeric, 35 characters | Identity.lastName | Census > People > Demographics > Person Information > Last Name |
| Legal First Name | The student's legal first name. This field always reports blank for the Unregister report type. | Alphanumeric, 20 characters | Identity.firstName | Census > People > Demographics > Person Information > First Name |
| Legal Middle Name | The student's legal middle name. This field always reports blank for the Unregister report type. | Alphanumeric, 20 characters | Identity.middleName | Census > People > Demographics > Person Information > Middle Name |
| Generation Suffix | The student’s generation suffix. For example, Jr, Sr, I, II, III, IV, V, or VI. This field always reports blank for the Unregister report type. | Alphanumeric, 4 characters | Identity.suffix | Census > People > Demographics > Person Information > Suffix |
| Date of Birth | The student's date of birth. | Date field, 8 characters | Identity.birthDate | Census > People > Demographics > Person Information > Birth Date |
| Hispanic or Latino | Determines whether a person identifies as Hispanic or Latino. This field reports Y or N. This field always reports blank for the Unregister report type. | Alphanumeric, 1 character | Identity.hispanicEthnicity | Census > People > Demographics > Person Information > Race/Ethnicity > Hispanic/Latino |
| American Indian or Alaska Native | Determines whether a person identifies as American Indian or Alaska Native. This field reportsY or N. This field always reports blank for the Unregister report type. | Alphanumeric, 1 character | RaceEthnicity.code | Census > People > Demographics > Person Information > Race/Ethnicity > American Indian or Alaska Native |
| Asian | Determines whether a person identifies as Asian. This field reports Y or N. This field always reports blank for the Unregister report type. | Alphanumeric, 1 character | RaceEthnicity.code | Census > People > Demographics > Person Information > Race/Ethnicity > Asian |
| Black or African American | Determines whether a person identifies as Black or African American. This field reports Y orN. This field always reports blank for the Unregister report type. | Alphanumeric, 1 character | RaceEthnicity.code | Census > People > Demographics > Person Information > Race/Ethnicity > Black or African American |
| Native Hawaiian or Other Pacific Islander | Determines whether a person identifies as Native Hawaiian or Other Pacific Islander. This field reports Y or N. This field always reports blank for the Unregister report type. | Alphanumeric, 1 character | RaceEthnicity.code | Census > People > Demographics > Person Information > Race/Ethnicity > Native Hawaiian or Other Pacific Islander |
| White | Determines whether a person identifies as White. This field reports Y or N. This field always reports blank for the Unregister report type. | Alphanumeric, 1 character | RaceEthnicity.code | Census > People > Demographics > Person Information > Race/Ethnicity > White |
| Gender Code | The student's gender. This field reports M or F. This field always reports blank for the Unregister and theChange & Summer Roll-Upreport types. | Alphanumeric, 1 character | Identity.gender | Census > People > Identities > Current Identity > Gender |
| Grade Code | The student's grade level. This field always reports blank for the Unregister report type. | Alphanumeric, 2 characters | GradeLevel.stateGrade | System Administration > Calendar > Calendar > Grade Levels > State Grade Level |
| District Student ID | The student's district assigned ID. This field always reports blank for the Unregister report type. | Alphanumeric, 20 characters | Person.studentNumber | Census > People > Demographics > Person Identifiers > Local Student Number |
| Last Name as it appears in SIS | This is different from the Legal Last Name in that the student’s last name may have changed for multiple reasons since their birth certificate and this is the name that is currently in use in the SIS. This field always reports blank for the Unregister report type. | Alphanumeric, 35 characters | Identity.lastName | Census > People > Demographics > Person Information > Last Name |
| Town of Birth | The city in which the student was born or comparable unit if born outside of the U.S. This field always reports blank for the Change & Summer Rollupand Unregister report types. | Alphanumeric, 50 characters | Identity.birthCity | Census > People > Identities > Birth City |
| Mother's Maiden Name | This field always reports blank. | Alphanumeric, 35 characters | N/A | N/A |
| Polio Vaccination Date | The date of the student's first Polio vaccine. This field always reports blank for the Change & Summer Rollupand Unregister report types. | Date field, 8 characters | VaccineShot.date | Student Information > Health > Immunizations > Polio [IPV, OPV] > Shots Student Information > Health > Immunizations > Polio [OPV] > Shots Student Information > Health > Immunizations > Polio [IPV] > Shots |
| Secondary ID | This field always reports blank. | Alphanumeric, 9 characters | N/A | N/A |
| Reporting District Exit Date | The date the student’s membership in the district stopped. This field always reports blank for the Register and Change & Summer Roll-Up report types. | Date field, 8 characters | Enrollment.endDate | Student Information > General > Enrollments > End Date |
| Exit Type | This field reports the Exit Type from the enrollment is the Facility Code 1 is changing; e.g. the student is transferring to another facility in the same district. This field always reports blank for the Register report type. | Alphanumeric, 2 characters | Enrollment.endStatus | Student Information > General > Enrollments > Exit Type |
| Exit Status | The student's exit status. This field always reports blank for the Register and Change & Summer Roll-Up report types. | Alphanumeric, 2 characters | Enrollment.dropoutCode | Student Information > General > Enrollments > Exit Status |
| Number of Days of Membership | The total number of instructional days a student has been enrolled for the current school year. This is a calculated field. This field always reports blank for the Register report type. | Alphanumeric, 3 characters | N/A | N/A |
| Number of Days in Attendance | The total number of instructional days a student has been present for the current school year. This is a calculated field. This field always reports blank for the Register report type. | Alphanumeric, 3 characters | N/A | N/A |
| Facility/Grade Exit Date | The date the student left the previous school/grade. The "previous" school is defined as the Facility Code 1 school of record before the change or unregister is processed. This is the Facility Code 1 school the student is leaving. This field always reports blank for the Register report type. | Date field, 8 characters | Enrollment.endDate | Student Information > General > Enrollments > enrollment Editor > End Date |
| Facility/Grade Entry Date | The date the student entered the new school and/or grade. The "new" school is defined as the Facility Code 1 which the student will be attending after the register or change is processed. The "new" grade is defined as the grade which the student will be in after the register or change is processed. This field is ignored in the unregister process. This field always reports blank for the Unregister report type. | Date field, 8 characters | Enrollment.startDate | Calendar > Calendar Start Date OR Student Information > General > Enrollments > enrollment Editor > Start Date |
| Nexus District | This field is conditional for special education students for all collections. 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. | Alphanumeric, 3 characters | EnrollmentCT.nexusDistrict | Student Information > General > Enrollments > State Reporting > Nexus District |
| Nexus District Exit Date | The date that the Nexus District ceased being fiscally responsible for the special education costs for the student. This field always reports blank for the Register report type. | Date field, 8 characters | Enrollment.spedExitDate, Enrollment.endDate | Student Information > General > Enrollments > Special Ed Fields |
| Nexus District Entry Date | The date that the Nexus District became fiscally responsible for the special education costs for the student. The date in Registration that the parent signed the IEP for initial Consent for Special Education Placement (ED626). If a parent requested delayed entry into school for children ages 3, 4 or 5, the first day of school reports. | Date field, 8 characters | CustomStudent.value | Student Information > General > Enrollments > State Reporting Fields > Nexus District Entry Date |
| End of Record Marker | Reports X for all report types. | Alphanumeric, 1 character | N/A | N/A |
