Tool Search: MT Extracts
The Section Student Detail Extract reports Section Student Detail data. This extract matches the Section Student Detail Upload.
Tool Rights
Read - Generate extract.
Write - N/A
Add - N/A
Delete - N/A
Report logic
This report can run against a district’s active year and any prior year, and in both District Edition and State Edition against District Edition data.
File formats
The extract can be generated in the following formats:
- State Format (TSV)
- HTML
- CSV
- XML
Layouts
Header Layout
| Data Element | Description |
|---|---|
| Record Type | The abbreviation for the type of file generated. This reports as DU. Alphanumeric, 2 characters (DU) |
| Date | The most recent date a change was made on the file or the date the file was generated. Date field, 10 characters (MM/DD/YYYY) |
| Time | The most recent time a change was made on the file or the date 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 reports as MT9.1. Alphanumeric, 5 characters (MT9.1) |
Upload Layout
| # | Data element label | Description | Database location |
|---|---|---|---|
| 1 | Record Type | The abbreviation for the type of file generated. This reports as DU. Alphanumeric, 2 characters (DU) | N/A |
| 2 | District Number | The unique identifier assigned to the district by the OPI. String, 4 characters | District Information > State District Number District.number |
| 3 | School Number | The unique identifier assigned to the school by the OPI. String, 4 characters | School Information > State School Number School.number |
| 4 | Calendar Number | The unique calendar identifier. String, 3 characters | Calendar > Number Calendar.number |
| 5 | Course Number | The number assigned to the course. String, 13 characters | Course > Course Number Course.number |
| 6 | Section Code | The section number assigned to the specific section. Numeric, 4 digits | Section Information > Section Number Section.number |
| 7 | Session Type | The session type. Numeric, 2 digits | Section Information > State Defined > Session Type Section.sessionType |
| 8 | Session Number | The session number. Alphanumeric, 2 characters | Section Information > State Defined > Session Number Section.sessionNumber |
| 9 | State ID | The unique student ID number assigned by OPI. Numeric, 9 digits | Demographics > Person Identifiers > State ID Person.stateID |
| 10 | Student First Name | The student's first name. Alphanumeric, 50 characters | Demographics > Person Information > First Name Identity.firstName |
| 11 | Student Last Name | The student's last name. Alphanumeric, 50 characters | Demographics > Person Information > Last Name Identity.lastName |
| 12 | Eligible For Credit | Indicates if the student is eligible for transcript credit upon completion of a dual credit course. Alphanumeric, 1 character (Y or N) | Course Information > Section Student Detail > Eligible for Transcript Credit SectionStudentDetail.dualCredit |
| 13 | AP/IB Score | The score the student received on their AP/IB assessment. Reports as 3, 4, 5, 6, or 7. Numeric, 2 digits | Course Information > Section Student Detail > AP/IB Score SectionStudentDetail.apipScore |
| 14 | IB Assessment Level | The assessment level a student took for their IB Assessment. Alphanumeric, 2 characters | Course Information > Section Student Detail > IB Assessment Level SectionStudentDetail.ibAssessmentLevel |
| 15 | Year | The end year of the course. String, 4 characters (YYYY) | Calendar > School Year School.year |
