Query NDC Bad Postal Code: Difference between revisions
Ttenbergen (talk | contribs) clean-up pls review it makes sense to you Pagasa/Trish |
Ttenbergen (talk | contribs) |
||
| Line 12: | Line 12: | ||
** 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 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 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 | * 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 | |||
=== update to [[Table Postal_Code_Master]] === | === update to [[Table Postal_Code_Master]] === | ||