SASID Import (Connecticut)

Tool Search: 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.

Screenshot of the SASID Import editor.

SASID Import

Importing a File

  1. Click Browse to select a file to be imported.
  2. Once a file is chosen, click Upload to import the file. 

Upload Layout

ElementDescriptionType,
Format, and
Length 
Campus DatabaseCampus Interface
Record Type

Identifies the type of record:

  • Register reports R
  • Change & Summer Roll-up reports C
  • Unregister reports U
Alphanumeric, 1 characterN/AN/A
State Assigned Student ID (SASID)The Student State ID for the student being reported.Alphanumeric, 10 charactersPerson.stateIDCensus > People > Demographics > Student State ID
Reporting DistrictThree-digit code for the district of attendance.Alphanumeric, 3 charactersDistrict.numberSchool & District Settings > District  > District Information > District Info > State District Number
Reporting District Entry DateThe 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 
MMDDYYYY

Enrollment.startDateScheduling & Courses > Calendar Setup > Calendar Information > 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 charactersCustomStudent.valueStudent 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 > General> Enrollments > State Reporting Fields > Facility Code Override

OR

School & District Settings > District > District Information > State District Number


School & District Settings > Schools > School Information > School Editor > School Detail > State School Number


School & District Settings > Schools > School Information > 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 charactersCustomStudent.valueStudent Information > General> 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 charactersIdentity.lastNameCensus > 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 charactersIdentity.firstNameCensus > 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 charactersIdentity.middleNameCensus > 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 charactersIdentity.suffixCensus > People > Demographics > Person Information > Suffix
Date of BirthThe student's date of birth.

Date field, 8 characters 
MMDDYYYY

Identity.birthDateCensus > 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 characterIdentity.hispanicEthnicityCensus > 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 characterRaceEthnicity.codeCensus > 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 characterRaceEthnicity.codeCensus > 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 characterRaceEthnicity.codeCensus > 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 characterRaceEthnicity.codeCensus > 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 characterRaceEthnicity.codeCensus > 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 theChangeSummer Roll-Upreport types.

Alphanumeric, 1 characterIdentity.genderCensus > People > Identities > Current Identity > Gender
Grade Code

The student's grade level.

This field always reports blank for the Unregister report type.

Alphanumeric, 2 charactersGradeLevel.stateGradeScheduling & Courses > Calendar Setup > Grade Level Setup > State Grade Level
District Student ID

The student's district assigned ID.

This field always reports blank for the Unregister report type.

Alphanumeric, 20 charactersPerson.studentNumberCensus > 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 charactersIdentity.lastNameCensus > 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 charactersIdentity.birthCityCensus > People > Identities > Birth City
Mother's Maiden NameThis field always reports blank.Alphanumeric, 35 charactersN/AN/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 
MMDDYYYY

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 IDThis field always reports blank.Alphanumeric, 9 charactersN/AN/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 
MMDDYYYY

Enrollment.endDateStudent 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 charactersEnrollment.endStatusStudent 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 charactersEnrollment.dropoutCodeStudent 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 charactersN/AN/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 charactersN/AN/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 
MMDDYYYY

Enrollment.endDateStudent 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 
MMDDYYYY

Enrollment.startDateScheduling & Courses > Calendar Setup > Calendar Information > 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 charactersEnrollmentCT.nexusDistrictStudent 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 
MMDDYYYY

Enrollment.spedExitDate, Enrollment.endDateStudent Information > General > Enrollments > Special Ed Fields
Nexus District Entry DateThe 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 
MMDDYYYY

CustomStudent.valueStudent Information > General > Enrollments > State Reporting Fields > Nexus District Entry Date
End of Record MarkerReports X for all report types.Alphanumeric, 1 characterN/AN/A