Address Export and Address Import
The following data elements can be used with the “AddressExport” and “AddressImprt” usages.
Accuracy Factor
8-character accuracy factor of latitude and longitude.
Additional (Geographic) Data**
Address ID*
10-digit sequentially assigned number used to uniquely identify the record.
Address Lines 1-6
The address in “unparsed” format, lines 1 through 6.
Address Sort
Defines the sort order of an address within the postal code and extension.
Building
Building name.
Census Block ID
Census block identifier.
Census Tract ID
Census tract identifier.
City ID
City.
Cleanse
Address’s cleans setting (Y/N).
Cleanse Data Date
Cleanse data.
Cleanse Date
Cleanse Score
Cleanse Time
Cleanse User
Complex
Complex name.
Congressional District
Congressional district of the address.
Country ID
Country.
County ID
County.
Create Date
Record create information.
Create Time
Create User
Dbl Dependent Locality**
Delivery Office Number**
Delivery Point ID
Department 1**
Department 2**
Dependent Locality**
Dependent Thoroughfare**
Directions To Address
Directions to the address.
Dual Address
Whether this is a dual address.
Dwelling Status Date
Date on which the dwelling status was verified.
Dwelling Status ID
The dwelling status.
Dwelling Type ID
The dwelling type.
Filler
Available only for the Address Export.
Function*
A (add), C (change), or D (delete). Available only for the Address Import.
House Number
The house number.
House Number Modifier
The modifier of the house number.
INSEE Code**
Language
The language ID.
Latitude
Latitude location of the address.
Level Designator ID
The level (e.g., floor)
Level Number
The level number
Line Feed
Available only for the Address Export.
Literal Value
Available only for the Address Export.
Longitude
Longitude location of the address.
Lot
Lot number.
Lot Sequence
Lot sequence.
Mail Accessible
Whether this address is mail accessible.
Military Foreign 1
First address line for military or foreign addresses.
Military Foreign 2
Second address line for military or foreign addresses.
Modify Date
Record modify information.
Modify Time
Modify User
Non (Postally) Required Locality**
Odd Even
Odd or even side of the street
Organization
PO Route Number, PO Route Type, PO Route Walk Sequence
Address post office route number, type and walk sequence.
PO Route Type,
PO Route Walk Sequence
Post Directional
Street name post-modifier, such as the “N” in “Main St N”.
Pre Directional
Street name pre-modifier, such as the “N” in “N Main St”.
Prev Zip Code
Previous Zip code. Available only for the Address Import.
Prev Zip Extension
Previous Zip code extension. Available only for the Address Import.
Route Accessible
Indicates if this address is accessible by circulation carriers for the delivery of publications and products.
State ID
The state.
Street Name
The street name (e.g., “Main”)
Street Suffix ID
The street suffix (e.g., “North”)
Sub-Building Name**
Town of 25 ID
The town of 25.
Unit Designator ID
The unit designator (e.g., “Apt.”)
Unit Number
The unit number (e.g., the “135” in “Apt. 135”)
ZIP Bar Code, ZIP Code, ZIP Extension
Zip code, Zip code + 4, and Zip bar code.
* Field is required
** Field can only be exported if addresses are stored unparsed in the database and QAS is used for address correction
Last updated
