CCMDB Wiki

Query NDC Bad Postal Code: Difference between revisions

← Older edit
consolidated content about validating the Postal Code Master at Postal_Code_Master table#Maintenance and Validation of Master table and removed it from here.
→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.
 
Line 30: Line 30:
# 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.
* Fixing and adding Postal code to the Master Postal Code
* Create a query need the D_ID, Phin and Postal Code, use Log_PHI Table.
* Open the Postal Code Master if you need to add a Postal Code
* Open the EPR to check the address of the patient
* Check first the Postal Code  in EPR - then go to Address
* If not the same get the Province
* Go to Postal Code Master filter by Province then by Town
* Click ctrl C to copy and ctrl V to paste  then search to the column Postal code , but erase the last letter and number of PC.
* Sort the Postal Code , 


== Maintenance and Validation of Master table ==
== Maintenance and Validation of Master table ==
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_NDC_Bad_Postal_Code"