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: 00 - Not Providing Services to SPED Students 01 - Providing Services to SPED Students Ages 3 - 5 (not in KG) 02 - Providing Services to SPED Students Ages 5 (in KG) - 21 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.