CCMDB Wiki

Query NDC Bad Postal Code: Difference between revisions

← Older editNewer edit →
TOstryzniuk (talk | contribs)
CCMDB_legit, approved, Bureaucrats, Administrators
27,522 edits
m →{{CFE Data Integrity Checks}} Steps: Julie confirmed to treat CF same as MB for this purpose
Line 4: Line 4:
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''':  
* if the patient has '''[[Province]] = Manitoba or CF''' :  
*# check the postal code in EPR, correct if different than ours
*# 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];  
*# if same as ours, check the address in EPR against [https://www.canadapost.ca/cpo/mc/personal/postalcode/fpc.jsf Canada Post Postal Codes];  
Line 13: Line 13:
** 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 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) the query should not trigger at all
* if the patient has Province = (US or NK or OS) the query should not trigger at all
=== province = CF ===
{{discussion}}
* What if pt has Province=CF? ones should be tested as they would have postal codes, quite possibly MB ones, need to discuss
** See: [[Province Field]]


=== update to [[Table Postal_Code_Master]] ===
=== update to [[Table Postal_Code_Master]] ===
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_NDC_Bad_Postal_Code"