Once the Special Ed Data import has completed an email will be sent to the email address(es) defined in the Special Ed Data Import page.

The body of the email will report summary information such as the date and time the Special Ed Data Import completed, and the number of records matched, unmatched, duplicate records, and records with errors. The email will also contain completion report attachments for the Student and Services data files.

• Special_Ed_Students_ImportedRecords.csv – lists all of the students from the Student file that were matched to the students in the Aeries system. The OriginalLineNumber is the record number in the Student file. The SSID, First Name, Last Name, Birthdate and Grade are from the Student file. The StudentID is the permanent ID of the student that the record was matched to in Aeries.

• Special_Ed_UnmatchedRecords.csv – lists all of the students from the Student file that could not be matched to the students in the Aeries system. The OriginalLineNumber is the record number in the Student file. The SSID, StudentID, FirstName, LastName, Birthdate and Grade are from the Student file.

• Special_Ed_Students_Duplicates.csv – lists students from the Student file that have duplicate records and cannot be processed. Corrections should be made in the system that houses the Special Education data and new Special Education data files should be extracted so that these students can be matched in the Aeries system. The OriginalLineNumber is the record number in the Student file. The SSID, First Name, Last Name, Birthdate and Grade are from the Student file.

In the below example two students have the same SSID in the Student file and cannot be matched in the Aeries system.

• Special_Ed_Students_NotInFile.csv – lists the remaining Special Ed students in the Special Ed (CSE) table that were not updated during the Special Ed Data Import. This will include students with CSE records that have a Primary Disability (CSE.DI), do not have a current Last Updated date (CSE.LU), and have either no Exit Date or an Exit Date > the day the CASEMIS Import was processed (CSE.XD). The SSID, First Name, Last Name, Birthdate and Grade are from the Aeries system.

• Special_Ed_Students_Errors.csv – if the header record has missing or misnamed key fields (last name, first name, student ID or SSID) they will be listed and the import process will stop. The headers will need to be corrected before the file can be imported. If the header record has missing or misnamed non-key fields processing will continue, but a record will be added to the Errors file with the incorrect field name(s). Data will not be updated for fields with incorrect field names. For files with a correct header this report will also list any records that were not processed because of an error. These records will need to be checked and the error resolved. The OriginalLineNumber is the record number in the Student file.

• Special_Ed_Students_ImportedRecords.csv – lists all of the services for the students from the Services file that were matched to the students in the Aeries system. The OriginalLineNumber is the record number in the Services file. The SSID, StudentID and Service are from the Services file.

• Special_Ed_Students_UnmatchedRecords.csv – lists the services for the students from the Services file that could not be matched to the students in the Aeries system. The OriginalLineNumber is the record number in the Services file. The SSID, StudentID and Service are from the Services file.

• Special_Ed_Services_Errors.csv –if the header record has missing or misnamed fields they will be listed and the data will not be updated for those fields.