Tool Search: MI State Reporting
The Elementary 1030 Extract Format reports students enrolled in grades K-5 who were absent for the entire day on the Count Date.
Report Logic
A record reports for each student who has a full day absence on the Count Date. An absence is determined by a Status of Absent (Excused or Unexcused) and a State Code entered on the record.
Extract Formats
The 1030 Elementary Extract generates in PDF or DOCX format. See the 1030 Extracts article for directions on generating the extract.
Data Elements for the Elementary Extract
Element Name | Description | Campus Location |
|---|---|---|
District Number | State district number. Numeric, 5 digits | System Administration > Resources > District Information > State District Number District.Number |
District Name | Name of the district Alphanumeric, 20 characters | System Administration > Resources > District Information > Name District.Name |
School Year | Calendar year for which to generate the report. Alphanumeric, XX-XX | System Administration > Calendar > School Years > Start Year/End Year Calendar.endYear |
School Number | State school number Numeric, 5 digits | System Administration > Resources > School > State School Number School.number |
School Name | Name of the school Alphanumeric, 20 characters | System Administration > Resources > School > Name School.name |
Count Date | Count date entered on the report editor Date field, MM/DD/YYYY | Not dynamically stored |
Last Name | Last name of the student Alphanumeric, 25 characters | Census > People > Demographics > Person Information > Last Name Identity.lastName |
First Name | First name of the student Alphanumeric, 15 characters | Census > People > Demographics > Person Information > First Name Identity.firstName |
Middle Initial | Middle initial of the student Alphanumeric, 1 character | Census > People > Demographics > Person Information > Middle Name Identity.middleName |
Grade | Grade level of enrollment Numeric, 2 digits | Student Information > General > Enrollments > State Reporting Fields > General Enrollment Information Enrollment.grade |
Absence Type | Type of attendance entry assigned to the student's attendance event. Reports the Code for the absence that makes up the primary amount of the day. Absent/Excused reports as AE, Absent/Unexcused reports as AU. Alphanumeric, 15 characters | Student Information > General > Attendance AttendanceExcuse.excuse |
Date Returned | The first date the student attends class after the attendance entry and the count date. Reports the first date the student did not have an absence code in the reported period.
Date field, MM/DD/YYYY | Student Information > General > Attendance Attendance.date |
FTE Membership Reported | Student's general FTE membership. Reports the sum of FTE in General Education, FTE Section52, and FTE Section53. Reports struck through Date Returned reports as DR. Numeric, 4 digits | Student Information > General > Enrollment > State Reporting Fields > FTE in General Education Calculated |
