Query NDC Bad Postal Code: Difference between revisions

(49 intermediate revisions by 3 users not shown)

Line 1:

We cross-check the postal codes we collect as part of [[Postal ~~code collection~~]] against a list of known-good postal codes.

{{Data Integrity Check

|DIC_summary=Cross check of [[Postal Code field|postal codes]] against known postal codes

~~== {{CFE Data Integrity Checks}} Steps ==~~

|DIC_related_concepts=Postal Code field

~~=== Comparison ===~~

|DIC_firmness=hard check

~~Main office weekly data check. data vetting process~~.

|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]].

== CFE Data Integrity Checks Steps ==

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.>~~

* if the patient has '''[[Province]] = Manitoba or CF''' :

*# check the postal code in EPR, correct if different than ours

~~{{discussion}}~~

*# if same as ours, check the address in EPR against [https://www.canadapost.ca/cpo/mc/personal/postalcode/fpc.jsf Canada Post Postal Codes];

* ~~booked to do with Pagasa on Monday. Ttenbergen 16:50~~, ~~2014 October 2 (CDT)>~~

*#* update patient's postal code if it was wrong '''or'''

** 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)~~

*#* 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

[~~http~~://www.~~rham.mb~~.ca/~~rhalist~~.~~html RHA lists~~]

** 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

~~=== 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~~ ==

=== update to [[Postal_Code_Master table]] ===

~~old master imports can be found at~~

''see [[Postal_Code_Master table#Maintenance and Validation of Master table]] for other update processes we have for [[Postal_Code_Master table]]''

~~X:\CCMDB\z_archive\PostalCode~~

# 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.

==~~Where was it obtained~~==

== Maintenance and Validation of Master table ==

* From Randy Martens to [[~~Julie Mojica~~]]

see [[Postal_Code_Master table#Maintenance and Validation of Master table]] for other update processes we have for [[Postal_Code_Master table]]''

~~integrated with~~

* http://geocoder.ca/?freedata=1

==~~Start Date~~==

== Log ==

2014-09-29

* 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

== Related articles ==

[[Category: Data Processing]]

[[Category:Data Processing]]

[[Category:Postal Codes]]

[[Category:Registry checks]]

@@ Line 1: / Line 1: @@
-We cross-check the postal codes we collect as part of [[Postal code collection]] against a list of known-good postal codes.
+{{Data Integrity Check
+|DIC_summary=Cross check of [[Postal Code field|postal codes]] against known postal codes
-== {{CFE Data Integrity Checks}} Steps ==
+|DIC_related_concepts=Postal Code field
-=== Comparison ===
+|DIC_firmness=hard check
-Main office weekly data check. data vetting process.
+|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]].
+== CFE Data Integrity Checks Steps ==
 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.>
+* if the patient has '''[[Province]] = Manitoba or CF''' :
+*# check the postal code in EPR, correct if different than ours
-{{discussion}}
+*# if same as ours, check the address in EPR against [https://www.canadapost.ca/cpo/mc/personal/postalcode/fpc.jsf Canada Post Postal Codes];
-* booked to do with Pagasa on Monday. Ttenbergen 16:50, 2014 October 2 (CDT)>
+*#* update patient's postal code if it was wrong '''or'''
-** 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)
+*#* 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
-[http://www.rham.mb.ca/rhalist.html RHA lists]
+** 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
-=== 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 ==
+=== update to [[Postal_Code_Master table]] ===
-old master imports can be found at
+''see [[Postal_Code_Master table#Maintenance and Validation of Master table]] for other update processes we have for [[Postal_Code_Master table]]''
-X:\CCMDB\z_archive\PostalCode
+# 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.
-==Where was it obtained==
+== Maintenance and Validation of Master table ==
-* From Randy Martens to [[Julie Mojica]]
+see [[Postal_Code_Master table#Maintenance and Validation of Master table]] for other update processes we have for [[Postal_Code_Master table]]''
-integrated with
-* http://geocoder.ca/?freedata=1
-==Start Date==
+== Log ==
--09-29
+* 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
+== Related articles ==
+{{Related Articles}}
-[[Category: Data Processing]]
+[[Category:Data Processing]]
+[[Category:Postal Codes]]
+[[Category:Registry checks]]