Query NDC Bad Postal Code: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m Text replacement - "[[Julie Mojica" to "[[p:Julie Mojica" |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 1: | Line 1: | ||
{{Data Integrity Check | |||
| DIC_summary = Cross check of [[Postal Code field|postal codes]] against known postal codes | |||
| DIC_related_concepts = [[Postal Code field]] | |||
| DIC_firmness = hard check | |||
| DIC_timing = | |||
| DIC_app = Centralized data front end.accdb | |||
| DIC_coding = query ''NDC_Bad_Postal_Code'' | |||
| DIC_status = implemented | |||
| DIC_implementation_date = 2014-09-24 | |||
}} | |||
We cross-check the postal codes we collect as part of [[Postal Code field]] collection against a list of known-good postal codes. | We cross-check the postal codes we collect as part of [[Postal Code field]] collection against a list of known-good postal codes. | ||
| Line 41: | Line 52: | ||
Cleaning to start end of August 2016 | Cleaning to start end of August 2016 | ||
== Related articles == | |||
{{Related Articles}} | |||
[[Category: Data Processing]] | [[Category: Data Processing]] | ||
[[Category: Postal Codes]] | [[Category: Postal Codes]] | ||
Revision as of 11:30, 25 October 2018
| Data Integrity Checks | |
| Summary: | Cross check of postal codes against known postal codes |
| Related: | [[Postal Code field]] |
| Firmness: | hard check |
| Timing: | |
| App: | Centralized data front end.accdb |
| Coding: | query NDC_Bad_Postal_Code |
| Uses L Problem table: | not entered |
| Status: | implemented |
| Implementation Date: | 2014-09-24 |
| Backlogged: | true |
We cross-check the postal codes we collect as part of Postal Code field collection against a list of known-good postal codes.
Template:CFE Data Integrity Checks Steps
Comparisons are done as part of vetting via NDC query NDC_Bad_Postal_Code in CFE. Steps will be:
- if the patient has Province = Manitoba or CF :
- check the postal code in EPR, correct if different than ours
- if same as ours, check the address in EPR against Canada Post Postal Codes;
- update patient's postal code if it was wrong or
- make #update to Table Postal_Code_Master if postal code was correct and just not in our list
- if the patient is from any other province:
- if the Postal Code's first letter is not for the province where the patient lives you need to check EPR or internet to put the correct Postal code
- If the first letter is appropriate for province but triggers because it's not in the master list, then register the D_ID with Known data errors with query name "NDC_Bad_Postal_Code"
- if the patient has Province = (US or NK or OS) there should be no postal code so query should not trigger at all
update to Table Postal_Code_Master
- Open Table Postal_Code_Master
- update/add code
- you only need to fill in the fields PCode, rhaname, RHA_Acronym and town, we will eliminate the other fields.
File Locations
old master imports can be found at X:\CCMDB\z_archive\PostalCode
Where was it obtained
- From Randy Martens to p:Julie Mojica
integrated with
Wikipedia Postal codes listings across Canada
Wikipedia, Postal codes in Canada
- at the top of the article shows the the first letter that a postal code starts with for a province.
Map showing first letter used in postal codes across Canada
RHA Listings
- see Manitoba RHAs
Start Date
2014-09-29 Cleaning to start end of August 2016
Related articles
| Related articles: |