Tool Search: MI State Reporting

The 10/30 Secondary Extract reports students enrolled in grades 6-12 who were absent for one or more periods on the Count Date.

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 a State Code entered.

Extract Formats

The 10/30 Secondary Extract generates in PDF or DOCX format. See the 1030 Extracts article for directions on generating the extract.

Data Elements for the Secondary 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 Calendar.startYear
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 periods on the Count Date in which the student was absent. If a student was absent from any class on the Count date, the period with the attendance code given for the class will be reported. Reports the local attendance code. Alphanumeric, 1 character	Student Information > General > Schedule Calculated
Date Returned to Class Period	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. Reports as follows: If the student has not yet returned to the class period, this field will remain blank. If the student has a roster End Date that matches the extract Count Date, reports as DR to indicate 'Did Not Return. If the student has subsequent full day absences and a roster End Date prior to the current date, reports as DR. If all periods have a roster End Date and report as DR, reports the FTE stricken through. Date field, MM/DD/CCYY	Student information > General > Attendance Attendance.date
FTE Membership Reported	Student's general FTE membership. Reports struck through if all period records report as DR. Numeric, #.##	Student Information > General > Enrollment > State Reporting Fields > FTE in General Education Calculated

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
Calendar.startYear

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 periods on the Count Date in which the student was absent.

If a student was absent from any class on the Count date, the period with the attendance code given for the class will be reported. Reports the local attendance code.

Alphanumeric, 1 character

Student Information > General > Schedule

Calculated

Date Returned to Class Period

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. Reports as follows:

If the student has not yet returned to the class period, this field will remain blank.
If the student has a roster End Date that matches the extract Count Date, reports as DR to indicate 'Did Not Return.
If the student has subsequent full day absences and a roster End Date prior to the current date, reports as DR.
If all periods have a roster End Date and report as DR, reports the FTE stricken through.

Date field, MM/DD/CCYY

Student information > General > Attendance

Attendance.date

FTE Membership Reported

Student's general FTE membership.

Reports struck through if all period records report as DR.

Numeric, #.##

Student Information > General > Enrollment > State Reporting Fields > FTE in General Education

Calculated

Secondary Extract (Michigan)

Report Logic

Extract Formats

Data Elements for the Secondary Extract

Related Articles