EMIS Employee Positions Report - File Layout and Data Mapping

The default file names for the EMIS Employee Positions report are:

PDF: EMIS Employee Positions Report_<MMDDYYYY>_<hhmmss>.pdf
Excel: EMIS Employee Positions Report_<MMDDYYYY>_<hhmmss>.csv

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

Column	Field Name	Description	Data Source or Valid Values
A	EMPLOYEE NUMBER	The unique employee identification number assigned to the employee.	Retrieved from the Employee Number field on the Employee Information page.
B	SOCIAL SECURITY NUMBER	The employee's Social Security number.	Retrieved from the Social Security field on the Employee Information page.
C	EMPLOYEE ID	The unique state-assigned code for the employee.	Retrieved from the EMIS Employee ID field on the EMIS Position Information page.
D	EMPLOYEE NAME	The employee’s name. The format is last name, first name.	Retrieved from the Last Name and First Name fields on the Employee Information page.
E	LOCAL JOB CLASS	The local job class.	Retrieved from the Job Class field on the EMIS Position Information page.
F	POSITION CODE	The code associated with the employee's position assignment.	Retrieved from the EMIS Position field on the EMIS Position Information page.
G	POSITION STATUS	The employee's current employment relationship with the school board in that particular 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 EMIS Position Information page.
H	POSITION LOCATION	The local building.	Retrieved from the Position Location field on the EMIS Position Information page.
I	BUILDING IRN	The state-assigned six-digit Information Retrieval Number (IRN) of the building.	Retrieved from the Building IRN field on the EMIS Position Information page.
J	BUILDING NAME	The name of the building.	Retrieved from the Building Name field on the Location Table page.
K	SPECIAL ED 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 EMIS Position Information page.
L	POSITION FTE	The full-time equivalency of the position expressed as a percentage.	Retrieved from the Position FTE field on the EMIS Position Information page.
M	POSITION PERCENT1	The percentage of funding for Fund Source 1.	Retrieved from the first Percent field on the EMIS Position Information page.
N	POSITION FUND 1	The fund source for the assignment.	Valid values: A = State Auxiliary Funds B = Other State Funds F = Special Education K12 Part-B IDEA Federal Grant Funds G = Title I Funds I = State Poverty-Based Assistance Funds, formerly DPIA J = Federal Early Learning Initiative Program Funds L = Local Funds and/or State Foundation Funds N = TANF, Temporary Assistance to Needy Families O = Other Federal Funds P = Special Education PK Part B IDEA Federal Grant Funds S = State Funds – Early Childhood Education Programs T = Private/Tuition U = State Unit Funding X = Reading First Federal Grant Funds Z = Preschool State Unit Funding Retrieved from the first EMIS Fund field on the EMIS Position Information page.
O	POSITION PERCENT2	The percentage of funding for Fund Source 2.	Retrieved from the second Percent field on the EMIS Position Information page.
P	POSITION FUND 2	The fund source for the assignment.	Valid values: A = State Auxiliary Funds B = Other State Funds F = Special Education K12 Part-B IDEA Federal Grant Funds G = Title I Funds I = State Poverty-Based Assistance Funds, formerly DPIA J = Federal Early Learning Initiative Program Funds L = Local Funds and/or State Foundation Funds N = TANF, Temporary Assistance to Needy Families O = Other Federal Funds P = Special Education PK Part B IDEA Federal Grant Funds S = State Funds – Early Childhood Education Programs T = Private/Tuition U = State Unit Funding X = Reading First Federal Grant Funds Z = Preschool State Unit Funding Retrieved from the second EMIS Fund field on the EMIS Position Information page.
Q	POSITION PERCENT3	The percentage of funding for Fund Source 3.	Retrieved from the third Percent field on the EMIS Position Information page.
R	POSITION FUND 3	The fund source for the assignment.	Valid values: A = State Auxiliary Funds B = Other State Funds F = Special Education K12 Part-B IDEA Federal Grant Funds G = Title I Funds I = State Poverty-Based Assistance Funds, formerly DPIA J = Federal Early Learning Initiative Program Funds L = Local Funds and/or State Foundation Funds N = TANF, Temporary Assistance to Needy Families O = Other Federal Funds P = Special Education PK Part B IDEA Federal Grant Funds S = State Funds – Early Childhood Education Programs T = Private/Tuition U = State Unit Funding X = Reading First Federal Grant Funds Z = Preschool State Unit Funding Retrieved from the third EMIS Fund field on the EMIS Position Information page.
S	PRIMARY POSITION	Indicates that this position record stores associated demographic information.	Retrieved from the Primary EMIS position field on the EMIS Position Information page.
T	ATTENDANCE DAYS OVERRIDE	The value in this field overrides the attendance days value calculated during the Staff report load process. For more information about how attendance days are calculated, refer to EMIS absence calculation for districts calculating leave in hours.	Retrieved from the Demo (CI) Attendance Days Override field on the EMIS Position Information page.
U	USE ATT DAYS OVERRIDE	Indicates whether the value in the ATTENDANCE DAYS OVERRIDE field is used as an override.	Retrieved from the Check to use this override value field on the EMIS Position Information page.
V	ABSENCE DAYS OVERRIDE	The value in this field overrides the absence days value calculated during the Staff report load process. For more information about how absence days are calculated, refer to EMIS absence calculation for districts calculating leave in hours.	Retrieved from the Demo (CI) Absence Days Override field on the EMIS Position Information page.
W	USE ABS DAYS OVERRIDE	Indicates whether the value in the ABSENCE DAYS OVERRIDE field is used as an override.	Retrieved from the Check to use this override value field on the EMIS Position Information page.
X	LONG TERM DAYS	The number of long-term illness days.	Retrieved from the Demo (CI) Longterm Days field on the EMIS Position Information page.
Y	EARLY CHILD	The Early Childhood Education Qualification status.	Valid values: * = Not applicable 1 = Associate’s 2 = Bachelor’s 3 = Enrolled Associate’s 4 = Enrolled Bachelor’s 5 = Enrolled Master’s 6 = Master’s Retrieved from the Demo (CI) Early Childhood field on the EMIS Position Information page.
Z	PRINCIPAL EXPERIENCE YEARS	The number of years of experience as a Principal.	Retrieved from the Demo (CI) Principal Experience Years field on the EMIS Position Information page.
AA	POSITION TYPE	The type of employment with the school board.	Valid values: R = Regular T = Temporary S = Supplemental Retrieved from the Position Type field on the EMIS Position Information page.
AB	APPOINTMENT TYPE	The classification of the staff member's position.	Valid values: 1 = Certificated 2 = Classified 3 = Internship 5 = Veteran Retrieved from the Type of Appointment field on the EMIS Position Information page.
AC	HOURS PER DAY	The total hours worked during a normal day, excluding lunch.	Retrieved from the Length of Work Day (Hours) field on the EMIS Position Information page.
AD	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 EMIS Position Information page.
AE	PAY TYPE	The type of contract pay.	Valid values: H = Hourly rate A = Annual salary Retrieved from the Contracted Pay Type field on the EMIS Position Information page.
AF	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 Contract Pay Amount/Rate field on the EMIS Position Information page.
AG	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 EMIS Position Information page.
AH	ASSIGNMENT	The six-digit code that specifies and defines the position.	Valid values: 000000 = No assignment area applied 99050 = Art Education K-8 99140 = Title I Programs 999350 = Food Services 999365 = LEP Instructional Program 999370 = General Education 999380 = Gifted & Talented 999412 = Preschool Special Educati 999414 = Special Education K-12 999418 = Physical Eduction K-8 999520 = Maintenance/Const/Grounds 999570 = Music Education K-8 999725 = Vocational Sped Coordinat 999790 = Transportation Services 999800 = CT Programs/Pathways 999805 = CT Ed-Apprenticeship Prog 999895 = CT Asses Specialist SVCS Retrieved from the Assignment Area field on the EMIS Position Information page.
AI	START DATE	The date the staff member began work in this position.	Retrieved from the Start Date field on the EMIS Position Information page.
AJ	SEPARATION DATE	The last date of employment of the staff member for the specific position.	Retrieved from the Separation Date field on the EMIS Position Information page.
AK	SEPARATION CODE	The reason the staff member left the position.	Valid values: * = Not Applicable 1 = Retirement 3 = Employer Initiated 4 = Test4 5 = Resigned-Other OH Educ Job 6 = Resigned - Out Of State 7 = Resigned-Other 8 = New Position In District 9 = Deceased Retrieved from the Separation Reason field on the EMIS Position Information page.
AL	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 Contract Code field on the EMIS Position Information page.
AM	GRADE LEVEL LOW	The lowest grade in the range this staff member is assigned to teach or supervise.	Valid values: = Not applicable PS = Preschool KG = Kindergarten 01 = First Grade 02 = Second Grade 03 = Third Grade 04 = Fourth Grade 05 = Fifth Grade 06 = Sixth Grade 07 = Seventh Grade 08 = Eighth Grade 09 = Ninth Grade 10 = Tenth Grade 11 = Eleventh Grade 12 = Twelfth Grade Retrieved from the Grade Level Assigned : Low** field on the EMIS Position Information page.
AN	GRADE LEVEL HIGH	The highest grade in the range this staff member is assigned to teach or supervise.	Valid values: = Not applicable PS = Preschool KG = Kindergarten 01 = First Grade 02 = Second Grade 03 = Third Grade 04 = Fourth Grade 05 = Fifth Grade 06 = Sixth Grade 07 = Seventh Grade 08 = Eighth Grade 09 = Ninth Grade 10 = Tenth Grade 11 = Eleventh Grade 12 = Twelfth Grade Retrieved from the Grade Level Assigned : High** field on the EMIS Position Information page.
AO	QUALIFIED PARAPROFESSIONAL	Indicates if the staff member is a qualified paraprofessional under the No Child Left Behind Act.	Valid values: * = Not Applicable N = Does not meet definition Y = Meets definition Retrieved from the Qualified Paraprofessional field on the EMIS Position Information page.
AP	DO NOT RPT POSITION TO EMIS	Indicates whether the position is excluded from EMIS reporting.	Retrieved from the Do not report to EMIS field on the EMIS Position Information page.
AQ	RPT TO EMIS	Indicates whether the position is included in EMIS reporting.	Retrieved from the Rpt to EMIS field on the Payroll Information - State Required page.