Depending on your type of school, you will submit attendance via the AT-RT or the AT-EM report.
The following steps should be done PRIOR to running the export for this file:
•Run the build enrollment data process. For instructions
•For students who are expelled or suspended, OUT of school days of enrollment should be deleted for the days expelled or OSS.
•OR
•Withdraw students on the day the expulsion/OSS begins and re-enroll the student when they return to school. Re-activate the student’s schedule.
•Refresh Attendance Analysis. For instructions
Fields in reports. Field #9 applies to the AT-RT report only.
1. School_number – match to the field that contains your school’s state assigned number OR enter the default value.
2. STN-match to the field that contains your students’ state testing number (STN)
3. Start date – already matched to the entry date field from the attendance analysis table.
4. End date – already matched to the exit date field from the attendance analysis table.
5. Days in attendance – already matched to the days in attendance field from the attendance analysis table.
6. Total absences - already matched to the total absences field from the attendance analysis table. (these are the EXCUSED absences)
7. Total absences unexcused - already matched to the total excused absences field from the attendance analysis table.
8. Grade level – already matched to the grade year field from demographics table.
9. School for Accountability - match to the field that contains the school number of the school accountable for the student's education. Generally this will be the same field as #1 unless the student lives outside the geographic boundaries of the school he/she attends.
You will want to create a sort that selects all students who have a zero in Current Year Active but may have an exit date. See below for the example.