Tool Search:10/30 Extracts

The 10/30 Secondary Extract reports students 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 10/30 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	> 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 being counted 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 school Alphanumeric, 20 characters	School Information > 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 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 > 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

> 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 being counted

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 school

Alphanumeric, 20 characters

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

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