Elementary Extract (Michigan)

Tool Search:10/30 Extracts

The Elementary 1030 Extract Format reports students 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 is generated in PDF or DOCX format. Directions on generating the extract are in the 1030 Extracts article.

Data Elements for the Elementary Extract

Element Name	Description	Location
District Number	State district number. Numeric, 5 digits	District Information > State District Number District.Number
District Name	Name of the district Alphanumeric, 20 characters	District Information > Name District.Name
School Year	Calendar year for which to generate the report. Alphanumeric, XX-XX	Calendar > School Years > Start Year/End Year Calendar.endYear Calendar.startYear
School Number	State school number Numeric, 5 digits	School Information > School > State School Number School.number
School Name	Name of the school Alphanumeric, 20 characters	School Information > 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 Reports from the identity record active on the Count Date of the extract editor If Legal Last Name = NOT NULL, report Legal Last Name If Legal Last Name = NULL, report Last Name Alphanumeric, 25 characters	Demographics > Identity > Protected Identity Information > Legal Last Name Demographics > Identity > Last Name Identity.lastName
First Name	First name of the student Reports from the identity record active on the Count Date of the extract editor If Legal Last Name = NOT NULL, report Legal First Name If Legal First Name = NULL, report First Name Alphanumeric, 15 characters	Demographics > Identity > Protected Identity Information > Legal First Name Demographics > Identity > First Name Identity.firstName
Middle Initial	Middle initial of the student Reports from the identity record active on the Count Date of the extract editor If Legal Last Name = NOT NULL, report Legal Middle Initial If Legal Middle Name = NULL, report Middle Initial Alphanumeric, 1 character	Demographics > Identity > Protected Identity Information > Legal Middle Name Demographics > Identity > 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. If the student has not yet returned to the class period, this field will remain blank If the student's roster End Date for all periods matches the extract Count Date, report as DR to indicate 'Did Not Return.' If the student has subsequent full-day absences and a roster End Date in all periods prior to the current date, report as DR. If all periods have a roster End Date and report as DR, reports the FTE stricken through. 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

Element Name

Description

Location

District Number

State district number.

Numeric, 5 digits

District Information > State District Number

District.Number

District Name

Name of the district

Alphanumeric, 20 characters

District Information > Name

District.Name

School Year

Calendar year for which to generate the report.

Alphanumeric, XX-XX

Calendar > School Years > Start Year/End Year

Calendar.endYear
Calendar.startYear

School Number

State school number

Numeric, 5 digits

School Information > School > State School Number

School.number

School Name

Name of the school

Alphanumeric, 20 characters

School Information > 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

Reports from the identity record active on the Count Date of the extract editor

If Legal Last Name = NOT NULL, report Legal Last Name
If Legal Last Name = NULL, report Last Name

Alphanumeric, 25 characters

Demographics > Identity > Protected Identity Information > Legal Last Name

Demographics > Identity > Last Name

Identity.lastName

First Name

First name of the student

Reports from the identity record active on the Count Date of the extract editor

If Legal Last Name = NOT NULL, report Legal First Name
If Legal First Name = NULL, report First Name

Alphanumeric, 15 characters

Demographics > Identity > Protected Identity Information > Legal First Name

Demographics > Identity > First Name

Identity.firstName

Middle Initial

Middle initial of the student

Reports from the identity record active on the Count Date of the extract editor

If Legal Last Name = NOT NULL, report Legal Middle Initial
If Legal Middle Name = NULL, report Middle Initial

Alphanumeric, 1 character

Demographics > Identity > Protected Identity Information > Legal Middle Name

Demographics > Identity > 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.

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

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

Elementary Extract (Michigan)

Report Logic

Extract Formats

Data Elements for the Elementary Extract

Related Articles