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 | Campus | The code identifying the employee's campus. | tx_staff_assignment.campus_id |
B | Role | The code identifying the employee's role. | tx_staff_assignment.role_id |
C | Staff ID | The employee’s social security number, without dashes. | tx_staff_assignment.staff_id |
D | Texas Unique Staff ID | The employee's Unique ID number provided by TEA's Texas Student Data System (TSDS) Unique ID system. | tx_staff_assignment.staff_uid |
E | Begin Date | The date the employee started the assignment. | tx_staff_service.begin_date |
F | Class ID | Identification for the employee's class. | tx_staff_service.class_id |
G | Class Type | The employee's class type. | tx_staff_service.class_type |
H | End Date | The date the employee completed the assignment. | tx_staff_service.end_date |
I | ESC SSA Staff Indicator | Single-digit ESC SSA (Shared Services Arrangement) staff indicator code. For a school district, this field is blank. | tx_staff_service.esc_ssa_stf_ind |
J | Grade Level | The grade level taught by the employee. | tx_staff_service.grade_level_cd |
K | Monthly Minutes | The total number of minutes the employee works in a month. | tx_staff_service.monthly_minutes |
L | Week 1 Days Taught | The days taught during week 1. | tx_staff_service.num_days_wk1 |
M | Week 2 Days Taught | The days taught during week 2. | tx_staff_service.num_days_wk2 |
N | Week 3 Days Taught | The days taught during week 3. | tx_staff_service.num_days_wk3 |
O | Week 4 Days Taught | The days taught during week 4. | tx_staff_service.num_days_wk4 |
P | Week 1 Minutes Taught | The minutes taught during week 1. | tx_staff_service.num_mins_wk1 |
Q | Week 2 Minutes Taught | The minutes taught during week 2. | tx_staff_service.num_mins_wk2 |
R | Week 3 Minutes Taught | The minutes taught during week 3. | tx_staff_service.num_mins_wk3 |
S | Week 4 Minutes Taught | The minutes taught during week 4. | tx_staff_service.num_mins_wk4 |
T | Number of Students | The number of students in the employee's class. | tx_staff_service.numb_students |
U | Population | The code identifying the type of students with whom the employee works. | tx_staff_service.population_served |
V | Service ID | The code identifying the employee's PEIMS service. | tx_staff_service.service_id |
W | Special Education Student Age Range | The age range of Special Education students that teaching and paraprofessional staff provide services to. | tx_staff_service.sped_age_range |