Tool Search: MT Extracts
The Program Participation Extract reports information on student program participation.
Program Participation 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.
HTML ExampleGenerate the Program Participation Extract
- Select the Program Participation option 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 PP. Alphanumeric, 2 characters |
Date | The most recent date the file was generated. Date field, 10 characters |
Time | The most recent time the file was generated. Time field, 8 characters |
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 Interface |
|---|---|---|
Record Type | Always reports a value of "PP" which stands for Program Proficiency. Alphanumeric, 2 characters | N/A |
| District Number | 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 |
| School Number | A unique number assigned by the Office of Public Instruction that identifies the school into which the students are enrolled. Numeric, 4 digits | School > School Number School.number |
| Calendar Number | A unique system number that identifies the calendar(s) chosen on the extract editor. Numeric, 1-3 digits | Calendar > Calendar Info Calendar.number |
| Student's State ID | 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 |
| Student's Local ID | Unique student ID number assigned by the school of enrollment. Numeric, 15 digits | Demographics > Person Identifiers > Student ID Person.studentID |
| Last Name | The reporting student's legal last name. Alphanumeric, 40 characters | Demographics > Last Name Person.lastName |
| First Name | The reporting student's legal first name. Alphanumeric, 35 characters | Demographics > First Name Person.firstName |
| Section 504 | Indicates the student is part of a Section 504 plan. 1 character, Y or N | Enrollments > State Reporting Fields > Section 504 Enrollment.section504 |
| Title I Participation | Indicates the student participates in a Title I program. If the student reports a value of Y, the student must have at least one instructional service marked. 1 character, Y or N | Enrollments > State Reporting Fields > Title 1 Enrollment.title1 |
| Title I Reading | Indicates the student is receiving services in a Title I Reading program. The Title I field must report Y. 1 character, Y or N | Enrollments > State Reporting Fields > Title 1 Instructional Services > Reading Lang Arts Enrollment.title1Reading |
| Title I Math | Indicates the student is receiving services in a Title I Math program. The Title I field must report Y. 1 character, Y or N | Enrollments > State Reporting Fields > Title 1 Instructional Services > Math Enrollment.title1Math |
| Title I Science | Indicates the student is receiving services in a Title I Science program. The Title I field must report Y. 1 character, Y or N | Enrollments > State Reporting Fields > Title 1 Instructional Services > Science Enrollment.title1Science |
| Title I Social Sciences | Indicates the student is receiving services in a Title I Social Sciences program. The Title I field must report Y. 1 character, Y or N | Enrollments > State Reporting Fields > Title 1 Instructional Services > Social Sciences Enrollment.title1Civics |
| Title I Vocational/Career | Indicates the student is receiving services in a Title I Vocational/Career program. The Title I field must report Y. 1 character, Y or N | Enrollments > State Reporting Fields > Title 1 Instructional Services > Vocational/Career Enrollment.title1Career |
| Title I Instructional Other | Indicates the student is receiving services in a Title I Target Assistance Program in an Instructional program that is a component of a Title I program and is not defined as any other instructional program listed. The Title I field must report Y. 1 character, Y or N | |
| Title I Health | Indicates the student is receiving services in a Title I Health program. The Title I field must report Y. 1 character, Y or N | Enrollments > State Reporting Fields > Title 1 Support Services > Health, Dental and Eye Care Enrollment.title1Health |
| Title I Guidance/Advocacy | Indicates the student is receiving services in a Title I Guidance/Advocacy program. The Title I field must report Y. 1 character, Y or N | Enrollments > State Reporting Fields > Title 1 Support Services > Guidance/Advocacy Enrollment.title1Counseling |
| Title I Support Other | Indicates the student is receiving services in a Title I Target Assistance Program in a Support program that is a component of a Title I program that is not defined as any other support program listed. The Title I field must report Y. 1 character, Y or N | Enrollments > State Reporting Fields > Title 1 Support Services > Other Enrollment.title1ServicesOther |
| Title I Part A Neglected | Indicates the student is considered Title I Part A Neglected 1 character, Y or N | Enrollments > State Reporting Fields > Title 1 Part A Neglected Enrollment.neglected |
| Title I Part D Delinquent | Indicates the student is considered Title I Part D Delinquent. 2 string characters | Enrollments > State Reporting Fields > Title I Part D Delinquent EnrollmentMT.delinquent |
| Foreign Exchange | Indicates the student is a foreign exchange student. A student marked Foreign Exchange cannot be marked as an Immigrant. 1 character, Y or N | Enrollments > State Reporting Fields > Foreign Exchange Enrollment.foreignStudent |
| Gifted and Talented Evaluated | Indicates the student has been evaluated for gifted/talented. 1 character, Y or N | Enrollments > State Reporting Fields > Gifted and Talented Evaluated Enrollment.giftedTalentedEval |
| Gifted and Talented Identified | Indicates the student is considered gifted/talented. 1 character, Y or N | Enrollments > State Reporting Fields > Gifted/Talented Identified Enrollment.giftedTalented |
| Homeless | Indicates the student is considered homeless. A student is homeless if they lack a fixed, regular and adequate nighttime residence. 1 character, Y or N | Enrollments > State Reporting Fields > Homeless Enrollment.homeless |
| Homeless Night Time Residence | Indicates the type of nighttime residence for the homeless student. If Homeless reports as null, this field will also report as null. String, 2 characters | Enrollments > State Reporting Fields > Homeless Night Time Residence Enrollment.homelessResidence |
| Unaccompanied Youth | Indicates if the student is not in the physical custody of a parent or guardian. If Homeless reports as null, this field will also report as null. 1 character, Y or N | Enrollments > State Reporting Fields > Unaccompanied Youth Enrollment.unaccompaniedYouth |
| Immigrant | Indicates the student is considered an immigrant.
1 character, Y or N | Enrollments > State Reporting Fields > Immigrant Enrollment.immigrant |
| Immigrant Date Entered US School | The date the student first enrolled in a US school.
Date field, 10 characters MM/DD/YYYY | Enrollments > State Reporting Fields > Date Immigrant Entered US School Enrollment.immigrantDate |
| Military Connected Status | Indicates if the student is a dependent of a member of the U.S. Armed Services. Reported values include:
Numeric, 1 character | Enrollments > State Reporting Fields > Military Connected Status Enrollment.militaryConnectedStatus |
| Twenty First Century | Exports the student's Twenty First Century value. 1 character, Y or N | Enrollment Enrollment.twentyFirstCentury |
| Year | The end year of the reporting school year (i.e., 2013 is reported for the 2012-2013 school year. String, 4 characters | School Years > End Year Calendar.endYear |
