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

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

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.

  • If the student has not yet returned to the class period, this field will remain blank
  • If the student has a roster End Date for all periods 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 in all periods 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/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