EMIS Staff Demographic Listing - File Layout and Data Mapping

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

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

The following table shows the columns, field names, descriptions, and data source or valid values for the EMIS Staff Demographic listing’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 Demographic tab of the EMIS Staff Report page.
B	EMPLOYEE NAME	The employee’s name. The format is last name, first name.	Retrieved from the Last Name and First Name fields on the Demographic tab of the EMIS Staff Report page.
C	MAINTENANCE CODE	Not applicable	Valid values: A = Add U = Update D = Delete System-generated based on record activity on the EMIS Staff Report page.
D	EMPLOYEE BIRTH DATE	The employee's birth date.	Retrieved from the Date of Birth field on the Demographic tab of the EMIS Staff Report page.
E	UNIQUE RECORD NUMBER	The unique system-generated record number.	Retrieved from the Record Number field on the Demographic tab of the EMIS Staff Report page.
F	RECORD STATUS	Indicates whether the record is Active.	The valid value is A. Retrieved from the Record Status field on the Demographic tab of the EMIS Staff Report page.
G	RECORD TYPE	Identifies the record type.	The valid value is CI. Retrieved from the Sort Type field on the Demographic tab of the EMIS Staff Report page.
H	DISTRICT IRN	The six-digit state-assigned Information Retrieval Number (IRN).	Retrieved from the District IRN field on the Demographic tab of the EMIS Staff Report page.
I	EMIS ETHNIC CODE	The employee’s racial or ethnic group.	Retrieved from the Racial/Ethnic Category field on the Demographic tab of the EMIS Staff Report page.
J	EMIS GENDER CODE	The employee's gender.	Retrieved from the Gender field on the Demographic tab of the EMIS Staff Report page.
K	DISTRICT YEARS EXPERIENCE	Total years of authorized teaching experience.	Retrieved from the Authorized Experience Years field on the Demographic tab of the EMIS Staff Report page.
L	TOTAL YEARS EXPERIENCE	Indicates the total years of all certificated/licensed educational service (authorized and non-authorized) in elementary schools, secondary schools, colleges, universities, and other public or non-public educational institutions (including the Peace Corps).	Retrieved from the Total Experience Years field on the Demographic tab of the EMIS Staff Report page.
M	PRINCIPAL EXPERIENCE YEARS	The total years of experience as a Principal.	Retrieved from the Principal Experience Years field on the Demographic tab of the EMIS Staff Report page.
N	EMIS DEGREE CODE	The employee's highest degree.	Retrieved from the Education Level field on the Demographic tab of the EMIS Staff Report page.
O	SEMESTER HOURS EARNED	The semester hours for the employee's highest degree.	Retrieved from the Semester Hours field on the Demographic tab of the EMIS Staff Report page.
P	EARLY CHILDHOOD EDUCATION	Identifies how the teacher instructing an Early Childhood Education Entitlement program meets the requirements specified under 3301-37-04 (j) or 3301.311.	Retrieved from the Early Childhood Education field on the Demographic tab of the EMIS Staff Report page.
Q	ATTENDANCE DAYS	The total number of days the staff member was in attendance from July 1 through June 30.	Retrieved from the Attendance Days field on the Demographic tab of the EMIS Staff Report page.
R	ABSENCE DAYS	The total number of days the staff member was absent from July 1 through June 30 for any reason other than professional meetings, vacations, or holidays.	Retrieved from the Absence Days - Total field on the Demographic tab of the EMIS Staff Report page.
S	LONGTERM ILLNESS DAYS	At least 15 consecutive days absent due to an illness of the staff member, their spouse, child, or parent.	Retrieved from the Long Term Illness field on the Demographic tab of the EMIS Staff Report page.
T	OH CREDENTIAL ID	Unique statewide ID used to match a staff member's data to EMIS data from previous reporting periods. This ID is also used in state certification and licensure databases.	Retrieved from the OH State Staff ID field on the Demographic tab of the EMIS Staff Report page.