EMIS Staff Vacancy Report - File Layout and Data Mapping

The default file name for the EMIS Staff Vacancy report is OH EMIS Staff Vacancy Report_<Fiscal Year>.csv.

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

Column	Column Name	Description	Data Source or Valid Values
A	CR010	Record sort type identifier used to order the file output	The valid value is CR.
B	CR020	The fiscal year the vacancy record applies to	Populated during the file creation process. Retrieved from the Fiscal Year field on the Staff Vacancy Information form of the EMIS Staff Vacancy Report page.
C	CR030	Data set identifier associated with the submission	The valid value is L.
D	CR040	The district's Information Retrieval Number (IRN)	Populated during the file creation process. Retrieved from the District IRN field on the EMIS Profile page.
E	CR050	The IRN of the school building where the vacancy occurred	Populated during the file creation process. Retrieved from the Building IRN field on the Staff Vacancy Information form of the EMIS Staff Vacancy Report page.
F	CR060	The state staff ID of the employee who vacated the position	Populated during the file creation process. Retrieved from the Former Staff ID field on the Staff Vacancy Information form of the EMIS Staff Vacancy Report page.
G	CR070	The EMIS position code of the vacated position	Populated during the file creation process. Retrieved from the Position Code field on the Staff Vacancy Information form of the EMIS Staff Vacancy Report page.
H	CR080	The subject area associated with the vacated position	Populated during the file creation process. Retrieved from the Subject Area field on the Staff Vacancy Information form of the EMIS Staff Vacancy Report page.
I	CR090	The state staff ID of the new employee who filled the vacancy	Populated during the file creation process. Retrieved from the New Staff ID field on the Staff Vacancy Information form of the EMIS Staff Vacancy Report page.
J	CR100	The date the vacancy was filled	Populated during the file creation process. Retrieved from the Date Vacancy Filled field on the Staff Vacancy Information form of the EMIS Staff Vacancy Report page.
K	CR110	The lowest grade level served by the position	Populated during the file creation process. Retrieved from the Grade Low field on the Staff Vacancy Information form of the EMIS Staff Vacancy Report page.
L	CR120	The highest grade level served by the position	Populated during the file creation process. Retrieved from the Grade High field on the Staff Vacancy Information form of the EMIS Staff Vacancy Report page.
M	CR130	The reason code indicating why the position became vacant	Populated during the file creation process. Retrieved from the Vacancy Reason field on the Staff Vacancy Information form of the EMIS Staff Vacancy Report page.
N	CR140	The full-time equivalency of the position if it remains unfilled	Populated during the file creation process. Retrieved from the Unfilled FTE field on the Staff Vacancy Information form of the EMIS Staff Vacancy Report page.
O	CR150	The method used to fill the vacancy (or UN if unfilled)	Populated during the file creation process. Retrieved from the Vacancy Fill Method field on the Staff Vacancy Information form of the EMIS Staff Vacancy Report page.