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:
| 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:
| 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:
| 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:
| Optional | N/A |
S | Employee Number | The district's internal employee number for the contracted staff member. | N/A | Required |