ZIP USA Table
View exposing zip usa data.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CITY_NAME |
City name associated with the record. |
VARCHAR2 |
64 |
CITY_TYPE |
City type associated with the record. |
VARCHAR2 |
1 |
COUNTY_NAME |
County name associated with the record. |
VARCHAR2 |
64 |
STATE_ABBR |
State abbr associated with the record. |
VARCHAR2 |
2 |
STATE_NAME |
State name associated with the record. |
VARCHAR2 |
64 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |
|
ZIP_CODE |
Zip code associated with the record. |
VARCHAR2 |
5 |
ZIP_TYPE |
Zip type associated with the record. |
VARCHAR2 |
1 |