PREPARE_FALL_EMIS.HTML

REMIS: PREPARING LIVE EMIS FILES FOR OCTOBER REPORTING

Revised June 2007

You may now proceed with processing for each district as they are ready.

Complete the cleanup and archive of SIS data for all buildings in the district. This includes:

Disable UNCLEMIS as soon as you have taken your snapshot for 07N.
Archiving SIS files
*** Prior to processing B109 in a building, if you have the CSSSSID file listed on P155 as a NON-SIS table, you'll need to delete that file from P155 prior to running B109. If its is left on, all students who get deleted with B109 will also have their CSSSSID record deleted as well. Since your highest grade level in the building is just moving on to another building, you don't want those records deleted.
Processing B109 - SIS File cleanup
Processing B101 - Student Grade update (may be processed before or after B109)
Process PROF_PURGE to clean up the proficiency files. PROF_PURGE should be processed only after all buildings within a district have been cleaned up.
SSID_PURGEshould be processed only after all buildings within a district have been cleaned up.
Process RBCENT to rebuild the Central ID files. (after all buildings in the district have been cleaned up)
Put SSID back on the P155 table so that SSID records will go along when doing any transfers.

Note: PROF_PURGE, SSID_PURGE and RBCENT do not have to be processed in the order listed above but must not be processed until all buildings in a district have been cleaned up.

P310 calendars for new year entered in SIS (used by UNCLEMIS)
Check LOW_GRADE switch on the P030 table in each building in SIS to determine the lowest grade level attending each building. This must be correct before ANTIEMIS is processed.
This entry should appear as:

                 Code                             Value

                 LOW_GRADE               05

In this example, grade 05 would be the lowest grade level in this building which may be a middle school building.

This switch will be used by ANTIEMIS. At this point in the school year, students in the incoming grade level in each building may have an "I" - inactive status on STUD for the 07/08 school year. When ANTIEMIS sees this it thinks that status should be an active status so it issues the warning message "June active - inactive in STUD - wrong % and Att/home status?". In this situation the student is correctly coded since the school year has not yet started. By defining this lowest grade level switch, ANTIEMIS will not print this message for any student in the lowest grade level in the building under these circumstances.

This switch can easily be added to each building's P030 table by using a command file in CSSMASCPY with the following update command:
RECORD=P030/KEY=LOW_GRADE

You will then need to go into each building and update the "value" field to show the lowest "external value" grade level in that building.

Once all buildings in a district have been archived, including the new DISC.IDX file, you'll need to create a blank DISC.IDX file. You can use the following commands to create an FDL from your old DISC.IDX file and then create a new blank file.

$ ANALYZE/RMS/FDL SIS$DISTRICT:DISC.IDX

$ CREATE/FDL=DISC.FDL SIS$DISTRICT:DISC.IDX

Check the protection on the disc.idx file to make sure it matches the old file.

Prior to processing ANTIEMIS, you will need to verify the ANTIEMIS_OPTION switch in each building's P030 table. For ANTIEMIS to determine if a student should have the Status/Att combination on STUD updated with data from the student's old building, ANTIEMIS needs to know if the incoming students to the building were brought in as 'I' status or 'A' status. Valid options are:

Value

0. Ignore Status when determining whether or not to update, only update the Status/Att combination for students with a blank ATT code on STUD.

1. Assume new transfers have a Status I in STUD.

2. Assume new transfers have a Status A in STUD.

3. Assume new transfers may have a Status I or Status A in STUD.

The actions taken on these options are described briefly as follows:

Value

0. If the switch is set to 0, ANTIEMIS will only update the Status/Att combination for students with a blank ATT code on STUD.

1. If the switch is set to 1, students who are new to the building and have a Status/Att combination of I/A on STUD will be updated. Also, students who are new to the building and are Status "I" and whose ATT code on STUD matches the ATT code on the record in the Live EMSALT.IDX file will be updated.

2. If the switch is set to 2, students who are new to the building and have a Status/Att combination of A/A on STUD will be updated. Also, students who are new to the building and are Status "A" and whose ATT code on STUD matches the ATT code on the record in the Live EMSALT.IDX file will be updated.

3. If the switch is set to 3, students who are new to the building and who have a Status/Att combo of I/A _or_ A/A on STUD will be updated. Also, students who are new to the building and are Status "A" _or_ "I" and whose ATT code on STUD matches the ATT code on the record in the Live EMSALT.IDX file will be updated.

REGARDLESS of which switch you use, if a student has a blank ATT code, the student _will_ be updated.

ANTIEMIS will abort if the ANTIEMIS_OPTION switch is not defined on P030 or if it contains a value other than 0,1,2, or 3.

If your incoming students have already been updated to the correct status/ATT combination for the coming school year, you may add the switch "ANTIEMIS_ALT_STA" with a value of "N" to P030. With this switch defined with a value of "N", ANTIEMIS will not update the status/att fields but will update the RES, SPED and Program fields if applicable. With a value of "A" for this switch, nothing will be updated on STUD. If you only need to use the ANTIEMIS_ALT_STA switch, then it is not necessary to have the ANTIEMIS_OPTION switch defined on P030.

The following procedures are used to prepare the LIVE EMIS database for the October EMIS reporting period. Prior to beginning the EMIS database cleanup process you will need to complete the following steps:

In the 07N database, check the EMSMBP file on the EMSGCN screen, to make sure the last day of school is correct. This will be used by ANTIEMIS to determine at which point a student withdrew from the district and if his record should be kept.
Take the snapshot of your Live database to create the 07N EMIS database.

Copy in a blank REMISAUD.SEQ file into the LIVE database.
Run REMISNAP to set the switch in the REMISAUD.SEQ file to period K. It is important that this switch is set to the correct reporting period so the programs will process correctly for the October reporting period.

Once these steps are completed you may begin with the procedures for preparing your Live EMIS files.

Some of the EMIS files will need to be deleted and recreated since only data pertaining to the current school year is to be reported. We have created a command procedure to accomplish this. This procedure not only deletes files but runs REMISNAP for period K as well and copies in a blank REMISAUD.SEQ file so it covers this step and the prior two steps as well. You may need to modify this for your site but the general outline will probably be useful to you. The procedure we use follows:

$ SET NOON
$!
$!
$! Delete old DMS files
$!
$ DELETE/LOG EMIS_ROOT:[LIVE]DMSERR.SEQ;*
$!
$!
$! Delete aggregation and load files
$!
$ DELETE/LOG EMIS_ROOT:[LIVE]EMSRD*.*;*
$ DELETE/LOG EMIS_ROOT:[LIVE]EMSERR*.SEQ;*
$ DELETE/LOG EMIS_ROOT:[LIVE]EMSRX.DAT;*
$ DELETE/LOG EMIS_ROOT:[LIVE]EMSAGG.SEQ;*
$ DELETE/LOG EMIS_ROOT:[LIVE]EMSINT.SEQ;*
$!
$!
$! Delete records dumped from reformatted files by EMSR2D
$!
$ DELETE/LOG EMIS_ROOT:[LIVE]EMSHRT.SEQ;*
$ DELETE/LOG EMIS_ROOT:[LIVE]EMSLNG.SEQ;*
$!
$!
$! Delete EMIS audits file
$!
$ DELETE/LOG EMIS_ROOT:[LIVE]EMSAUDT.SEQ;*
$!
$!
$! Delete fiscal and staff data
$!
$! Cash, receipts and expenditures
$ DELETE/LOG EMIS_ROOT:[LIVE]EMSACT.IDX;*
$!
$! Various finanical statements and schedules
$ DELETE/LOG EMIS_ROOT:[LIVE]EMSAUD.IDX;*
$!
$! Staff demographics
$ DELETE/LOG EMIS_ROOT:[LIVE]EMSDEM.IDX;*
$!
$! Staff employment
$ DELETE/LOG EMIS_ROOT:[LIVE]EMSEMP.IDX;*
$!
$! Staff search file
$ DELETE/LOG EMIS_ROOT:[LIVE]EMSSSF.IDX;*
$!
$! OPU master
$ DELETE/LOG EMIS_ROOT:[LIVE]EMSOPU.IDX;*
$!
$! Salary schedules
$ DELETE/LOG EMIS_ROOT:[LIVE]EMSSCH.IDX;*
$!
$!
$! Delete achievement/ability data, building and student
$!
$ DELETE/LOG EMIS_ROOT:[LIVE]EMSBAA.IDX;*
$ DELETE/LOG EMIS_ROOT:[LIVE]EMSSAA.IDX;*
$!
$!
$! Delete competency records, building and student
$!
$ DELETE/LOG EMIS_ROOT:[LIVE]EMSBCP.IDX;*
$ DELETE/LOG EMIS_ROOT:[LIVE]EMSSCP.IDX;*
$!
$!
$! Delete student subject data
$!
$ DELETE/LOG EMIS_ROOT:[LIVE]EMSCLA.IDX;*
$!
$!
$! Delete student program records
$!
$ DELETE/LOG EMIS_ROOT:[LIVE]EMSPRG.IDX;*
$!
$! Delete student discipline records
$!
$ DELETE/LOG EMIS_ROOT:[LIVE]EMSDSP.IDX;*
$!
$!
$! Delete Early Childhood Record (New for summer 2004)
$!
$ DELETE/LOG EMIS_ROOT:[LIVE]EMSFGH.IDX;*
$!
$!
$! Delete 3rd grade Achievement Record (New for summer 2004)
$! Don't want to delete since EMIS is the source for storage
$! DELETE/LOG EMIS_ROOT:[LIVE]EMSSAC.IDX;*
$!
$!
$! ** New for FY2001, changed from EMSOT to EMSFGY summer 2004
$! Delete OCAP and Work Keys file
$ DELETE/LOG EMIS_ROOT:[LIVE]EMSFGY.IDX;*
$!
$! Delete old file which may be hanging around from very early releases of EMIS
$!
$ DELETE/LOG EMIS_ROOT:[LIVE]EMSTST.IDX;*
$!
$!
$! Delete multiple-teacher class master file
$!
$ DELETE/LOG EMIS_ROOT:[LIVE]EMSVBT.IDX;*
$!
$!
$! Delete Local Class Code Cross Reference File
$!
$! DELETE/LOG EMIS_ROOT:[LIVE]EMSCXR.IDX;*
$!
$!
$! Delete Vocational Education Correlated Data
$!
$ DELETE/LOG EMIS_ROOT:[LIVE]EMSVED.IDX;*
$!
$!
$! Delete student summer school data and search file
$!
$ DELETE/LOG EMIS_ROOT:[LIVE]EMSSUM.IDX;*
$ DELETE/LOG EMIS_ROOT:[LIVE]EMSSSU.IDX;*
$!
$!
$! Start with a new proficiency only and proficiency only search file
$!
$ DELETE/LOG EMIS_ROOT:[LIVE]EMSSGP.IDX;*
$ DELETE/LOG EMIS_ROOT:[LIVE]EMSSSP.IDX;*
$!
$!
$! Start with a new PS Assessment (GGG) file
$!
$ DELETE/LOG EMIS_ROOT:[LIVE]EMSFGB.IDX;*
$!
$!
$! Start with a new KRAL (Kindergarten Readiness) assessment file
$!
$ DELETE/LOG EMIS_ROOT:[LIVE]EMSFGO.IDX;*
$!
$!
$! Start with a new PS ASQ/SE assessment file
$!
$ DELETE/LOG EMIS_ROOT:[LIVE]EMSFGS.IDX;*
$!
$!
$! Start with a new OTELA (Ohio Test of English Language Acquisition) assessment file
$!
$ DELETE/LOG EMIS_ROOT:[LIVE]EMSFGF.IDX;*
$!
$!
$! Delete unneeded miscellaneous files leftover from prior processing
$!
$ DELETE/LOG EMIS_ROOT:[LIVE]*.TXT;*
$ DELETE/LOG EMIS_ROOT:[LIVE]*.LOAD;*
$ DELETE/LOG EMIS_ROOT:[LIVE]*.*LOADED;*
$ DELETE/LOG EMIS_ROOT:[LIVE]*.ACH;*
$ DELETE/LOG EMIS_ROOT:[LIVE]PREIDENT%%.SEQ;*
$!
$!
$! Create a new REMISAUD.SEQ file for period K, keeping the same protection
$!
$ RENAME/LOG EMIS_ROOT:[LIVE]REMISAUD.SEQ .OLD
$ RUN REMIS:REMISNAP
K
$!
$ SET SECURITY/LOG EMIS_ROOT:[LIVE]REMISAUD.SEQ -
/LIKE=(NAME=EMIS_ROOT:[LIVE]REMISAUD.OLD)
$ DELETE/LOG EMIS_ROOT:[LIVE]REMISAUD.OLD;*
$!
$!
$! Purge the directory
$!
$ PURGE/LOG EMIS_ROOT:[LIVE]/LOG
$!
$!
$! Create new, empty files as needed
$!
$ RUN OECN$EMIS:EMS00

Y
$!
$!
$! Set version numbers to one on all files
$!
$ RENAME EMIS_ROOT:[LIVE]*.* ;-1
$!
$!
$! Set the protection for all files in the directory
$!
$ SET FILE EMIS_ROOT:[LIVE]*.*/PROT=(S:RWED,O:RWED,G:RWED)
$!
$!
$! Copy in an empty EMSAUDT.SEQ file and set the protection for it
$!
$ COPY/LOG NOACSC:EMSAUDT.SEQ EMIS_ROOT:[LIVE]*/PROT=(S:RWED,O:RWED,G:RW)
$!
$ EXIT!
$

We have commented out the lines which delete all files in the [LIVE] database and copy in a new set from June [07N]. Since we normally take our snapshot as soon as June data is submitted, this step was no longer necessary for us.

You may decide to keep the EMSCXR.IDX (Local Class Code Cross Reference file) and the EMSVED.IDX (Vocational ED Program file) since this data may be the same from year to year.

Before proceeding you will need to have the latest release of the REMIS software installed, including ANTIEMIS V3.31 ----

Update EMSCON in the LIVE database for Fiscal year 08. Only students whose school year matches the Fiscal year minus 1 will be selected for processing by UNCLEMIS.
Run UNCLEMIS with cobol switches three and eight on. Cobol switch 8 indicates to UNCLEMIS to run in NEW YEAR mode. When processed in NEW YEAR mode, UNCLEMIS first zeroes out the last activity date on the EMSALTS record for each student so students that have transferred to a new building in the district may be updated properly. In order to determine which students to process, UNCLEMIS now checks the EMSCON file to obtain the fiscal year to process for. It then subtracts 1 from the fiscal year to get the current school year to process for.

In NEW YEAR mode, UNCLEMIS will -

assign 50% FTE to all new grade level KG students
assign 50% FTE to all KG grade level students who were
previously grade level PS
assign 100% FTE to all grade level 01 students who were
previously grade level KG
will _NOT_ update the status/att combo on ALTS for any student
unless it is adding an ALTS record for the student

By having cobol switch three on in this first run of UNCLEMIS, the "grade level next year" field will be updated for all students.

The command to set on cobol switches 3 & 8 is :

$ DEFINE COB$SWITCHES "3,8"

UNCLEMIS will also add a new switch to the P030 table in each building called NY_IN_PROCESS and set it's value at "Y". This switch will be used to prevent UNCLEMIS from being processed in regular mode and destroying the STATUS/ATT combos we are trying to preserve on the ALTS record prior to ANTIEMIS. ANTIEMIS will reset this switch to a value of "A" when it is processed so that UNCLEMIS may be processed as usual after ANTIEMIS. If it is necessary for you to rerun ANTIEMIS, manually reset this switch to "Y" prior to rerunning ANTIEMIS. (This switch was deleted by PURGEMIS, so if you didn't run PURGEMIS for a building, you'll need to modify this switch or delete before proceeding.)

At this time you will need to correct all serious errors from the UNCLEMIS run and then reprocess UNCLEMIS. Serious errors would be errors for students who would already be in the EMIS database but because of errors, they are unable to be processed at this time. A missing SSN for a new student is not a serious error at this point. You may rerun UNCLEMIS in NEW YEAR mode if necessary.

Once all errors are cleaned up, proceed to the next step.

Clean up ORPHANS.
Run the ORPHAN program to find any orphan records in the LIVE data. Orphans are students who have a student demographic and attendance record for which there is no matching record on the EMSALT.IDX alternate search file. Orphan records may be created in several ways. If you have allowed your users to access the EMSCID or EMSDID functions, these functions were not updating the EMSALT file at one time. Another way Orphans can be created is if you allow users to add students directly to the student demographic and attendance file instead of adding them using UNCLEMIS. When a student is added directly into EMIS, no EMSALT.IDX record is created. If these orphaned records are not cleaned up prior to ANTIEMIS, then ANTIEMIS will delete them. We do not recommend that you allow users to add students directly to EMIS. If you have users that have added students directly to EMIS this year, you must clean them up prior to ANTIEMIS!!!! Otherwise, they will be deleted.

It is important that orphans are examined and resolved. These records could be students that are EMIS reportable but because of their orphan status will not be updatable by the REMIS programs. If they have left the district and were never reported as withdrawn, ANTIEMIS will delete the orphaned record.

ORPHAN may be processed in report only mode or updating mode based on the status of COB$SWITCHES number "4". If you $ DEFINE COB$SWITCHES "4" then orphan will not only send the orphan EMIS records to the printed report it will allow you the option of deleting the student's records from EMIS entirely. If you inform ORPHAN you wish to delete the records from the EMIS files, ORPHAN will prompt you for a new EMIS ID. If you enter a new ID#, any records under the old number will be changed to the new number. If this would cause duplicates, then the old record is simply discarded, otherwise it is added under the new number. All records under the old number will be deleted. If, on the other hand, you do not enter a new EMIS ID number when prompted, but simply hit return, ORPHAN will delete all records under the old number.

Run ANTIEMIS. The purpose of this program is to delete records for students which are no longer needed. This would include students who were withdrawn prior to the last day of school indicated in the EMSMDR file in the 07N database and were reported in JUNE as withdrawn. ANTIEMIS compares the record in LIVE for a student to the record in JUNE and also checks STUD for differences in data. If students are still active or reportable, ANTIEMIS prepares the record for October reporting by resetting the following fields:

Move 08 to fiscal year
Move "K" to reporting period
Move all "*" to majority of attendance IRN
Move zeroes to graduation credit units
Move zeroes to all attendance fields (Attended, authorized, and unauthorized absences)
Move zeroes to corporal punishment
Move "*" to the non-attending reason field
Move "N" to Career Passport
Move "*" to Retained Status
Move all "*" to the Majority of Attendance IRN field
Prior Handicap will be reset to "**"
The Special Ed Exit date will be reset to all zeroes. Please inform your districts not to begin updating this field for next year until after their EMIS files have been cleaned up.
Move "*" to the Previous District IRN
Move "*" to Accountability IRN
If Grade Level = "UG", reset the State Equivalent Grade Level to spaces. If Grade Level is not = "UG", reset the State Equivalent Grade Level to "**"
Reset Gifted Screening and Assessment to "N"
Zero out the number of home schooled students from the District Fall information screen
Zero out the number of non-public students with disabilities from the District Fall information screen
Move zeroes to all Accelerated fields (Writing, Reading, Math, Social Studies and Science) - NEW for FY08
Move zeroes to OGT Graduation Alt.- NEW for FY08

If you respond "Y" to the prompt "Clear all Homeless statuses to *? (Y/N)> ", the homeless unaccompanied youth field will be reset to '*' as well.

If you respond "Y" to the prompt "Reset PreSchool Poverty Level to 'N' for grade PS students? (Y/N)" all students will have the Preschool Poverty Level reset to 'N'. If you respond "N" only students in a grade other than "PS" will have Preschool Poverty Level reset to 'N'. - NEW for FY08

If you respond "Y" to the prompt "Reset Attendance Pattern to 'NA' for grade PS students? (Y/N)" all students will have Attendance Pattern reset to 'NA'. If you respond 'N', only students in a grade other than 'PS' will have Attendance Pattern reset to 'NA'. - NEW for FY08

Logic related to certain 12th grade students with att/home Indicator of 1 or residency status of 2 has been modified to use withdrawal code '41' instead of '99'..

Note: The option to reset handicap status for a district was removed in previous years. Since prior disability condition is determined by a change in the student's handicap field, we felt it would be best not to wipe this out for anyone. If any of your districts wish to have their handicap conditions reset, then you can use Datatrieve to do it for them but it is not recommended. If you reset the field, UNCLEMIS will not update the prior disability field correctly when it is processed after you reset them.

The following additional options to reset fields in EMIS still exist in ANTIEMIS:

Clear all Disadvantagement Statuses (Y/N)
Delete all non-public students, Residents only, or none of them (A/R/N)
Clear all Limited English Statuses to N? (Y/N)
Clear all Migrant Statuses to N? (Y/N)
Clear all Homeless Statuses to *? (Y/N)
Reset Gifted Served Flags to N? (Y/N)

Additional Processing Capabilities:

Process for Community schools

Process for ESC's

Blank out the residency status for any "L" status students found in EMIS.

Options to delete the E905 and/or E906 entries in each building are included. This will give you the option of retaining these entries from year to year or wiping them out.

ANTIEMIS will NOT wipe out proficiency, OGT, or Achievement test records. In FY05, the original field used for Building IRN on the 9th grade Proficiency record was changed to reflect the Spring Administration IRN, so Antiemis was modified to update the Spring Administration IRN on the 9th grade proficiency records to the student's current building IRN.

ANTIEMIS will automatically create two reports, ANTIEMIS.TXT and ANTIEMIS_MAJOR.TXT. Major messages will be listed on both reports.

ANTIEMIS will reset STUD so that it will be updated with the Status/ATT combination retained in STUD from the student's previous building. ANTIEMIS will also reset the RES, SPED, and Program field on STUD for those schools using standard codes and/or using the program field on STUD to store disability.

The main issue with determining whom to update is finding the students who are new to the building. To do this, ANTIEMIS retrieves the student's record in the EMSALT file in the 07N database and compares it to the building code on the student's EMSALT record in the LIVE database. If they are different, then we assume that the student has changed buildings and is eligible for updating. Then, depending upon which switch you are using, the STATUS/ATT combo is examined to further determine if the student is to be updated or not.

The first thing ANTIEMIS does is to delete all orphan records. This is why it is necessary to check all orphans before ANTIEMIS to make sure that needed student records will not be deleted.

ANTIEMIS will update the calendar field on STUD for grade level "01" students. These students previously had a calendar number for a calendar other than the full day calendar. Now that these students will be attending all day everyday, their calendar is switched to the all day/every day calendar (calendar 1).

Error messages in ANTIEMIS :

The following messages are informational or warning messages. These messages will only appear in the ANTIEMIS.TXT report.

Student is active in SIS
This message appears for any student who is actively enrolled and has not withdrawn. This student would have an active status on STUD.

June Withdrawal - has re-entered the district
This student was reported in June as withdrawn but now has a more recent admission date which indicates that he has returned to the district. He will be flagged as a re-entry.

June Withdrawal - No Stud record in SIS - EMIS wiped out
This student was reported in June as withdrawn. STUD record and EMIS records have been deleted.

June withdrawal - stud record in SIS - EMIS wiped out
This student was reported in June as withdrawn, his EMIS record was deleted but he still has a STUD record in SIS.

June active - now withdrawn
Student was actively enrolled in June but has withdrawn after the last day of school. The last day of school is determined by the date for the last day defined in the EMSMDR file in the [07N] database.

June active - attends elsewhere full-time
Student is actively enrolled, has zero FTE and an attending/home IRN indicator to show his attending status outside the district.

June active - attends part-time in this district
Student is actively enrolled, has an FTE between 1 and 99% and has an indicator in the attending/home IRN status field to show his attending status outside the district.

June active - inactive in stud, incoming grade level for building
If the student was status I and had an ATT code prior to ANTIEMIS and is in the incoming grade level, ANTIEMIS will not update his status because it doesn't know what the status code should be.

New student
There is no record in JUNE EMIS for this student. Admission date is greater than the last day of school defined on the [07N] EMSMDR file. Student is new to the district.

New student , now Withdrawn
Admission date is greater than the last day of school defined on the [07N] EMSMDR file. Student is new to the district but is withdrawn.

Excluded student, withdrawn in June EMIS, EMIS records deleted
This student has an ATT code of "E" on STUD, was reported in June as withdrawn. His EMIS records were deleted.

Vocational Evaluation Student - EMIS wiped out.
This student has an ATT code of "L" on STUD, was reported in June as attending for vocational evaluation services only. . His EMIS records were deleted.

Resident, non-public Special Education Student - EMIS wiped out.
This student is coded as attending as a non-public special ed only student, and has been deleted from EMIS. These types of students do not require a withdraw date and code in EMIS. They are only deleted when you select the option to delete resident special ed only students.

Non-resident, non-public - EMIS wiped out.
This student is coded as attending as a non-public special ed only student, and has been deleted from EMIS. These types of students do not require a withdraw date and code in EMIS. They are only deleted when you select the option to delete resident special ed only students.

Non-resident, non-public.
This message appears for any student who is attending as a non-resident non-public special ed only student and you are not selecting an option to delete non-public special ed students.
June withdrawal - old school year on STUD - EMIS wiped out
This student is coded in EMIS as a grade level next year of 'DR' with a withdraw date and a withdraw code = '75' in June EMIS. On STUD, this student's school year is less than the current school year. This student is being kept in SIS for transcript printing purposes but should no longer be reported in LIVE EMIS. His EMIS records are deleted.

The following messages are considered major in severity and may require corrections. These messages will be both printed on the ANTIEMIS.TXT and the ANTIEMIS_MAJOR.TXT reports.

"INV W/Code" will print along with the withdraw code for any student who is found to be withdrawn and has an invalid withdraw code according to his withdraw date. Withdrawal codes 36-37, 40-43, 45-48, 51-52, 71-75, 99 and ** are valid since July 1, 2006. If any other withdrawal date is used, the error message will be generated.
Orphan alt deleted!
This error is the opposite of an orphan. This indicates that there was a record on the EMSALT file for which there was no corresponding record on the student demographic file. This record was deleted.

Admitted last year, no June EMIS record!!
This student has a record in LIVE but not in June. Admission date is before the last day of school as defined on the [07N] EMSMDR file. Check admission date in STUD and then add to JUNE if necessary.

Excluded student with EMIS record?!
This student has an ATT code of "E" on STUD but is still active in EMIS. He should be withdrawn in EMIS .

June withdrawal - after last day of school
ANTIEMIS will check the EMSMBP file in the 06N database to get the last day of school for the district. Any student who has a withdrawal date in the 07N database which is greater than the last day of school will receive this message. Their EMIS records will not be deleted.

June withdrawal - SIS status will still be processed by UNCLEMIS
This student was withdrawn prior to the end of last school year but still has a record in STUD with a status which keeps him updated in EMIS when UNCLEMIS is processed.

Withdrawn in June, returned, withdrew again
This student was previously reported as withdrawn in June, was re-admitted and has left again.

Gone in June, return, left again, UNCLEMIS will still process!
This student was reported as withdrawn in EMIS in June, came back during the summer and has now withdrawn again. This student also has a status on STUD which UNCLEMIS will process.

June active - inactive in stud - wrong % and att/home status?
This student has an "I" status on stud but is not withdrawn. On his EMIS record he has 100% Fte and nothing in the attending/home IRN and indicator fields.

June active - no STUD record on file - has an EMIS record in Live
This student was not reported as withdrawn in June but his STUD record has been deleted. He has an EMIS record in Live data but it doesn't indicate that he is attending anywhere else.

June active - Tuition student -Graduate for previous school year?
This student is coded in Live as a tuition student in the 12th grade. He has no graduation date or withdrawal date in June or Live and no record on STUD.

June active - Contract Vocational - no stud - did he graduate?
This student is coded in Live as a contract vocational student in the 12th grade. He has no graduation or withdrawal in June or Live and no STUD record in SIS.

June active - STUD status wrong? UNCLEMIS will not process
This student was actively enrolled in June, has a record in Live but has a status on STUD which UNCLEMIS will not process. An example of this type of status code would be "D" status.

0 FTE for student attending the district?!?
This student has an FTE of 0 on his Live demographic record but has nothing in the attending/home IRN and indicator fields to show where he is attending.

June active - school year on STUD updated to new school year
This student probably has an "I" status in STUD which kept him from being updated to the next school year by B101. Since he is not withdrawn, we assume that he should still be enrolled in the current school year so we advance the school year field on STUD.

New Student - but missing STUD!?!
This shouldn't happen, but, hey!

No June EMIS record, Live EMIS record, but STUD not current year
This student is in LIVE EMIS but his STUD record is not set to the current school year. You will need to investigate to see why he was not updated with the proper school year and why he is in EMIS.

June active - Non-Public, Special Education but ATT code is not N
This student is coded in EMIS as a non-public special ED student but doesn't have an "N" ATT code on STUD. His EMIS record will not be deleted. You will need to check to see if this student is still a non-public student
"Student withdrawn yet GLNY=13?!" Students with a Grade Level Next Year of '13' should no longer be withdrawn.

Once ANTIEMIS has completed, check over the report before going on to UNCLEMIS.

Process UNCLEMIS again with no COB$SWITCHES set once ANTIEMIS has been processed. The switches may be cleared as follows:

$ DEASSIGN COB$SWITCHES

This will update the ALTS record with the new status/ATT combo's now on STUD. At this point, the cleanup is finished and the district may begin to prepare for Fall EMIS reporting.

UNCLEMIS does three things once ANTIEMIS has been processed:

UNCLEMIS will enforce the use of the ATT codes. Blank ATT codes on any STUD regardless of status or school year will cause an error on the UNCLEMIS report
UNCLEMIS will not move students to EMIS who have an ATT code of "N" - non-public students receiving special ed services only. UNCLEMIS will only allow these students to be moved to EMIS during December and June processing.
UNCLEMIS does not allow a zero or blank FTE for A/A students. If the SPED field contains a zero, it will be treated as a zero

This completes the instructions for cleaning up the LIVE database.