Tool Search: MT Data Upload
The Course Upload allows districts to import course data. Acceptable import formats are .TXT and .TSV. See the MT Data Upload article for more information about this tool.
Import Records
See the Uploading Files section of the MT Data Upload article for detailed information about importing records via the MT Data Upload tool.
The Retrieve New Student State ID File option is only relevant to Student Demographic uploads. Please ignore this option when uploading staff data.
Upload Logic
This report can run against a district’s active year as well as any prior year and in both District Edition and State Edition against District Edition data.
Course data is compared to existing data to determine when to create a new course record. Course data CANNOT be imported for existing courses.
Upload Layout
Header Layout
| Data Element | Description |
|---|---|
| Record Type | The abbreviation for the type of file generated. This reports as CU. Alphanumeric, 2 characters (CU) |
| 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 | Description | Location |
|---|---|---|
| Record Type | The abbreviation for the type of file generated. This reports as CU. Alphanumeric, 2 characters (CU) | N/A |
| District Number | The unique identifier assigned to the district by the OPI. String, 4 characters | District Information > State District Number District.number |
| School Number | The unique identifier assigned to the school by the OPI. String, 4 characters | School Information > State School Number School.number |
| Calendar Number | The unique calendar identifier. String, 3 characters | Calendar > Number Calendar.number |
| Course Number | The number assigned to the course. String, 13 characters | Course > Course Number Course.number |
| Course | The name of the course. Alphanumeric, 30 characters | Course > Course Name Course.name |
| SCED Subject Area | The SCED subject area number assigned to the course. Numeric, 2 digits | Course > SCED Subject Area Course.scedSubjectArea |
| SCED Course Identifier | The SCED course identifier assigned to the course. Numeric, 3 digits | Course > SCED Course Identifier Course.scedCourseID |
| SCED Lowest Grade | The lowest grade level offered for a specific course. String, 3 characters | Course > SCED Lowest Grade Course.scedLowestGrade |
| SCED Highest Grade | The highest grade level offered for a specific course. String, 3 characters | Course > SCED Lowest Grade Course.scedHighestGrade |
| Available Carnegie Unit Credit | The amount of credit available to a student who successfully meets the objectives of the course. It is a measure of "seat time" rather than a measure of attainment of the course objectives. String, 8 characters (XXXXX.XXX) | Course > Available Carnegie Unit Credit Course.scedAvailableCredit |
| SCED Course Level | The secondary course's level of rigor. String, 2 characters | Course > SCED Course Level Course.scedCourseLevel |
| SCED Sequence | The manner in which schools may break up complex content. String, 2 characters | Courser > SCED Sequence Course.scedSequenceNum |
| SCED Sequence Total | The total possible sequence. String, 2 characters | Courser > SCED Sequence Course.scedSequenceMax |
| Distance Class | Indicates this is a distance learning course. String, 1 character (Y or N) | Course > Distance Class Course.distanceCode |
| Dual Enrollment Credit | Indicates this is a dual enrollment credit course. String, 1 character (Y or N) | Course > Dual Enrollment Credit Coruse.dualEnrollmentCourse |
| Alternate Ed Program | Indicates this is an alternate education program course. String, 1 character (Y or N) | Course > Alternate Ed Program CustomCourse.value |
| Year | The end year of the course. String, 4 characters (YYYY) | Calendar > School Year School.year |
