Query NDC Bad Postal Code

From CCMDB Wiki
Jump to navigation Jump to search

We cross-check the postal codes we collect as part of Postal code collection against a list of known-good postal codes.

Steps

Comparison

Comparisons are done as part of vetting via NDC query NDC_Bad_Postal_Code in CFE. Steps will be: <we need to fill these in when we have completed the first-time updates, we deferred decision on the steps today to when we have done partial cleaning and know how much is left. booked to do with Pagasa on Monday. Ttenbergen 16:50, 2014 October 2 (CDT)> Template:Discussion

updating the codes

Codes are stored in table Postal_Code_Master. Codes can be manually added to or imported into this table when a new master set becomes available.

File Locations

old master imports can be found at X:\CCMDB\z_archive\PostalCode

Where was it obtained

integrated with

Start Date

2014-09-29