CCMDB Wiki

Query NDC Bad Postal Code: Difference between revisions

← Older edit
TOstryzniuk (talk | contribs)
CCMDB_legit, approved, Bureaucrats, Administrators
27,522 edits
m for tina
→update to Postal_Code_Master table: removed old question and the incomplete steps that it was about, the instructions here look like they would be sufficient.
 
(64 intermediate revisions by 3 users not shown)
Line 1: Line 1:
==What is it?==
{{Data Integrity Check
Is an mdb that has a list of all postal codes in the province of Manitoba
|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_coding=query ''NDC_Bad_Postal_Code''
|DIC_implementation_date=2014-09-24
|DIC_status=implemented
|DIC_LProblem=No
|DIC_app=Centralized data front end.accdb
|DIC_backlogged=No
}}
We cross-check the postal codes we collect as part of [[Postal Code field]] collection against a list of known-good postal codes. Also see [[query NDC_Postal_Code_over_time]].


==Where was it obtain==
== CFE Data Integrity Checks Steps ==
From Randy Martens to [[Julie Mojica
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 [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 Postal_Code_Master table]] 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


==Current Location==
=== update to [[Postal_Code_Master table]] ===
X:\CCMDB\PostalCode\Postal_Code_Checker_Master.mdb
''see [[Postal_Code_Master table#Maintenance and Validation of Master table]] for other update processes we have for [[Postal_Code_Master table]]''
# Open [[Postal_Code_Master table]]
# update/add code
#* you only need to fill in the fields '''PCode, rhaname, RHA_Acronym and town''', we will eliminate the other fields.


==What are we doing with it?==
== Maintenance and Validation of Master table ==
*Plan include in the [[CFE] for the main office and have and NDC for the weekly vetting process
see [[Postal_Code_Master table#Maintenance and Validation of Master table]] for other update processes we have for [[Postal_Code_Master table]]''
**Tina to hook into [[CFE]] so Pagasa can run weekly AND also update Master Postal code checker.mdb.


*meeting set up for week of Sept 29 with Pagasa - see Outlook.[[User:TOstryzniuk|Trish Ostryzniuk]] 17:38, 2014 September 24 (CDT)
== Log ==
* 2021-01-27 - changed query to only look at the last year of data to make it faster; any older records were already fixed
* 2016-08-end - cleaning started
* 2014-09-24 - implemented


[[Category: Data Processing]]
== Related articles ==
{{Related Articles}}
 
 
[[Category:Data Processing]]
[[Category:Postal Codes]]
[[Category:Registry checks]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_NDC_Bad_Postal_Code"