Query NDC Bad Postal Code: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (→Where was it obtained: u) |
Ttenbergen (talk | contribs) m (template to put into category) |
||
| Line 1: | Line 1: | ||
We cross-check the postal codes we collect as part of [[Postal code collection]] against a list of known-good postal codes. | We cross-check the postal codes we collect as part of [[Postal code collection]] against a list of known-good postal codes. | ||
== Steps == | == {[CFE Data Integrity Checks}} Steps == | ||
=== Comparison === | === Comparison === | ||
Comparisons are done as part of [[vetting]] via NDC query ''NDC_Bad_Postal_Code'' in [[CFE]]. | Comparisons are done as part of [[vetting]] via NDC query ''NDC_Bad_Postal_Code'' in [[CFE]]. | ||
| Line 21: | Line 21: | ||
==Start Date== | ==Start Date== | ||
2014-09-29 | 2014-09-29 | ||
[[Category: Data Processing]] | [[Category: Data Processing]] | ||
Revision as of 10:59, 2014 October 22
We cross-check the postal codes we collect as part of Postal code collection against a list of known-good postal codes.
{[CFE Data Integrity Checks}} 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
- From Randy Martens to Julie Mojica
integrated with
Start Date
2014-09-29