ZIP USA Table
Zip codes in the United States
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CITY_NAME |
City Name |
VARCHAR2 |
64 |
CITY_TYPE |
XXX |
VARCHAR2 |
1 |
COUNTY_NAME |
County Name |
VARCHAR2 |
64 |
STATE_ABBR |
State Abbreviation |
VARCHAR2 |
2 |
STATE_NAME |
state name |
VARCHAR2 |
40 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |
ZIP_CODE |
The zip code. |
VARCHAR2 |
10 |
ZIP_TYPE |
XXX |
VARCHAR2 |
1 |