Contractor/Contractor Staff Data Report - File Layout And Data Mapping

The default file names for the Contractor/Contractor Staff Data report are:

PDF: EMIS Staff Contractor_<MMDDYYYY_hhmmss>.pdf
Excel: EMIS Staff Contractor_<MMDDYYYY_hhmmss>.csv

The following table shows the columns, column names, descriptions, and data sources or valid values for the Contractor/Contractor Staff Data report’s .csv file format.

Column	Column Name	Description	Data Source or Valid Values
A	RECORD NUMBER	A system-generated unique identifier for each contractor record in the EMIS Staff Report.	Retrieved from the Record Number field on the CJ and CC Information tab on the General Information form of the EMIS Staff Report - Contractor page.
B	RECORD STATUS	Indicates the current status of the contractor record.	The valid value is A. Retrieved from the Record Status field on the CJ and CC Information tab on the General Information form of the EMIS Staff Report - Contractor page.
C	SORT TYPE	Identifies the type of contractor record	Valid values: CJ CC Retrieved from the Sort Type field on the CJ and CC Information tab on the General Information form of the EMIS Staff Report - Contractor page.
D	FISCAL YEAR	The Ohio fiscal year for which the contractor record applies.	Retrieved from the Fiscal Year field on the CJ and CC Information tab on the General Information form of the EMIS Staff Report - Contractor page.
E	REPORTING PERIOD	The EMIS reporting period for the contractor record.	The valid value is L. Retrieved from the Reporting Period field on the CJ and CC Information tab on the General Information form of the EMIS Staff Report - Contractor page.
F	DISTRICT IRN	The six-digit Information Retrieval Number (IRN) assigned by the Ohio Department of Education to identify the reporting district.	Retrieved from the District IRN field on the CJ and CC Information tab on the General Information form of the EMIS Staff Report - Contractor page.
G	EMPLOYEE NUMBER	The district's internal employee number for the contracted staff member. Applies to CJ records only.	Retrieved from the Employee Number field on the CJ and CC Information tab on the General Information form of the EMIS Staff Report - Contractor page.
H	EMIS STAFF ID	The Ohio EMIS-assigned unique identifier for the staff member (also known as the State Staff ID). Applies to CJ records only.	Retrieved from the EMIS Employee ID field on the CJ and CC Information tab on the General Information form of the EMIS Staff Report - Contractor page.
I	POSITION CODE	The three-character EMIS Position Assignment Code that identifies the type of work or role the contractor performs	Retrieved from the Position Code field on the CJ and CC Information tab on the General Information form of the EMIS Staff Report - Contractor page.
J	CONTRACTING DISTRICT IRN	The six-digit IRN of the district or Educational Service Center (ESC) that employs the contracted staff member and provides them to the reporting district.	Retrieved from the Contracting District IRN field on the CJ and CC Information tab on the General Information form of the EMIS Staff Report - Contractor page.
K	FTE	The Full-Time Equivalency representing the proportion of a full-time position the contracted staff member works at the reporting district. Applies to CJ records only.	The valid values are 0.00 to 9.99. Retrieved from the FTE field on the CJ and CC Information tab on the General Information form of the EMIS Staff Report - Contractor page.
L	LOCAL CONTRACT CODE	The district-defined code used to identify and group contractor records for local tracking and reporting purposes.	Retrieved from the Contract Code field on the CJ and CC Information tab on the General Information form of the EMIS Staff Report - Contractor page.
M	FEDERAL TAX ID	The nine-digit Federal Employer Identification Number (FEIN) assigned to the contracting company or organization by the IRS. Applies to CC records only.	Retrieved from the Federal Tax ID field on the CC Information tab on the General Information form of the EMIS Staff Report - Contractor page.
N	CONTRACTOR NAME	The legal name of the company, organization, or entity providing contracted services to the district. Applies to CC records only.	Retrieved from the Contractor Name field on the CC Information tab on the General Information form of the EMIS Staff Report - Contractor page.
O	DOLLAR AMOUNT OF CONTRACT	The total monetary value of the contract for the current fiscal year. Applies to CC records only.	Retrieved from the Contract Amount field on the CC Information tab on the General Information form of the EMIS Staff Report - Contractor page.
P	CONTRACT START DATE	The date on which the contractual agreement begins and the contractor starts providing services to the district. Applies to CC records only.	Retrieved from the Contract Start Date field on the CC Information tab on the General Information form of the EMIS Staff Report - Contractor page.
Q	CONTRACT END DATE	The date on which the contractual agreement concludes and the contractor stops providing services under the current contract terms. Applies to CC records only.	Retrieved from the Contract End Date field on the CC Information tab on the General Information form of the EMIS Staff Report - Contractor page.
R	HOURS PER WEEK	The average number of hours per week that services are provided under the contract. Applies to CC records only.	Retrieved from the Hours Per Week field on the CC Information tab on the General Information form of the EMIS Staff Report - Contractor page.
S	POSITION FUND SOURCE	The EMIS funding source code indicating how the contracted position/service is funded. Applies to CC records only.	The valid values are A, B, F, G, H, I, J, L, N, O, P, S, T, X, and Y. Retrieved from the Position Fund Source field on the CC Information tab on the General Information form of the EMIS Staff Report - Contractor page.
T	SERVICE PERFORMED	Indicates whether the contract requires specific services to be performed as a condition of the agreement. Applies to CC records only.	Valid values: Y N Retrieved from the Based on Service Performed field on the CC Information tab on the General Information form of the EMIS Staff Report - Contractor page.
U	WORK HOURS	Indicates whether the contract requires a specific number of hours of services to be provided as a condition of the agreement. Applies to CC records only.	Valid values: Y N Retrieved from the Based on Work Hours field on the CC Information tab on the General Information form of the EMIS Staff Report - Contractor page.
V	NUMBER OF PEOPLE	Indicates whether the contract requires a specific number of individuals to be provided or served as a condition of the agreement. Applies to CC records only.	Valid values: Y N Retrieved from the Based on Number of People field on the CC Information tab on the General Information form of the EMIS Staff Report - Contractor page.