CCMDB Wiki

Query NDC Bad Postal Code: Difference between revisions

← Older editNewer edit →
m Text replacement - "[[Category: " to "[[Category:"
consolidated content about validating the Postal Code Master at Postal_Code_Master table#Maintenance and Validation of Master table and removed it from here.
Line 11: Line 11:
}}
}}
We cross-check the postal codes we collect as part of [[Postal Code field]] collection against a list of known-good postal codes. Also see [[query NDC_Postal_Code_over_time]].
We cross-check the postal codes we collect as part of [[Postal Code field]] collection against a list of known-good postal codes. Also see [[query NDC_Postal_Code_over_time]].
{{Todo
| who =  Tina
| todo_added = 2022-03-24
| todo_action = 2022-07-15
| question =  PWC
* emailed Chastity to see if we could get Postal Code data from them rather than maintaining our own.
** Never got a response. Emailed Chastity again. [[User:Ttenbergen|Ttenbergen]] 14:41, 2022 June 30 (CDT)
*** I have since then found a listing of postal codes through stats can, we may need a process to maintain the master beyond what this page provides. [[User:Ttenbergen|Ttenbergen]] 15:23, 24 June 2025 (CDT)
}}


== CFE Data Integrity Checks Steps ==
== CFE Data Integrity Checks Steps ==
Line 35: Line 26:


=== update to [[Postal_Code_Master table]] ===
=== update to [[Postal_Code_Master table]] ===
''see [[Postal_Code_Master table#Maintenance and Validation of Master table]] for other update processes we have for [[Postal_Code_Master table]]''
# Open [[Postal_Code_Master table]]  
# 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.


{{Discuss | who = Tina | question=
* I think this is the process where you said you are having problems with copy/pasting. Copy pasting isn't even mentioned here, so maybe update the process to show how you actually do this, so that someone like Sheila Rusnak would be able to follow the instructions. [[User:Ttenbergen|Ttenbergen]] 15:45, 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)
*** Taking this off Pagasa's list for now, since if we can get this data from DSS we won't need to do this any more. [[User:Ttenbergen|Ttenbergen]] 15:36, 2022 March 24 (CDT)
}}
* Fixing and adding Postal code to the Master Postal Code
* 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.
* 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 the Postal Code  in EPR - then go to Address
* Check first the Postal Code  in EPR - then go to Address
Line 54: Line 41:
* Sort the Postal Code ,   
* Sort the Postal Code ,   


[[User:PTorres|PTorres]] 17:06, 2022 March 17 (CDT)
== Maintenance and Validation of Master table ==
see [[Postal_Code_Master table#Maintenance and Validation of Master table]] for other update processes we have for [[Postal_Code_Master table]]''


== File Locations ==
== Log ==
old master imports can be found at
{{S:\MED\MED_CCMED}}CCMDB\z_archive\PostalCode
 
==Where was it obtained==
* FROM [[p:Randy Martens | Legacy staff: Randy Martens]] TO [[p:Julie Mojica]]
integrated with
* http://geocoder.ca/?freedata=1
 
==Wikipedia Postal codes listings across Canada==
[http://en.wikipedia.org/wiki/List_of_postal_codes_in_Canada Wikipedia, Postal codes in Canada]
*at the top of the article shows the the first letter that a postal code starts with for a province.
 
[http://www.canadapost.ca/cpc2/addrm/hh/maps/FSA/CA01.pdf Map showing first letter used in postal codes across Canada]
 
==RHA Listings==
* see [[Manitoba RHAs]]
 
==Start Date==
2014-09-29
Cleaning to start end of August 2016
 
==Log==
* 2021-01-27 - changed query to only look at the last year of data to make it faster; any older records were already fixed
* 2021-01-27 - changed query to only look at the last year of data to make it faster; any older records were already fixed
* 2016-08-end - cleaning started
* 2014-09-24 - implemented


== Related articles ==
== Related articles ==
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_NDC_Bad_Postal_Code"