Upload/Return File Instructions
|
|
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 Month/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.
|
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 |
| Month/Year **
†
|
MM/YYYY Format |
numeric |
7 |
|
* 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
Month/Year fields are required.
† Month/Year
cannot be before 01/2003 and cannot be in the future.
|
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}MTAR.csv" and "{user_id}_{job_id}MTAE.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.
|
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 |
| Month/Year |
MM/YYYY Format |
numeric |
7 |
| County Name |
Name of the county in which the address is located. |
alpha |
20 |
| Municipality Name |
Name of the municipality in which the address is located. |
alpha |
20 |
| Municipal FIPS Code |
Municipal FIPS Code. |
numeric |
5 |
| Municipal Income Tax Rate |
Municipal Income Tax Rate (9.9999) |
numeric |
6 |
| Date Processed |
MM/DD/YYYY Format |
numeric |
10 |
|
The structure of the error file is as follows:
|
| Field Name |
Description |
Format |
Length |
| User # |
Optional User Record ID |
alpha/numeric |
n/a |
| 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 |
| Month/Year |
MM/YYYY Format |
numeric |
7 |
| Result Type |
Error Match Code |
alpha/numeric |
4 |
|
|
| 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 month/year. |
| E033 |
Address found was not in Ohio. |
| E034 |
Required fields were not provided. |
| E035 |
Invalid input state (OH only). |
|
1,1615 GARFIELD AVE,,ASHLAND,OH,44805,,01/2004
2,7137 MARTIN RD,,WEST SALEM,OH,44287,,12/2003
3,5002 N MYERS RD,,GENEVA,OH,44041,,4/2004
4,6698 DEERVIEW DR,,LOVELAND,OH,45140,,7/2002
5,6702 US 20,,METAMORA,OH,43540,,8/2004
6,2383 RT 61 S,,NORWALK,OH,44857,,11/2003
7,13834 FANCHER RD,,JOHNSTOWN,OH,43031,,2/2004
8,29761 STANLEY RD,,NEW MARSHFIELD,OH,45766,,6/2002
9,4454 WING VIEW LN,,KETTERING,OH,45429,,4/2004
10,9439 MEADOWTRAIL CT,,LOVELAND,OH,45140,,12/2003
|
|
1,1104-4384,1615 GARFIELD AVE, ,ASHLAND,OH,44805,3549,1/2004,ASHLAND,ASHLAND,02568,0.015,11/18/2004
2,1104-4385,7137 MARTIN RD, ,WEST SALEM,OH,44287,9065,12/2003,WAYNE,,,0,11/18/2004
3,1104-4386,5002 N MYERS RD, ,GENEVA,OH,44041,7704,4/2004,ASHTABULA,,,0,11/18/2004
4,1104-4387,6698 DEERVIEW DR, ,LOVELAND,OH,45140,5919,7/2002,CLERMONT,,,0,11/18/2004
5,1104-4388,6702 US HIGHWAY 20, ,METAMORA,OH,43540,9739,8/2004,FULTON,,,0,11/18/2004
6,1104-4389,2383 STATE ROUTE 61, ,NORWALK,OH,44857,9183,11/2003,HURON,,,0,11/18/2004
7,1104-4390,13834 FANCHER RD, ,JOHNSTOWN,OH,43031,8129,2/2004,LICKING,,,0,11/18/2004
8,1104-4391,29761 STANLEY RD, ,NEW MARSHFIELD,OH,45766,8903,6/2002,VINTON,,,0,11/18/2004
9,1104-4392,4454 WING VIEW LN, ,KETTERING,OH,45429,3102,4/2004,MONTGOMERY,KETTERING,40040,0.0175,11/18/2004
|
|
|
10,1104-4393,9439 MEADOWTRAIL CT, ,LOVELAND,OH,45140, ,12/2003,E022
|
|
|
|
Upload your
Municipal Address File
|