Staff Employment Report - File Layout and Data Mapping

The default file name for the Staff Employment report is IN Staff Employment Report_<MMDDYYYY>.csv.

The following table shows the columns, column names, descriptions, and data sources or valid values for the Staff Employment report.

Column	Column Name	Description	Data Source or Valid Values
A	ContractEdOrgId	A code identifying the building or site location, as defined by your state.	Retrieved from the State Location Code field on the Location Table page for the location corresponding to the employee's assigned location.
B	SPN	The Indiana state-assigned SPN (State Personnel Number) for the employee.	Retrieved from the SPN field on the Staff Information form of the IN Staff Employment Report page.
C	EmploymentStatusDescriptor	The employee's employment status.	Retrieved from the Employment Status field on the Staff Information form of the IN Staff Employment Report page.
D	HireDate	The employee's hire/contract start date for the school year.	Retrieved from the Hire Date field on the Staff Information form of the IN Staff Employment Report page.
E	EndDate	The employee's contract or employment end date for the school year.	Retrieved from the End Date field on the Staff Information form of the IN Staff Employment Report page.
F	FullTimeEquivalency	Full-time equivalent value representing the employee's work effort.	Retrieved from the FTE field on the Staff Information form of the IN Staff Employment Report page.
G	ContractDays	The number of days in the employee's contract for the school year.	Retrieved from the Contract Days field on the Staff Information form of the IN Staff Employment Report page.
H	ContractSalary	The employee's base contract salary amount for the school year.	Retrieved from the Contract Salary field on the Staff Information form of the IN Staff Employment Report page.
I	SupplementalSalary	Additional salary beyond the base contract.	Retrieved from the Supplemental Salary field on the Staff Information form of the IN Staff Employment Report page.
J	PercentTitleISalary	The percentage of the employee's salary funded by Title I.	Retrieved from the Percent Title I Salary field on the Staff Information form of the IN Staff Employment Report page.
K	YearsOfPriorProfessionalExperience	The employee's total years of professional experience.	Retrieved from the Professional Experience field on the Staff Information form of the IN Staff Employment Report page.