Tool Search: MT Data Upload
The District Assignment Upload allows districts to import district assignment data. Acceptable import formats are .TXT and .TSV. This import allows for the creation of new records and updating existing records with a Primary Key match. See the MT Data Upload article for more information about this tool.
See the District Assignment 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.
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.
Staff demographic and assignment data is compared to existing data to determine when to create a new staff demographic record.
District assignment data can be imported for existing staff members. When a District Assignment record exists for a staff member, data is conditionally imported/overwritten with a Primary Key match. Primary Key fields include fields 1, 2, 3, 7, 8, and 10 (Record Type, District Number, Staff State ID, District Assignment School, District Assignment Start Date, and Assignment Code).
Overlapping records are allowed when one or more District Assignment records exist for the staff member. When fields 1, 2, 3, 7, and 10:
- do not match, but
- The Assignment Code contained in the import file does not match the Assignment Code of an existing record in Campus; the new assignment record imports for the staff/district/school/assignment code.
- The Assignment Code contained in the import file matches, but the District/School contained in the import file does NOT match; a new assignment record for this staff/district/school/assignment code imports.
- match, then logic checks to see if fields 1, 2, 3, 7, 8, 9, and 10 are an exact match,
- When they match, the existing record is updated/overwritten with the data in the import file. Field 9 is unconditionally updated. Fields 12, 13, and 14 only update when the existing record contains N values and the import file contains Y values. The existing record Y is never overwritten with an N.
- When they do NOT match,
- when field 8 (District Assignment Start Date) matches the existing Campus record, but field 9 (District Assignment End Date) does NOT match,
- when the End Date in the import is blank, and the existing record in Campus contains an End Date, an error occurs, and this field is not updated.
- when the End Date in the import files is NOT blank, and the existing record in Campus is blank, an update occurs. Fields 12, 13, and 14 only update when the existing record contains N values and the import file contains Y values. The existing record Y is never overwritten with an N.
- when fields 8 and 9 in the import file are less than the District Assignment Start date in the existing Campus record, a new historic record is imported.
- when fields 8 and 9 in the import file are greater than the District Assignment End Date in the existing Campus record, a new record is imported.
- when field 8 (District Assignment Start Date) matches the existing Campus record, but field 9 (District Assignment End Date) does NOT match,
Upload Layout
Header Layout
| Data Element | Description |
|---|---|
| Record Type | The abbreviation for the type of file generated. This reports as HD. Alphanumeric, 2 characters (HD) |
| 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 |
|---|---|---|---|
| 1 | Record Type | The abbreviation for the type of file generated. This reports as DA. Alphanumeric, 2 characters (DA) | N/A |
| 2 | District Number | The unique identifier assigned to the district by the OPI. String, 4 characters | District Information > State District Number District.number |
| 3 | Staff State ID | The staff member's state identification number. Numeric, 9 digits | Demographics > State Staff ID Identity.staffStateID |
| 4 | Last Name | The staff member's last name. Alphanumeric | Census > Last Name Identity.lastName |
| 5 | First Name | The staff member's first name. Alphanumeric | Census > First Name Identity.firstName |
| 6 | Gender | The staff member's gender. Alphanumeric, 1 character (M or F) | Census > Gender Identity.gender |
| 7 | District Assignment School | The unique school number assigned by OPI. Alphanumeric, 4 characters | Census > District Assignment > School School.number |
| 8 | District Assignment Start Date | The start date of the staff member in the district. Alphanumeric, 10 characters (MM/DD/YYYY) | Census > District Assignment > Start Date EmploymentAssignment.startDate |
| 9 | District Assignment End Date | The end date of the staff member in the district. Alphanumeric, 10 characters (MM/DD/YYYY) | Census > District Assignment> End Date EmploymentAssignment.enddate |
| 10 | Assignment Code | The assignment code of the staff member Alphanumeric, 4 characters | Census > District Assignment> State Assignment Code EmploymentAssignment.assignmentCode |
| 11 | FTE | The full-time employment of the staff member. Numeric, 5 digits (XXX.XX) | Census > District Assignment > FTE EmploymentAssignment.FTE |
| 12 | Teacher | Indicates the staff member is a teacher. Alphanumeric, 1 character (Y or N) | Census > District Assignment > Teacher EmploymentAssignment.teacher |
| 13 | Special Ed | Indicates the staff member is a special ed teacher. Alphanumeric, 1 character (Y or N) | Census > District Assignment > Special Education EmploymentAssignment.specialEd |
| 14 | Supervisor | Indicates the staff member is a supervisor. Alphanumeric, 1 character (Y or N) | Census > District Assignment > Supervisor EmploymentAssignment.supervisor |
