Tool Search: MT Data Upload
The CTE End of Year Upload allows users to import end of year CTE data into the Infinite Campus Montana Edition.
Image 1: MT Uploads - CTE End of Year
Import Business Rules
- Student must have a primary, partial, or Special Ed enrollment in the district that matches the district and state IDs on the import.
- The enrollment must be within a calendar that has the same end year as the end year on the enrollment.
- Student can import data for multiple pathways.
- Each pathway would appear as a row of data
- Students can have multiple rows in the file
- Students are allowed only one row per pathway.
- Pathway Credits must equal the sum of District Credits + Transfer Credits.
- The report can be run against a district’s active year as well as any prior year.
- The report can be run against calendars in prior years however only the current data within the CTE Concentrator state program tab, for students enrolled for those calendars, will report. There will not be a way to have a snapshot of the CTE Concentrator program data in prior years.
- The import can be used in district edition only.
- CTE Concentrator data imported into Campus District Edition or Montana Edition sites will sync to 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 |
Upload Layout
The following lists the data elements and formats for the CTE End of Year Upload.
The Retrieve New Student State ID File option is only relevant to Student Demographic uploads. Please ignore this option.
Data Element | Description | Format | Campus UI and Database |
|---|---|---|---|
Record Type | The abbreviation for the type of file upload entered. Must equal '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 |
