CI Record Layout

In the CI record:

Attendance, Absence, and Long Term Illness days are only populated with actual values during the L (End of Year) reporting period; otherwise, they are exported as 0000.
The Days fields are multiplied by 10 to preserve one decimal place (e.g., 180.5 becomes 1805).
The EMIS Employee ID field can contain either the State Staff ID or the Employee Number, depending on whether Use Employee ID is selected on the Staff Information tab of the EMIS Data Export page.

For more information about the CI record layout, refer to Section 3.3 of the EMIS Manual.

The following table lists the numbers, names, descriptions, positions, lengths, and data source or valid values for the CI record.

Number	Name	Description	Position	Length	Data Source or Valid Values
Not applicable	filler	Leave blank	1-8	7	spaces
CI010	Sort Type	Identifies the record type.	9-10	2	The valid value is CI and is system-generated.
Not applicable	filler	Leave blank	11	1	spaces
CI020	Fiscal year	The reporting fiscal year.	12-15	4	Retrieved from the Staff Fiscal Year field on the EMIS Profile page.
CI030	Reporting Period	The reporting period of the fiscal year.	16	1	Valid values: N = Beginning of the year L = End of the year Retrieved from the Staff Reporting Period field on the EMIS Profile page.
CI040	District IRN	The six-digit state-assigned Information Retrieval Number (IRN).	17-22	6	Retrieved from the District IRN field on the EMIS Profile page.
CI050	Employee ID	The EMIS employee number.	23-31	9	Retrieved from the Employee Number field on the Employee Information page when Use Employee ID is selected on the Staff Information tab of the EMIS Data Export page. Retrieved from the Staff State ID field on the Personnel tab of the Employee Information page when Use Employee ID is not selected on the Staff Information tab of the EMIS Data Export page.
Not applicable	filler	Leave blank	32-82	51	spaces
CI070	Date of Birth	The employee's birth date.	83-90	8	Retrieved from the Birthdate field on the Employee Information page.
CI080	Racial/Ethnic group	The employee’s racial or ethnic group.	91	1	Valid values: W = White, Non-Hispanic B = Black or African American (Non-Hispanic) H = Hispanic/Latino A = Asian I = American Indian or Alaska Native P = Native Hawaiian or Other Pacific Islander M = Multiracial N = Not Specified Calculated from the field values on the Race/Ethnicity tab of the Employee Information page and the Race Code Table page. If the value in the Ethnicity field on the Race/Ethnicity tab of the Employee Information page is H - Hispanic or Latino, this value is set to H. If multiple races are selected in the Race field on the Race/Ethnicity tab of the Employee Information page, this value is set to M. For other races or ethnicities, the value is crosswalked using the Race Code Table page.
CI090	Gender	The employee's gender.	92	1	Valid values: M - Male F - Female The field value is retrieved from the Sex at Birth field on the Employee Information page.
CI100	Education level	The employee's highest degree.	93	1	Valid values: 0 = Non-degree 1 = Associate 2 = Bachelors 3 = Masters 4 = Education Specialist 5 = Doctorate 6 = Other 7 = Less than High School Diploma 8 = High School Diploma 9 = GED Diploma Retrieved from the Highest field on the Degree Data page, and crosswalked using the Degree Table page.
CI110	Semester hours	The semester hours for the employee's highest degree.	94-96	3	The valid value is the sum of Credits on the Degree Data page.
CI225	Early Childhood Education Qualification	Identifies how the teacher instructing an Early Childhood Education Entitlement program meets the requirements specified under 3301-37-04 (j) or 3301.311.	97	1	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 page.
Not applicable	filler	Leave blank	98	1	spaces
CI140	Attendance days	The total number of days the staff member was in attendance from July 1 through June 30.	99-102	4	Calculated from the Days Worked field value on the Pay Rate Information page, minus absence days. or Retrieved from the Demo (CI) Attendance Days Override field on the EMIS Position Information page if Check to use this override value is selected. The final calculated value is Attendance days × 10 (e.g., 180.5 days = 1805). This field displays zeros if the Reporting Period value is N.
CI150	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.	103-106	4	Calculated from leave history or Retrieved from the Demo (CI) Absence Days Override field on the EMIS Position Information page if Check to use this override value is selected. The final calculated value is Absence days × 10 (e.g., 5.5 days = 0055). This field displays zeros if the Reporting Period value is N.
CI155	Absence days – Longterm Illness	At least 15 consecutive days absent due to an illness of the staff member, their spouse, child, or parent.	107-110	4	Retrieved from the Demo (CI) Longterm Days field on the EMIS Position Information page. The final calculated value is Long-term illness days × 10. This field displays zeros if the Reporting Period value is N.
Not applicable	filler	Leave blank	111-114	4	spaces
CI200	Authorized teaching experience years	The total years of authorized teaching experience.	115-116	2	Retrieved from the Years in State field on the Employment tab of the Employee Information page.
CI210	Total experience years in education	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).	117-118	2	Retrieved from the Years in Total field on the Employment tab of the Employee Information page.
CI270	State staff ID	The employee's unique state-wide ID 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.	119-127	9	Retrieved from the State Staff ID field on the Personnel tab of the Employee Information page.
Not applicable	filler	Leave blank	128-133	6	spaces
CI290	First name	The employee's first name.	134-178	45	Retrieved from the First Name field on the Employee Information page.
CI300	Middle name	The employee's middle name.	179-208	30	Retrieved from the Middle Name field on the Employee Information page.
CI310	Last name	The employee's last name.	209-253	45	Retrieved from the Last Name field on the Employee Information page.
Not applicable	filler	Leave blank	254-259	6	spaces
CI330	Principal experience years	The total years of experience as a Principal.	260-261	2	Retrieved from the Demo (CI) Principal Experience Years field on the EMIS Position Information page.