The macro Find Blank CSE Records in Aeries Client Version, should be run prior to creating the CASEMIS student file.  This will identify any student that has a CSE record with no key data populated. This macro is accessible through View All Macros.  Double click on Find Blank CSE Records to run this macro. 



The following Query form will display with any student number that contains a blank record within the CSE table.  If there are no students with blank records this form will only display a zero under the Student# field. Any student located in CSE with a blank record MUST either be updated or deleted prior to creating the CASEMIS student file.




Find Orphaned (from STU) CSE Records


The macro Find Orphaned (from STU) CSE Records in Aeries Client Version (District) should be run prior to creating the CASEMIS student file.  This macro will identify any student that has a CSE record but does not have a record within the STU table. This macro is accessible through View All Macros.  Double click on Find Orphaned (from STU) CSE Records to run this macro. 


A query form will display with student information from the CSE table.  Any student located in CSE without a STU record must be updated prior to creating the CASEMIS student file.