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).
When fields 1, 2, 3, 7, 8, and 10 match, the existing record District Assignment End Date is NOT null, and when the import file Start Date is greater than the existing record End Date, a new District Assignment record is created.
When fields 1, 2, 3, 7, 8, and 10 match, the existing record District Assignment End Date is NOT null, and when the import file Start Date is less than the existing record End Date, the import errors.
When the import file District Assignment Start Date does NOT match, AND the import file End Date is less than the existing record Start Date, a new, historic District Employment record is created.
When the import file District Assignment Start Date does NOT match, AND the import file End Date is null, the import errors.
Overlapping rosters are NOT allowed.
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 |
