Tool Search: MT Extracts
The Spring Enrollment Extract contains data about spring attendance counts.
Spring Enrollment Count Extract EditorThe extract can be generated in the following formats:
- State Format (TSV)
- HTML
- CSV
- XML
Use the State Format when all data has been reviewed for accuracy and information is ready to be uploaded. Use one of the other formats for data review and testing.
Example of the Spring Enrollment Count Extract - HTML FormatGenerate the Spring Enrollment Count
- Select Spring Enrollment Count from the Extract Type dropdown list.
- Select the desired Format.
- Choose the desired calendars from the Calendar list.
- Click the Generate Report button. The extract will display in a new window in the selected format.
Header Layout
| Data Element | Description |
|---|---|
Record Type | The abbreviation for the type of file extract generated. This will always report as HD. Alphanumeric, 2 characters |
Date | The most recent date the file was generated. Date field, 10 characters, MM/DD/YYYY |
Time | The most recent time the file was generated. Time field, 8 characters, HH:MM:SS |
Version | The most current version of the file interface specification and references to the application system. This field will always report as MT9.1. Alphanumeric, 5 characters |
Extract Layout
Data Element | Description | Campus Database and UI Location |
|---|---|---|
RecordType | Always reports a value of "AS" which stands for Attendance Spring Count. Alphanumeric, 2 characters | N/A |
| DistrictNumber | Unique identifier assigned to the district by the OPI. String, 4 digits *Number is zero-padded when necessary. | District Information > State District Number District.number |
| SchoolNumber | This is a unique number assigned by the Office of Public Instruction that identifies the school into which the students are enrolled. Numeric, 4 digits | School Information > School Number School.number |
| CalendarNumber | This is a unique system number that identifies the calendar(s) chosen on the extract editor. Numeric, 1-3 digits | Calendar Information Calendar.number |
| StateID | The reporting student's unique 9-digit statewide student ID number. String, 9 characters *Number is zero-padded when necessary. | Demographics > Student State ID Person.stateID |
| LocalID | Unique student ID number assigned by the school of enrollment. Numeric, 15 digits | Demographics > Person Identifiers > Local Student Number Person.studentNumber |
| LastName | The reporting student's legal last name. Alphanumeric, 40 characters | Demographics > Last Name Person.lastName |
| FirstName | The reporting student's legal first name. Alphanumeric, 35 characters | Demographics > First Name Person.firstName |
| ExcludeSpringANB | Indicates the student will not be included in ANB calculations according to policy for one of the following reasons:
If ‘Exclude Spring ANB’ checkbox is checked, report Y. Else, report N or null. Alphanumeric, 1 character | Enrollments > State Reporting Fields > Exclude Spring ANB Enrollment.ruantSem2 |
| AggregateHoursofInstruction | The hours of pupil instruction for which a school course or program is offered or for which a pupil is enrolled. The Spring Aggregate Hours of Inst field must equal F, T, H, Q, N or null. String, 1 character | Enrollments > State Reporting Fields > Spring Aggregate Hours of Inst Enrollment.membershipSpringSnapshot |
| JobCorps | Indicates if the student is enrolled in Job Corps during the Spring Enrollment Count. Alphanumeric, 1 character | Enrollments > Job Corps Enrollment.jobCorpsSpring |
| MTYouthChalleNGe | Indicates if the student is enrolled in the MT Youth ChalleNGe during the Spring Enrollment Count. Alphanumeric, 1 character | Enrollments > MT Youth ChalleNGe Enrollment.mtYouthChallengeSpring |
| ageEligibleSpring | Report Y if Age 19 or 20 Eligible for ANB during the Spring Attendance Count is checked. Alphanumeric | Enrollments > Age 19 or 20 Eligible for ANB Enrollment.ageEligibleSpring |
| EarlyLiteracy | Indicates the student participated in an early literacy program in the spring. Alphanumeric, 1 character, Y or N | Enrollments > State Reporting Fields > Spring Early Literacy EnrollmentMT.earlyLiteracySpring |
| Year | The end year of the reporting school year (i.e., 2013 is reported for the 2012-2013 school year. String, 4 characters | Calendar Information > School Years > End Year Calendar.endYear |
