TEA Staff Responsibilities - File Layout and Data Mapping
The TEA Staff Responsibilities import file format is .csv.
The following table shows the data's column names, descriptions, and destination database fields in the TEA Staff Responsibilities import file.
Column | Name | Description | Destination Database Field (table.field) |
|---|---|---|---|
A | Begin Date | The date the employee started the assignment. | tx_staff_assignment.begin_date |
B | End Date | The date the employee completed the assignment. To delete an existing record, the End Date must be earlier than the date the file is imported. | tx_staff_assignment.end_date |
C | School ID | The school identification number registered with the TEA. The valid values are stored in the School ID field on the PEIMS School Table page. | tx_staff_assignment.school_id |
D | Shared Service | The two-digit code for the shared service type. The valid values are stored in the Shared Service Type field on the PEIMS Shared Service Arrangement Types Table page. | tx_staff_assignment.shared_service |
E | Staff Classification | The three-digit code for the staff classification. The valid values are stored in the Staff Classification field on the PEIMS Staff Classification Table page. | tx_staff_assignment.staff_classification |
F | Staff ID | The employee’s social security number, without dashes. | tx_staff_assignment.staff_id |
G | Begin Date | The date the employee started service. | tx_staff_service.begin_date |
H | End Date | The date the employee completed service. To delete an existing record, the End Date must be earlier than the date the file is imported. | tx_staff_service.end_date |
I | ID | The unique ID identifying the record. | tx_staff_service.id |
J | Monthly Minutes | The total number of minutes the employee works in a month. | tx_staff_service.monthly_minutes |
K | Number of Students | The number of students in the employee's class. | tx_staff_service.numb_students |
L | Population Served | The code identifying the type of students with whom the employee works. The valid values are stored in the Population field on the PEIMS Population Table page. | tx_staff_service.population_served |
M | Service ID | The code identifying the employee's PEIMS service. The valid values are stored in the Staff Service field on the PEIMS Staff Service Table page. | tx_staff_service.service_id |
N | Special Education Student Age Range | The age range of Special Education students to whom teaching and paraprofessional staff provide services. Valid values:
| tx_staff_service.sped_age_range |
