Type 2 Record Layout
The default file name for the Annual Staff report is mdstaff.tpe.
The following table lists the data item, field name, description, length, and position.
Data Item | Field Name | Description | Length | Position |
|---|---|---|---|---|
Record Type | -Not Applicable | 2 = Type 2 All full-time and part-time staff members on the payroll are actively assigned as of the end date. In addition, all professional staff and Title I funded, nonprofessional staff who resigned or left the school system must have a Type 1 record between the start and end dates. If an individual’s time is split between locations, school numbers, budget codes, or position types, prorate the person’s salary and report the additional information in subsequent Type 2 records. If an individual spends 90% or more of their time on the first assignment, 100% of their FTE is reported in the Type 1 record. | 1 | 1 |
LEA | LEA | The two-digit state designation of the local education agency. | 2 | 2-3 |
School Number | Building | The four-digit code assigned to the school building. A separate record must be reported for each school if a person is assigned to multiple schools. For staff whose duties are mainly assigned at the central/regional office level (location code 1) and other (location code 7), the data field for the school number must be left blank. | 4 | 4-7 |
Unique Statewide Identifier | Staff ID | The ten-digit State Assigned Teacher Identification (SATID) assigned in the Unique Teacher Identifier System (UTIS). Position codes 01 through 28 only. | 10 | 8-17 |
Local Employee Number | Employee Number | Local assigned employee number. Right-justified with a leading zero. | 10 | 18-27 |
Filler | Not Applicable | Blank | 5 | 28-32 |
Social Security Number | Social Security | Last four digits of the Social Security Number (SSN). | 4 | 33-36 |
Location | Location | The one-digit location code for the level at which the employee is working. Valid values:
| 1 | 37 |
Budget | Budget | For all budget codes, right zero-fill the data field up to 10 digits. For example, you should enter 20121 as 2012100000. A staff member's position and budget codes must logically match. Not for staff who resigned or left the school system between the start and end dates. | 10 | 38-47 |
Position | Position | The two-digit code for assignment level of position. Valid values:
A staff member's position and budget codes should logically match each other. For example, a librarian is not given a budget code of 20310 for school counselors. If a person's position type does not fit into any of the categories, choose a similar position for the person. | 2 | 48-49 |
Salary | Salary | Report the portion of the annual salary for each part of the position to the nearest dollar. For staff who have multiple records (one Type 1 and one or more Type 2 records), the parts of the salary must add up to the total salary. This field should be right-justified and zero-filled. Not for staff who resigned or left the school system on or after the start date. | 6 | 50-55 |
Targeted Assistance School (TAS) FTE | Not Applicable | Four-digit full-time equivalent status (expressed to three decimal points) for staff funded by a Title I, Part A Targeted Assistance School (TAS) Program. For staff who work with TAS and school-wide (SW) programs, report only the FTE attributable to their TAS responsibilities. Leave this field blank for staff who are not Title I. Required for all Title I TAS professional and nonprofessional staff who are active or have left the school system between the start and end dates. | 4 | 56-59 |
Title I Paraprofessional | Not Applicable | Indicates whether the staff person is Title I [serving in a school-wide (SW) Title I school or funded by Title I Targeted Assistance (TAS)] and is a paraprofessional as defined by Title I, Part A. Staff in position codes 26-28 or other positions that are considered paraprofessionals may not be Title I paraprofessionals, even though they serve in a Title I SW school or are funded by Title I TAS. Title I paraprofessionals must meet the definition of either instructional or non-instructional paraprofessionals below. Valid values:
Required for all professional and nonprofessional staff who are active or have left the school system between the beginning and end dates. | 1 | 60 |
Title I Qualified Paraprofessional | Not Applicable | Required for all Title I instructional paraprofessionals. Paraprofessionals are qualified if they meet all of the following requirements:
Valid values:
Instructional Paraprofessionals only, Title I Paraprofessional = I. | 1 | 61 |