Tool Search: MI State Reporting
The 10/30 Course/Section Extract reports student absences.
Report Logic
A record reports for each student who has a period of absence on the Count Date. An absence must have a Status of Absent (Excused or Unexcused) and be part of a Course with a NCES Code entered. If Present Minutes are entered on a period, that period is not considered when determining an absence.
Extract Formats
The 10/30 Course/Section Extract generates in PDF or DOCX format. See the 1030 Extracts article for directions on generating the extract.
Data Elements for the Course/Section 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 being counted 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 school Alphanumeric, 20 characters | System Administration > Resources > School > Name School.name |
Count Date | Count date entered on the report editor Date field, MM/DD/CCYY | 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 Studentcontact.middleName |
Grade | Grade level of enrollment Numeric, 2 digits | Student Information > General > Enrollments > General Enrollment Information > Grade Enrollment.grade |
Class Period Absent | Displays the names of the Courses on the Count Date. If the student was absent, the course is marked and the Absence code reported. Alphanumeric, 1 character | Student Information > General > Schedule Calculated |
Date Returned to Course/Section | Reports the first date on which the student does not have an absence in their schedule for the particular course/section. The student must be actively scheduled into a course roster on the Date Returned and a Period Schedule must be in effect for the Course/Section on that date.
Date field, MM/DD/CCYY | Student information > General > Attendance Attendance.date |
FTE | Reports the sum of FTE in General Educaiton, FTE Section 52, and FTE Section 53. If Date Returned reports as DR, FTE reports with a Numeric, #.## | Student Information > General > Enrollment > State Reporting Fields > FTE in General Education, FTE Section 52, FTE Section 53 Calculated |
