EMIS Staff Employment Report - File Layout and Data Mapping

The default file names for the EMIS Staff Employment Listing are:

PDF: EMIS Staff Employment_<MMDDYYYY>_<hhmmss>.pdf
Excel: EMIS Staff Employment_<MMDDYYYY>_<hhmmss>.csv

The following table shows the columns, field names, descriptions, and data source or valid values for the EMIS Staff Employment listing’s .csv file format.

Column	Field Name	Description	Data Source or Valid Values
A	EMPLOYEE NUMBER	The employee’s identification (ID) number.	Retrieved from the Employee Number field in the General Information section of the Employment tab on the EMIS Staff Report - Employment page.
B	EMPLOYEE NAME	The employee’s name. The format is last name, first name.	Retrieved from the Employee Name field in the General Information section of the Employment tab on the EMIS Staff Report - Employment page.
C	MAINTENANCE CODE	Indicates whether the record was added, updated, or deleted.	Valid values: A = Add U = Update D = Delete System-generated based on record activity on the EMIS Staff Report - Employment page.
D	POSITION START DATE	The date the employee began working in this specific position assignment.	Retrieved from the Start Date field on the Position Data tab of the Employment tab on the EMIS Staff Report - Employment page.
E	UNIQUE RECORD NUMBER	The system-generated unique sequential identifier for each employment record within the fiscal year and reporting period.	Retrieved from the Record Number field in the General Information section of the Employment tab on the EMIS Staff Report - Employment page.
F	RECORD LOCKED	Indicates whether the record can be updated or deleted.	Valid values: Y N Retrieved from the Lock Record field in the General Information section of the Employment tab on the EMIS Staff Report - Employment page.
G	RECORD TYPE	The record type identifier that indicates the EMIS data category.	The valid value is CK. Retrieved from the Sort Type field in the General Information section of the Employment tab on the EMIS Staff Report - Employment page.
H	DISTRICT IRN	The six-digit Information Retrieval Number that uniquely identifies the school district to the Ohio Department of Education.	Retrieved from the District IRN field in the General Information section of the Employment tab on the EMIS Staff Report - Employment page.
I	POSITION CODE	The three-character EMIS classification code that identifies the employee's job role.	Retrieved from the Position Assignment Code field on the Position Data tab of the Employment tab on the EMIS Staff Report - Employment page.
J	POSITION STATUS	Indicates the employee's current status in the position.	Valid values: C = Current position in the district A = Contracted personnel - Agency I = Contracted personnel - Individual P = Leave of absence U = No longer employed by district in this position Retrieved from the Position Status field on the Position Data tab of the Employment tab on the EMIS Staff Report - Employment page.
K	POSITION FULL TIME EQUIVALENCE	The Full-Time Equivalent value (0.00 to 1.00) representing the portion of a full-time position this assignment represents.	Retrieved from the Position FTE field on the Position Data tab of the Employment tab on the EMIS Staff Report - Employment page.
L	BUILDING IRN	The six-digit Information Retrieval Number identifying the school building or facility where the employee primarily performs their duties for this position.	Retrieved from the Building IRN field on the Position Data tab of the Employment tab on the EMIS Staff Report - Employment page.
M	APPOINTMENT TYPE	Indicates the employee's appointment classification.	Retrieved from the Type of Appointment field on the Contract Data tab of the Employment tab on the EMIS Staff Report - Employment page.
N	HOURS PER DAY	The total hours worked during a normal day, excluding lunch.	Retrieved from the Length of Work Day (Hours) field on the Contract Data tab of the Employment tab on the EMIS Staff Report - Employment page.
O	SCHEDULED DAYS	The total number of days the staff member is scheduled to work in the position during the year.	Retrieved from the Scheduled Work Days field on the Contract Data tab of the Employment tab on the EMIS Staff Report - Employment page.
P	AMOUNT/RATE	The pay rate for the position. Depending on the PAY TYPE field, this amount may be an hourly rate or an annual salary amount.	Retrieved from the Contracted Pay Amount/Rate field on the Contract Data tab of the Employment tab on the EMIS Staff Report - Employment page.
Q	PAY TYPE	The type of contract pay.	Retrieved from the Contracted Pay Type field on the Contract Data tab of the Employment tab on the EMIS Staff Report - Employment page.
R	EXTENDED SERVICE DAYS	The number of days or the full-time equivalency for which the supplemental salary is claimed.	Retrieved from the Extended Service field on the Contract Data tab of the Employment tab on the EMIS Staff Report - Employment page.
S	SEPARATION CODE	The reason the staff member left the position.	Retrieved from the Separation Reason field on the Miscellaneous tab of the Employment tab on the EMIS Staff Report - Employment page.
T	CONTRACT CODE	The unique number assigned by the school district that distinguishes among multiple contracts for a staff member within the same position code.	Retrieved from the Local Contract Code field on the Miscellaneous tab of the Employment tab on the EMIS Staff Report - Employment page.
U	LOWEST GRADE ASSIGNED	The lowest grade in the range this staff member is assigned to teach or supervise.	Retrieved from the Grade Level Assigned: Low field on the Miscellaneous tab of the Employment tab on the EMIS Staff Report - Employment page.
V	HIGHEST GRADE ASSIGNED	The highest grade in the range this staff member is assigned to teach or supervise.	Retrieved from the Grade Level Assigned: High field on the Miscellaneous tab of the Employment tab on the EMIS Staff Report - Employment page.
W	SPECIAL EDUCATION FTE	The total number of days the staff member is scheduled to work in the position during the year.	Retrieved from the Special Education FTE field on the Position Data tab of the Employment tab on the EMIS Staff Report - Employment page.
X	FIRST FUND PERCENTAGE	The percentage of funding for Fund Source 1.	Retrieved from the Percentage 1 field on the Fund Source tab of the Employment tab on the EMIS Staff Report - Employment page.
Y	FIRST FUND	The fund source for the assignment.	Retrieved from the EMIS Fund 1 field on the Fund Source tab of the Employment tab on the EMIS Staff Report - Employment page.
Z	ASSIGNMENT AREA	The employee’s EMIS position for the position and contract code.	Retrieved from the Assignment Areas field on the Miscellaneous tab of the Employment tab on the EMIS Staff Report - Employment page.
AA	SECOND FUND PERCENTAGE	The percentage of funding for Fund Source 2.	Retrieved from the Percentage 1 field on the Fund Source tab of the Employment tab on the EMIS Staff Report - Employment page.
AB	SECOND FUND	The fund source for the assignment.	Retrieved from the EMIS Fund 2 field on the Fund Source tab of the Employment tab on the EMIS Staff Report - Employment page.
AC	THIRD FUND PERCENTAGE	The percentage of funding for Fund Source 3.	Retrieved from the Percentage 3 field on the Fund Source tab of the Employment tab on the EMIS Staff Report - Employment page.
AD	THIRD FUND	The fund source for the assignment.	Retrieved from the EMIS Fund 3 field on the Fund Source tab of the Employment tab on the EMIS Staff Report - Employment page.
AE	POSITION TYPE	The type of employment with the school board.	Retrieved from the Position Type field on the Contract Data tab of the Employment tab on the EMIS Staff Report - Employment page.
AF	QUALIFIED PARAPROFESSIONAL	Indicates if the staff member is a qualified paraprofessional under the No Child Left Behind Act.	Retrieved from the Qualified Paraprofessional field on the Miscellaneous tab of the Employment tab on the EMIS Staff Report - Employment page.
AG	SEPARATION DATE	The last date of employment of the staff member for the specific position.	Retrieved from the Separation Date field on the Miscellaneous tab of the Employment tab on the EMIS Staff Report - Employment page.