Query NDC Bad Postal Code: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m →updating the codes: u |
Ttenbergen (talk | contribs) m →Comparison: question for Pagasa |
||
| Line 5: | Line 5: | ||
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]]. | ||
Steps will be: | 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)> | <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.> | ||
{{discussion}} | |||
* booked to do with Pagasa on Monday. Ttenbergen 16:50, 2014 October 2 (CDT)> | |||
** Pagasa, I think we never followed up on this. Are those checks being done regularly? Where in vetting process do they fit? Ttenbergen 16:06, 2016 July 25 (CDT) | |||
=== updating the codes === | === updating the codes === | ||
Revision as of 15:06, 25 July 2016
We cross-check the postal codes we collect as part of Postal code collection against a list of known-good postal codes.
Template: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)>
- Pagasa, I think we never followed up on this. Are those checks being done regularly? Where in vetting process do they fit? Ttenbergen 16:06, 2016 July 25 (CDT)
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