Staff Responsibilities report - File Layout and Data Mapping
The default file name for the Staff Responsibilities report is edfi_staff_responsibilities.xlsx.
The following table shows the columns, column names, descriptions, and data sources or valid values for the Staff Responsibilities report.
Column | Column Name | Description | Data Source or Valid Values |
---|---|---|---|
A | Employee Number | The employee’s identification (ID) number. | Retrieved from the Employee Number field on the Demographic tab of the Staff Information page. |
B | Staff ID | The employee’s social security number, without dashes. | Retrieved from the Staff ID field on the Demographic tab of the Staff Information page. |
C | First Name | The employee’s first name. | Retrieved from the First Name field on the Demographic tab of the Staff Information page. |
D | Middle Name | The employee’s middle name. | Retrieved from the Middle Name field on the Demographic tab of the Staff Information page. |
E | Last Name | The employee's last name. | Retrieved from the Last Name field on the Demographic tab of the Staff Information page. |
F | Generation | The employee’s generation suffix. | Retrieved from the Generation field on the Demographic tab of the Staff Information page. |
G | School ID | The school identification number registered with the TEA. | Retrieved from the School ID field on the Staff Responsibilities tab of the Staff Information page. |
H | Staff Classification | The three-digit code for the staff classification. | Retrieved from the Staff Classification field on the Staff Responsibilities tab of the Staff Information page. |
I | Assignment Begin Date | The date the employee started the assignment. | Retrieved from the Assignment Begin Date field on the Staff Responsibilities tab of the Staff Information page. |
J | Assignment End Date | The date the employee completed the assignment. | Retrieved from the Assignment End Date field on the Staff Responsibilities tab of the Staff Information page. |
K | Shared Service | The two-digit code for the shared service type. | Retrieved from the Shared Service field on the Staff Responsibilities tab of the Staff Information page. |
L | Staff Service | The code identifying the employee's PEIMS service. | The valid values are stored on the PEIMS Staff Service Table page. Retrieved from the Staff Service field on the Staff Responsibilities tab of the Staff Information page. |
M | Special Education Student Age Range | The age range of Special Education students to whom teaching and paraprofessional staff provide services. | Valid values:
Retrieved from the SPED Student Age Range field on the Staff Responsibilities tab of the Staff Information page. |
N | Population | The code identifying the type of students with whom the employee works. | Retrieved from the Population field on the Staff Responsibilities tab of the Staff Information page. |
O | Monthly Minutes | The total number of minutes the employee works in a month. | Retrieved from the Monthly Minutes field on the Staff Responsibilities tab of the Staff Information page. |
P | Number of Students | The number of students in the employee's class. | Retrieved from the Number of Students field on the Staff Responsibilities tab of the Staff Information page. |
Q | Service Begin Date | The date the employee started service. | Retrieved from the Service Begin Date field on the Staff Responsibilities tab of the Staff Information page. |
R | Service End Date | The date the employee completed service. | Retrieved from the Service End Date field on the Staff Responsibilities tab of the Staff Information page. |