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


The body of the email will report summary information such as the date and time the CASEMIS 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 CASEMIS Student Data and CASEMIS Student Services Data files.




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




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




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

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




  • CASEMIS_TypeA_NotInFile.csv – lists the remaining Special Ed students in the Special Ed (CSE) table that were not updated during the CASEMIS 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.




  • CASEMIS_TypeA_Errors.csv – if the header record has missing or mis-named 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 mis-named non-key fields processing will continue, but a record will be added to the Errors file with the incorrect field name. Data will not be updated for field 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 CASEMIS Student Data file.

 




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




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




  • CASEMIS_TypeB_Errors.csv –if the header record has missing or mis-named fields they will be listed and the data will not be updated for those fields.