Contractor or Contractor Staff - Upload File Format

The expected file names are:

Workstation upload file: emiscontractorwk.csv
Server upload file: emiscontractor.csv

The following table shows the columns, column names, descriptions, and data sources or valid values for the Contractor or Contractor Staff Upload file.

Column	Column Name	Description	CC (Contractor)	CJ (Contracted Staff)
A	Sort Type	Identifies the type of contractor record. Valid values: CJ CC	Required	Required
B	Fiscal Year	The Ohio fiscal year for which the contractor record applies.	Required	Required
C	Reporting Period	The EMIS reporting period for the contractor record. The valid value is L.	Required	Required
D	EMIS Employee ID	The Ohio EMIS-assigned unique identifier for the staff member (also known as the State Staff ID). Required for CJ records if the Employee Number is missing.	Optional	Cond. Required
E	Position Code	The three-character EMIS Position Assignment Code.	Required	Required
F	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.	Optional	Required
G	FTE	The Full-Time Equivalency representing the proportion of a full-time position the contracted staff member works at the reporting district. Valid values are 0.00 to 9.99.	N/A	Required
H	Local Contract Code	The district-defined code used to identify and group contractor records for local tracking and reporting purposes.	Required	Required
I	Federal Tax ID	The nine-digit Federal Employer Identification Number (FEIN) assigned to the contracting company or organization by the IRS.	Required	Optional
J	Contractor Name	The legal name of the company, organization, or entity providing contracted services to the district.	Required	Optional
K	Contract Amount	The total monetary value of the contract for the current fiscal year.	Required	N/A
L	Contract Start Date	The date on which the contractual agreement begins and the contractor starts providing services to the district.	Required	N/A
M	Contract End Date	The date on which the contractual agreement concludes and the contractor stops providing services under the current contract terms.	Required	N/A
N	Hours Per Week	The average number of hours per week that services are provided under the contract.	Required	N/A
O	Position Fund Source	The EMIS funding source code indicating how the contracted position/service is funded. The valid values are A, B, F, G, H, I, J, L, N, O, P, S, T, X, and Y.	Required	N/A
P	Service Performed	Indicates whether the contract requires specific services to be performed as a condition of the agreement. Valid values: Y N	Optional	N/A
Q	Work Hours	Indicates whether the contract requires a specific number of hours of services to be provided as a condition of the agreement. Valid values: Y N	Optional	N/A
R	Number of People	Indicates whether the contract requires a specific number of individuals to be provided or served as a condition of the agreement. Valid values: Y N	Optional	N/A
S	Employee Number	The district's internal employee number for the contracted staff member.	N/A	Required