Query NDC Bad Postal Code: Difference between revisions
| Line 34: | Line 34: | ||
** Do you create that query each time? Would we be able to update the NDC query that finds these in the first place to include the info you need? We can discuss at our next meeting. [[User:Ttenbergen|Ttenbergen]] 16:23, 2022 March 17 (CDT) | ** Do you create that query each time? Would we be able to update the NDC query that finds these in the first place to include the info you need? We can discuss at our next meeting. [[User:Ttenbergen|Ttenbergen]] 16:23, 2022 March 17 (CDT) | ||
}} | }} | ||
* Fixing | * Fixing and adding Postal code to the Master Postal Code | ||
* Create a query | * 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 Postal Code Master if you need to add a Postal Code | ||
* Open the EPR to check the address of the patient | * Open the EPR to check the address of the patient | ||
* Check first | * Check first the Postal Code in EPR - then go to Address | ||
* If not the same get the Province | * If not the same get the Province | ||
* Go to Postal Code Master filter by Province then by Town | * 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 , | |||
[[User:PTorres|PTorres]] 17:06, 2022 March 17 (CDT) | [[User:PTorres|PTorres]] 17:06, 2022 March 17 (CDT) | ||