Query NDC Bad Postal Code: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
TOstryzniuk (talk | contribs)
CCMDB_legit, approved, Bureaucrats, Administrators
27,522 edits
m Minor
clean-up pls review it makes sense to you Pagasa/Trish
Line 2: Line 2:


== {{CFE Data Integrity Checks}} Steps ==
== {{CFE Data Integrity Checks}} Steps ==
=== 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]].
Steps will be:  
Steps will be:  
* if the patient has '''[[Province]] = Manitoba''':
*# check the postal code in EPR, correct if different than ours
*# if same as ours, check the address in EPR against [https://www.canadapost.ca/cpo/mc/personal/postalcode/fpc.jsf 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 CF or NK or OS) the query should not trigger at all
** actually, the CF ones should be tested as they would have postal codes, quite possibly MB ones, need to discuss {{discussion}}


 
=== update to [[Table Postal_Code_Master]] ===
<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.>
# Open [[Table Postal_Code_Master]]  
 
# update/add code
... when you update [[Table Postal_Code_Master]] you only need to fill in the fields '''postal code, town and MB_RHA''', we will eliminate the other fields.
#* you only need to fill in the fields '''PCode, rhaname, RHA_Acronym and town''', we will eliminate the other fields.
 
=== 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 ==
== File Locations ==
Line 36: Line 42:
Cleaning to start end of August 2016
Cleaning to start end of August 2016


==Outside Province Postal Code==
*If the first letter is not correct you need to check EPR or internet to put the correct Postal code.
*If the first letter is correct dont need to check and find out the exact Postal code leave it.
*If you cannot find the Postal code and not in the Postal Code Master list put in the L_problem list(means you seen it true error )


[[Category: Data Processing]]
[[Category: Data Processing]]
[[Category: Postal Codes]]
[[Category: Postal Codes]]

Revision as of 09:34, 26 September 2016

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:
    1. check the postal code in EPR, correct if different than ours
    2. if same as ours, check the address in EPR against Canada Post Postal Codes;
  • 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 CF or NK or OS) the query should not trigger at all
    • actually, the CF ones should be tested as they would have postal codes, quite possibly MB ones, need to discuss Template:Discussion

update to Table Postal_Code_Master

  1. Open Table Postal_Code_Master
  2. 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

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

Start Date

2014-09-29 Cleaning to start end of August 2016

Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_NDC_Bad_Postal_Code&oldid=50192"