Postal Code Master table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m Text replacement - "Postal code cross check" to "query NDC_Bad_Postal_Code"
m Text replacement - "CCMDB.mdb" to "CCMDB.accdb"
Line 1: Line 1:
Postal_Code_Master is a table in [[Centralized_data.mdb]] that is used by [[query NDC_Bad_Postal_Code]] to detect postal codes that are likely invalid.  
Postal_Code_Master is a table in [[Centralized_data.mdb]] that is used by [[query NDC_Bad_Postal_Code]] to detect postal codes 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.mdb]].
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]].


[[Category:Data structure]]
[[Category:Data structure]]
[[Category:Postal Codes]]
[[Category:Postal Codes]]

Revision as of 11:02, 2019 September 22

Postal_Code_Master is a table in Centralized_data.mdb that is used by query NDC_Bad_Postal_Code to detect postal codes 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.