Query NDC Bad Postal Code: Difference between revisions
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m Text replacement - "Table Postal_Code_Master" to "Postal_Code_Master table" |
||
| Line 27: | Line 27: | ||
*# 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]; | ||
*#* update patient's postal code if it was wrong '''or''' | *#* update patient's postal code if it was wrong '''or''' | ||
*#* make [[#update to | *#* 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 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 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 | ||
| Line 33: | Line 33: | ||
* if the patient has '''Province = (US or NK or OS)''' there should be no postal code so query should not trigger at all | * if the patient has '''Province = (US or NK or OS)''' there should be no postal code so query should not trigger at all | ||
=== update to [[ | === update to [[Postal_Code_Master table]] === | ||
# Open [[ | # Open [[Postal_Code_Master table]] | ||
# update/add code | # update/add code | ||
#* you only need to fill in the fields '''PCode, rhaname, RHA_Acronym and town''', 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. | ||