| Field Name | Data Type | Description |
|---|---|---|
| ZipCode | Char(5) | 00000-99999 Five digit numeric ZIP Code of the area. |
UpdateKey |
VarChar(10) | A unique key number identifying this record for updates. |
| Action | Char(1) | A or D, meaning add or delete this record. Always an A for Base File. |
| RecordType | Char(1) | A flag indicating which type of record this is. Ex: Firm, General Delivery, High Rise, PO Box, Rural Route, or Street. |
| CarrierRouteID | Char(4) | Carrier identification code or number for a given delivery route or PO box presentation. |
| StPreDirAbbr | Char(2) | The directional abbreviation that comes before an address: Ex: The N meaning North in “123 N MAIN ST” |
| StName | VarChar(28) | The official name of the street as assigned by a local governing authority for this record. |
| StSuffixAbbr | VarChar(4) | Code that is the standard USPS abbreviation for the trailing designator in a street address. |
| StPostDirAbbr | Char(2) | A geographic direction that follows the street name. Ex: The N meaning North in “123 MAIN ST N” |
| AddressPrimaryLowNumber | VarChar(10) | The low number in a range of numeric or alphanumeric components to an address preceding the street name. |
| AddressPrimaryHighNumber | VarChar(10) | The high number in a range of numeric or alphanumeric components to an address preceding the street name. |
| AddressPrimaryOddEven | Char(1) | Code that identifies the side or sides of a street for which a given address range is applicable. O = Odd, E = Even. |
| BuildingFirmName | VarChar(40) | The name of a company, building, apartment complex, shopping center, or other distinguishing secondary address information. |
| AddressSecondaryAbbr | VarChar(04) | Only Applicable to Record Types F and H. |
| AddressSecondaryLowNumber | VarChar(10) | The low-end secondary address component in a range of secondary addresses. Only Applicable to Record Types F and H. |
| AddressSecondaryHighNumber | VarChar(10) | The high-end secondary address component in a range of secondary addresses. Only Applicable to Record Types F and H. |
| AddressSecondaryOddEven | Char(1) | Code that identifies the side or sides of a street for which a given address range is applicable. O = Odd, E = Even. Only Applicable to Record Types F and H. |
| Plus4Low | Char(4) | ZIP Add-On Low Number in the range. Also known as the +4. |
| Plus4High | Char(4) | ZIP Add-On High Number in the range. Also know nas the +4. |
| BaseAlternateCode | Char(1) | Code that specifies whether a record is a base (preferred) or alternate record. B= Base, A = Alternate |
| LACSStatus | Char(1) | L = LACS Converted, Blank = Not Applicable |
| GovernmentBuilding | Char(1) | This indicates what type of Government building this is if applicable. |
| FinanceNumber | VarChar(6) | A code assigned to Postal Service facilities (primarily post offices) to collect cost and statistical data and compile revenue and expense data. |
| State | Char(2) | A 2-character abbreviation for the name of a state, U.S. territory, or armed forces ZIP Code designation. |
| CountyFIPS | Char(3) | The 3-digit (FIPS) code assigned to counties in sequence within each state. Match this code with the County Table for county based info. |
| CongressionalDistrict | Char(2) | The 115th Congressional District this record is assigned to. |
| MunicipalityKey | VarChar(6) | Reserved for future use. |
| UrbanizationKey | VarChar(6) | An index to the Deluxe ZIP Code Database CityStateKey that provides the urbanization name for this delivery range. |
| PreferredLastLineKey | VarChar(6) | Match this field to our Deluxe ZIP Code Database CityStateKey for City name, City alias, Area Code, Time Zone, and more. |
| ToLatitude | Decimal(10, 8) | The north/south measurement indicating the end of this record. |
| FromLatitude | Decimal(10, 8) | The north/south measurement indicating the beginning for this record. |
| ToLongitude | Decimal(11, 8) | The east/west measurement indicating the end of this record. |
| FromLongitude | Decimal(11, 8) | The east/west measurement indicating the beginning for this record. |
| CensusTract | Char(6) | Small, locally delineated statistical areas within selected counties, generally having stable boundaries and, when first established by local communities, designed to have relatively homogeneous demographic characteristics. |
| CensusBlock | Char(4) | Blocks are numbered uniquely within each census tract with a 4-character number that identifies the collection block used in the census and a character block suffix. This character block suffix is often blank. |
| TLID | Char(10) | Tiger Line Identification (TLID) is a universal number associated with Census Bureau products. |
| LatLonMultiMatch | Char(1) | Code that specifies if a ZIP+4 has more than 1 Latitude/Longitude Match. Y = Yes, Blank = No |
| CenLat †< | Decimal(11, 8) | Latitude of the ZIP+4 Centroid. This is a street level centroid. The coordinate will not be house or building based. PREMIUM VERSION ONLY. † |
| CenLon †< | Decimal(11, 8) | Longitude of the ZIP+4 Centroid. This is a street level centroid. The coordinate will not be house or building based. PREMIUM VERSION ONLY. † |
| CensusBlockGroup †< | VarChar(12) | Census block group code (state, county, tract and block group codes) that correlates with the CenLat/CenLon. PREMIUM VERSION ONLY. † |
| CenLat ‡ | Decimal(11, 8) | Latitude of the ZIP+4 Centroid. This is a building based centroid. The coordinate will generally centered on the building or area it represents. DELUXE VERSION ONLY. ‡ |
| CenLon ‡ | Decimal(11, 8) | Longitude of the ZIP+4 Centroid. This is a building based centroid. The coordinate will generally centered on the building or area it represents. DELUXE VERSION ONLY. ‡ |
| CensusBlockGroup ‡ | VarChar(12) | Census block group code (state, county, tract and block group codes) that correlates with the CenLat/CenLon. DELUXE VERSION ONLY. ‡ |