The default file name for the sample Excel template is Vacancy_Import_Sample.xlsx.
Column names beginning with an asterisk (*) are required.
The following table shows the columns, column names, and descriptions for the sample Excel template.
|
Column |
Column Name |
Description |
Required? |
|---|---|---|---|
|
A |
*CR050 Building IRN |
The six-digit ODE Institutional Revenue Number (IRN) identifying the building where the vacancy exists. Must match a valid IRN on file with ODE. |
Yes |
|
B |
CR060 Former Staff ID |
The ODE-assigned EMIS staff ID of the employee who previously held the position. Leave blank if the position was newly created with no prior occupant. |
No |
|
C |
Former Employee Number |
The district's internal employee number for the former staff member. Used to cross-reference the employee record in PowerSchool ERP. |
No |
|
D |
*CR070 Position Code |
The EMIS-defined code for the type of position that became vacant (for example, classroom teacher, administrator, or support staff). Must be a valid EMIS position code. |
Yes |
|
E |
CR080 Subject Area |
The EMIS subject area code associated with the vacant position. Required when the position is instructional. Leave blank for non-instructional positions. |
No |
|
F |
CR090 New Staff ID |
The ODE-assigned EMIS staff ID of the employee hired to fill the vacancy. Leave blank if the vacancy has not yet been filled. |
No |
|
G |
New Employee Number |
The district's internal employee number for the new staff member. Used to cross-reference the employee record in PowerSchool ERP. |
No |
|
H |
CR100 Date Vacancy Filled |
The date the position was filled. Leave blank if the vacancy remains open. |
No |
|
I |
CR110 Grade Low |
The lowest grade level served by the vacant position (for example, KG, 01, 09). Use EMIS-defined grade level codes. |
No |
|
J |
CR120 Grade High |
The highest grade level served by the vacant position. Must be equal to or greater than the value in CR110 Grade Low. |
No |
|
K |
*CR130 Vacancy Reason |
The EMIS-defined code indicating why the position became vacant. Common values include retirement, resignation, non-renewal, and termination. |
Yes |
|
L |
CR140 Unfilled FTE |
The portion of the position's authorized full-time equivalent (FTE) that remains unfilled. Enter as a decimal value (for example, 0.5 for half-time). Leave blank or enter 0.00 if the vacancy has been filled. |
No |
|
M |
*CR150 Vacancy Filled Method |
The EMIS-defined code indicating how the vacancy was filled (for example, new hire, transfer from within the district, or long-term substitute). Leave blank if the vacancy is unfilled. |
Yes |