Postal Code Master table
Postal_Code_Master table in Centralized_data.mdb is used by query NDC_Bad_Postal_Code to detect by exclusion Postal Code entries that are likely invalid.
The table on its own would be about 71MB, (30MB with all extra info stripped out) which is why the check was not included in CCMDB.accdb.
Data Structure
| field | type | description |
|---|---|---|
| PCODE | text(255) | the postal code |
| rhacode | text(255) | code of regional health authority that the postal code is in |
| rhaname | text(255) | name of regional health authority that the postal code is in |
| CA | text(255) | |
| CA_name | text(255) | |
| NC | text(255) | |
| NC_Name | text(255) | |
| latitude | number(double) | |
| longitude | number(double) | |
| province | text(255) | |
| town | text(255) |
Related articles
| Related articles: |