Tool Search: MT Data Upload
The Section Student Detail Upload imports Section Student Detail information from their existing system into Infinite Campus Montana Edition. This import compares student and section information to validate the import data, and can be used to import new and update existing records.
See the Section Student Detail Extract article for information on the matching report for this import.
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.
Upload logic
This upload can run against a district’s active year and any prior year. This upload can be used for State Edition, District Edition, and Montana Edition users.
Section Student Detail data is compared to existing data to determine when to create a new course record.
When a section already has a Section Student Detail record for the import student, the data is imported/updated using a Primary Key Match on fields 1-9 (District Number, School Number, Calendar Number, Course Number, Section Code, Session Type, Session Number, and Student StateID).
Acceptable import formats include TXT and TSV.
Layout
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 must be DU. Alphanumeric, 2 characters (DU) | N/A |
| 2 | District Number | The unique identifier assigned to the district by the OPI. When null, an error occurs. String, 4 characters | District Information > State District Number District.number |
| 3 | School Number | The unique identifier assigned to the school by the OPI. When null, an error occurs. String, 4 characters | School Information > State School Number School.number |
| 4 | Calendar Number | The unique calendar identifier. When null, an error occurs. String, 3 characters | Calendar > Number Calendar.number |
| 5 | Course Number | The number assigned to the course. When null, an error occurs. 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. Must be 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. This must match the selected year. String, 4 characters (YYYY) | Calendar > School Year School.year |
