Upload/Return File Instructions

Notice: There has been a change to the School District Upload/Return File input and output file formats.
Changes to file format are in red.

Uploading School District Address Database
Rates and jurisdictions provided through this upload are subject to revision on a calendar year basis. Submitted files must be in comma delimited text format (.CSV) with no header row and with the following fields in the order specified in the Upload File Format description below. Note: The Address, City, Zip Code, and Year fields are required and must contain valid alpha/numeric text. If the field is optional, you may leave that field blank in your file, but you need to account for the field in the comma delimited format. If you have any questions concerning the Upload File Format, please review the sample file at the bottom of this page.

Upload File Format
The structure of the upload file is as follows:

Field Name Description Format Length
User # * Optional User Record ID alpha/numeric 15
Address ** Street Name and Number alpha/numeric 61
Suite Suite, P.O. Box, Apt, Lot alpha/numeric 61
City ** City Name alpha 29
State State Abbreviation (OH only) alpha 2
Zip Code ** 5-digit Zip Code numeric 5
Zip Plus Zip+4 Extension numeric 4
As of Date **   MM/DD/YYYY Format  numeric 10 
* The User # field in the file format pertains to the record number in which you identify this address on your system.
** Address, City, Zip Code, and Year fields are required.
 Year cannot be before 2002 and cannot be in the future.

Retrieving Updated School District Address Database
Following your submission, please check the Upload/Return File Status Page . This page will display the status of your submissions and upon completion of the batch processing, your return file(s) will be available to download. The last 2 submissions will always be available for re-download. Each retrieval will consist of two downloadable files named "{user_id}_{job_id}SDAR.csv" and "{user_id}_{job_id}SDAE.csv" where {user_id} represents the numeric identity of your online user account and {job_id} corresponds to the sequential Upload Job ID of your file at the time of submission.

Results File Format
The structure of the results file is as follows:

Field Name Description Format Length
User # Optional User Record ID alpha/numeric 15
Reference # Reference ID for the specific transaction (9999-9999999999) alpha/numeric 15
Address USPS Standardized Address Line 1 alpha/numeric 61
Suite USPS Standardized Address Line 2 alpha/numeric 61
City USPS Standardized City Name alpha 29
State State Abbreviation alpha 2
Zip Code USPS Standardized 5-digit Zip Code numeric 5
Zip Plus USPS Standardized Zip+4 Extension numeric 4
As of Date  MM/DD/YYYY Format  numeric 10 
SD Name School District Name alpha 50
SD Number Department of Taxation School District Number numeric 4
ODE Number Department of Education School District Number numeric 6
Tax Rate School District Income Tax Rate (9.9999) numeric 6
Date Processed MM/DD/YYYY Format numeric 10

Error File Format
The structure of the error file is as follows:

Field Name Description Format Length
User # Optional User Record ID alpha/numeric 15
Reference # Reference ID for the specific transaction (9999-999999999) alpha/numeric 15
Address Street Name and Number alpha/numeric 61
Suite Suite, P.O. Box, Apt, Lot alpha/numeric 61
City City Name alpha 29
State State Abbreviation alpha 2
Zip Code 5-digit Zip Code numeric 5
Zip Plus Zip+4 Extension numeric 4
As of Date  MM/DD/YYYY  numeric 10 
Result Type Error Match Code alpha/numeric 4

Error Codes

Error Match Code Description
E010 Required fields were not provided.
E011 Input zip code was not in Ohio.
E012 City was not found.
E020 Could not locate matching street.
E022 Could not locate this street number.
E023 Match is unresolved.
E024 Could not locate this street number.
E027 Could not match directional information.
E030 Invalid year.
E033 Address found was not in Ohio.
E034 Required fields were not provided.
E035 Invalid input state (OH only).
E036 An Ohio school district could not be found for the input address.


Examples Files

Sample Upload File
1,1615 GARFIELD AVE,,ASHLAND,OH,44805,,2004
2,7137 MARTIN RD,,WEST SALEM,OH,44287,,2004
3,5002 N MYERS RD,,GENEVA,OH,44041,,2004
4,6698 DEERVIEW DR,,LOVELAND,OH,45140,,2004
5,6702 US 20,,METAMORA,OH,43540,,2004
6,2383 RT 61 S,,NORWALK,OH,44857,,2004
7,13834 FANCHER RD,,JOHNSTOWN,OH,43031,,2004
8,29761 STANLEY RD,,NEW MARSHFIELD,OH,45766,,2004
9,4454 WING VIEW LN,,KETTERING,OH,45429,,2004
10,9439 MEADOWTRAIL CT,,LOVELAND,OH,45140,,2004

Sample Results File
1,1004-31469,1615 GARFIELD AVE, ,ASHLAND,OH,44805,3549,2004,ASHLAND CSD,0301,043505,0
2,1004-31470,7137 MARTIN RD, ,WEST SALEM,OH,44287,9065,2004,NORTHWESTERN LSD (WAYNE CO.),8505,050575,0.0125
3,1004-31471,5002 N MYERS RD, ,GEVEVA,OH,44041,7704,2004,GENEVA AREA CSD,0404,044057,0
4,1004-31472,6698 DEERVIEW DR, ,LOVELAND,OH,45140,5919,2004,LOVELAND CSD,3108,044271,0
5,1104-4408,6702 US HIGHWAY 20, ,METAMORA,OH,43540,9739,2004,EVERGREEN LSD,2602,047050,0.0075,11/18/2004
6,1004-31474,2383 STATE ROUTE 61, ,NORWALK,OH,44857,9183,2004,MONROEVILLE LSD,3902,047712,0
7,1004-31475,13834 FANCHER RD, ,JOHNSTOWN,OH,43031,8129,2004,JOHNSTOWN-MONROE LSD,4503,047985,0.01
8,1004-31476,29761 STANLEY RD, ,NEW MARSHFIELD,OH,45766,8903,2004,ALEXANDER LSD,0501,045906,0
9,1004-31477,4454 WING VIEW LN, ,KETTERING,OH,45429,3102,2004,KETTERING CSD,5705,044180,0

Sample Error File
10,1004-31478,9439 MEADOWTRAIL CT, ,LOVELAND,OH,45140, ,2004,E020


Upload your School District Address File