Staff Extensions report - File Layout and Data Mapping

The default file name for the Staff Extensions report is edfi_staff_extensions.xlsx.

The following table shows the columns, column names, descriptions, and data sources or valid values for the Staff Extensions 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	Extension ID	The unique ID identifying the record.	Retrieved from the tx_staff_service.id field.
H	Entity Name	The name of the Ed-Fi entity.	Valid values: AuxiliaryRoleIDSet DaysEmployedSet ParaProfessionalCertificationSet StaffTypeSet Retrieved from the Entity Name field on the Staff Extensions tab of the Staff Information page.
I	Extension Begin Date	The beginning date of the Ed-Fi staff extension record.	Retrieved from the Begin Date field on the Staff Extensions tab of the Staff Information page.
J	Extension End Date	The ending date of the Ed-Fi staff extension record.	Retrieved from the End Date field on the Staff Extensions tab of the Staff Information page.
K	Field Name	The names of the field under the Ed-Fi entity.	For the AuxiliaryRoleIDSet entity, the valid value is AuxiliaryRoleID. For the DaysEmployedSet entity, the valid values are: NumberDaysEmployed PercentDayEmployed For the ParaProfessionalCertificationSet entity, the valid value is ParaprofessionalCertification. For the StaffTypeSet entity, the valid value is StaffType. Retrieved from the Field Name field on the Staff Extensions tab of the Staff Information page.
L	Field Value	The field value.	For the AuxiliaryRoleID field, the valid values are 000-999. For the ParaprofessionalCertification field, the valid values are: 0 = Employee is not certified 1 = Employee is certified For the StaffType field, the valid values are: 1 = District Employee 3 = Contracted Professional Staff 4 = Campus Charter Teacher Retrieved from the Field Value field on the Staff Extensions tab of the Staff Information page.
M	Field Description	The field description.	Retrieved from the Description field on the Staff Extensions tab of the Staff Information page.