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 CSV output file does not include a header row.

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. The null fill value is ** (two asterisks).
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. Date values are formatted as YYYYMMDD.	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. The null fill value is ** (two asterisks).
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. The null fill value is ** (two asterisks).
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. The value uses an implied decimal format (9V99).	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. If the Unfilled FTE field is blank, the file prints blank values. If the value is 0.00, the file prints 000. FTE values are formatted without a decimal point. For example, a value of 1.23 is represented as 123 in the file, and a value of 2.00 is represented as 200.
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.