Terms of Employment Extract (Montana)

Tool Search: MT Extracts

The Terms of Employment Extract contains information related to student roster data. This extract matches the Term of Employment Upload import file.

Screenshot of the Terms of Employment Extract Editor.Terms of Employment Extract Editor

Tool Rights

Read - Generate extract.
Write - N/A
Add - N/A
Delete - N/A

Report 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.

File Formats

The extract can be generated in the following formats:

  • State Format (TSV)
  • HTML
  • CSV
  • XML

Use the State Format when all data has been reviewed for accuracy and information is ready to be uploaded. Use one of the other formats for data review and testing. 

Generate Extract

  1. Select the Terms of Employment option from the Extract Type dropdown list.
  2. Select the desired Format from the dropdown list.
  3. Choose the desired calendar(s) from the Calendar list. 
  4. Click the Generate Report button. When HTML is selected, the extract opens in a new window; for other formats, it downloads instead.

Example

Screenshot of a Terms of Employment HTML Example.Terms of Employment HTML Example

Layout

#Data ElementDescriptionLocation
1Record TypeThe abbreviation for the type of file generated. This reports as TE.

Alphanumeric, 2 characters (TE)
N/A
2District NumberThe unique identifier assigned to the district by the OPI.

String, 4 digits
District Information > State District Number

District.number
3Staff State IDThe staff members unique statewide staff identification number.

String, 9 digits
Demographics > Staff State ID

Identity.staffStateID
4Last NameThe legal last name of the staff member.

Alphanumeric
Demographics > Last Name

Identity.lastName
5First NameThe legal first name of the staff member.

Alphanumeric
Demographics > First Name

Identity.firstName
6GenderThe gender of the staff member.

Alphanumeric, 1 character (M or F)
Demographics > Gender

Identity.gender
7District Employment Start DateThe start date of the staff member in the district.

Date field, 10 characters (MM/DD/YYYY)
District Employment > Start Date

Employment.startDate
8District Employment End DateThe end date of the staff member in the district.

Date field, 10 characters (MM/DD/YYYY)
District Employment > End Date

Employment.endDate