Course/Section Extract (Michigan)

Tool Search:10/30 Extracts

The 10/30 Course/Section Extract reports student absences.

Report Logic

A record reports for each student with 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 an NCES Code entered.
If Present Minutes are entered during a period, that period is not considered when determining an absence. 
The report excludes courses dropped before the count date designated on the extract editor. 

Extract Formats

The 10/30 Course/Section Extract is generated in PDF or DOCX format. For directions on generating the extract, see the 1030 Extracts article.

Data Elements for the Course/Section 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 Information > School Years > Start Year/End Year


Calendar.endYear
Calendar.startYear

School Number

State school number


Numeric, 5 digits

School Information > State School Number


School.number

School Name

Name of school


Alphanumeric, 20 characters

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

Demographics > Person Information > Last Name


Identity.lastName

First Name

First name of the student


Alphanumeric, 15 characters

Demographics > Person Information > First Name


Identity.firstName

Middle Initial

Middle initial of the student


Alphanumeric, 1 character

Demographics > Person Information > Middle Name


Studentcontact.middleName

Grade

Grade level of enrollment


Numeric, 2 digits

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

  • If the student had an Unexcused Absence and the Date Returned is greater than 10 instructional days, the Date Returned is reported with a strikethrough.
  • If the student had an Excused Absence and the Date Returned is greater than 30 instructional days, the Date Returned is reported with a strikethrough.
  • If the Date Returned is after today's date, reports as blank space.
  • If the student is not actively rostered on the Date Returned, reports as DR: Did Not Return

Date field, MM/DD/CCYY

Student information > General > Attendance


Attendance.date

FTE 

Reports the sum of FTE in General Education, FTE Section 52, and FTE Section 53. If Date Returned reports as DR on all included course sections, FTE reports with a strikethrough



Numeric, #.##

Enrollment > State Reporting Fields > FTE in General Education, FTE Section 52, FTE Section 53


Calculated