Tool Search: MT Data Upload
The Terms of Employment Upload allows districts to import staff employment and assignment data. It utilizes staff state ID numbers and demographics data to confirm identities. 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.
Staff demographic data is compared to existing data to determine when to create a new staff demographic record. Employment and assignment data can still be imported for existing staff members.
An Employment Assignment Location record is created when importing Employment Assignments.
Upload Layout
| Data Element | Description | Location |
|---|---|---|
| Record Type | The abbreviation for the type of file generated. This reports as TE. Alphanumeric, 2 characters (TE) | N/A |
| District Number | The unique identifier assigned to the district by the OPI. String, 4 digits | District Information > State District Number District.number |
| Staff State ID | The staff members unique statewide staff identification number. String, 9 digits | Demographics > Staff State ID Identity.staffStateID |
| Last Name | The legal last name of the staff member. Alphanumeric | Demographics > Last Name Identity.lastName |
| First Name | The legal first name of the staff member. Alphanumeric | Demographics > First Name Identity.firstName |
| Gender | The gender of the staff member. Alphanumeric, 1 character (M or F) | Demographics > Gender Identity.gender |
| District Employment Start Date | The start date of the staff member in the district. Date field, 10 characters (MM/DD/YYYY) | District Employment > Start Date Employment.startDate |
| District Employment End Date | The end date of the staff member in the district. Date field, 10 characters (MM/DD/YYYY) | District Employment > End Date Employment.endDate |
| District Assignment Start Date | The start date of the staff member in the school. Date field, 10 characters (MM/DD/YYYY) | District Assignment > Start Date EmplymentAssignment.startDate |
| District Assignment End Date | The end date of the staff member in the school. Date field, 10 characters (MM/DD/YYYY) | District Assignment > End Date EmplymentAssignment.endDate |
| District Assignment School | The unique school number assigned by the OPI. String, 4 characters | District Assignment > School School.number |
| State Assignment Code | The state assignment code. When the code is TCXX (where XX is any two numbers), reports from the Teacher checkbox. String, 4 characters | District Assignment > Assignment Code District Assignment > Teacher EmploymentAssignment.code EmploymentAssignment.teacher |
| FTE | Indicates what portion of the employee's FTE percent this district assignment represents. Numeric, 6 digits (XXX.XX) | District Assignment > FTE of Assignment EmploymentAssignment.FTE |
