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. Leave this column blank. This is a system-generated row ID and does not need to be imported. |
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 |