Query NDC Bad Postal Code: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m →Comparison: question for Pagasa |
TOstryzniuk (talk | contribs) m →Comparison: minor |
||
| Line 3: | Line 3: | ||
== {{CFE Data Integrity Checks}} Steps == | == {{CFE Data Integrity Checks}} Steps == | ||
=== Comparison === | === Comparison === | ||
Main office weekly data check. data vetting process. | |||
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: | ||
| Line 10: | Line 12: | ||
* booked to do with Pagasa on Monday. Ttenbergen 16:50, 2014 October 2 (CDT)> | * 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) | ** 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) | ||
[http://www.rham.mb.ca/rhalist.html RHA lists] | |||
=== updating the codes === | === updating the codes === | ||
Revision as of 11:09, 25 August 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
Main office weekly data check. data vetting process.
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