ZIP CANADA Table
Zip codes in Canada
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CITY_NAME |
City Name |
VARCHAR2 |
64 |
CITY_TYPE |
XXX |
VARCHAR2 |
1 |
POSTAL_CODE |
Postal Code (part of an address) |
VARCHAR2 |
15 |
PROVINCE_ABBR |
Abbreviation for a province in Canada |
VARCHAR2 |
2 |
PROVINCE_NAME |
Name of a province in Canada |
VARCHAR2 |
64 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |