Tool Search: MT Extracts
The CTE End-of-Year Extract allows users to extract end-of-year CTE data for import into the Montana Edition of Infinite Campus.
Image 1: MT Extracts - CTE End of Year
Business Rules
- If a student has multiple active enrollment records in the selected calendar, export the most recent enrollment.
- This extract can be generated in both District and State Editions of Infinite Campus.
- State Edition users can extract the CTE End of Year file but cannot import this file directly into the State Edition.
Header Layout
Data Element | Description | Type, Format and Length |
|---|---|---|
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 |
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
The following lists the data elements and formats for the CTE End of Year Extract.
Data Element | Description | Format | Campus UI and Database |
|---|---|---|---|
Record Type | Always reports a value of 'CE'. | Alphanumeric, 2 characters | Not dynamically stored |
District Number | This is a unique system number that identifies the district uploading the information, assigned by the Montana Office of Public Instruction. | Numeric, 4 digits | District Information > State District Number District.number |
Student State ID | Unique student ID number assigned by OPI. | Numeric, 9 digits | Demographics > Student State ID Person.stateID |
Student Local ID | Unique student ID number assigned by the school of enrollment. | Numeric, 15 digits | Demographics > Local Student Number Person.studentNumber |
Last Name | Student's legal last name. | String, 50 characters | Demographics > Last Name Identity.lastName |
First Name | Student's legal first name. | String, 50 characters | Demographics > First Name Identity.firstName |
| Pathway | The career and technical education pathway the student is following. | String, 2-4 characters | State Programs > CTE Concentrator > Pathway CTEConcentrator.pathway |
| Concentrator | Indicates if the student is a Concentrator in the pathway. | Y / N | State Programs > CTE Concentrator > Concentrator CTEConcentrator.cteStatus |
| Single Parent | A student who is unmarried or legally separated from a spouse and has a minor child or children for which he/she has either custody/joint custody or is pregnant. | Y / N | State Programs > CTE Concentrator > Single Parent CTEConcentrator.singleParent |
| Pathway Credits | Total CTE credits earned in the pathway. | Numeric | State Programs > CTE Concentrator > Pathway Credits CTEConcentrator.pathwayCredits |
| District Credits | Total number of credits the student earned for the pathway within the current district. | Numeric | State Programs > CTE Concentrator > In District Credits CTEConcentrator.districtCredits |
| Non District Credits | Total number of credits the student earned for the pathway in schools outside of the current district. | Numeric | State Programs > CTE Concentrator > Out of District Credits CTEConcentrator.nonDistrictCredits |
| Dual Enrollment Credits | Total Dual Enrollment credits earned in the pathway. | Numeric | State Programs > CTE Concentrator > Dual Enrollment Credits CTEConcentrator.dualEnrollCredits |
| Work Based Learning Credits | Total Work Based Learning credits earned in the pathway. | Numeric | State Programs > CTE Concentrator > Work Based Learning Credits CTEConcentrator.workBasedCredits |
| Filler | Filler field | N/A | N/A |
| Year | The school year reporting data. This is the end year of the school year, so if reporting 2020-2021, the reported Year would be 2021. | Number | Calendar > End Year Calendar.endYear |
