Query NDC Bad Postal Code: Difference between revisions

Line 2:

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

~~=== Comparison ===~~

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''':

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

Line 36:

Line 42:

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: Postal Codes]]

@@ Line 2: / Line 2: @@
 == {{CFE Data Integrity Checks}} Steps ==
-=== Comparison ===
 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''':
+*# 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 ==
@@ Line 36: / Line 42: @@
 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: Postal Codes]]