Postal code collection: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m Postal Code not available: moving comment to "data use" area
m Text replacement - "[[Category: " to "[[Category:"
 
(7 intermediate revisions by the same user not shown)
Line 1: Line 1:
A postal code is collected for all patients admitted to a hospital within the WRHA.  The postal code collected is from the address that a person '''permanently resides''' in any [[Province]] in Canada.   
{{LegacyContent
|explanation= moved to [[Postal Code field]]
|successor=[[Postal Code field]]
|content=


The entry [[L_TmpV2]] entry for Postal Code collection will be automatically created for any new patient created. Data is collected for socioeconomic stratification of population by geographic area.
This article contained the information how to code postal code until it was moved to a new field. See history of article for 2016-07-25 for how it used to be coded. See [[Postal Code field]] for how it's coded now.  


== Collection Instruction ==
Enter the postal code in the automatically generated '''PostalCode''' record in the temp table.
* enter into the '''"Q"''' field ('''note, that's the last field on the form, not the first!''')
** no space
** upper case letters
** example only: X0X0X0
* When the postal code is '''not''' available, '''tick off the "B"''' and leave the space for postal code blank


== Relationship between [[Province]], PHIN and Postal code ==
When collecting Postal Code, [[PHIN]] number and [[Province]], think about the relationship of this information when you are collecting it. 
*if patient has a MB PHIN number, then [[Province]] code should be MB and the postal code should be for MB (MB postal codes start with an "R"). 
*if [[Province]] code is '''not''' MB then the postal code should not be a MB postal code and also, there should not be an PHIN number.


== Special Cases ==
[[Category:Legacy Data]]
=== Homeless with proxy address ===
[[Category:Postal Codes]]
If you have a homeless person admitted who lists their address as Siloam Mission or the Salvation Army/Booth's Place, use their postal code as provided.


Code "couch surfers" as "no postal code".
}}
 
=== Institutionalized patients ===
For patients who live in care homes, use the institution's postal code.
 
=== Inmates ===
For inmates such as from Stoney Mountain or Headingley use the institution's postal code.
 
=== Postal Code not available ===
If a postal code is unavailable for a patient, tick off the "B" and leave the space for postal code blank. e.g.:
* John/Jane Doe
* chart doesn't have postal code
* out-of-country patient
**The postal code should reflect the patient’s '''permanent residence'''.  So for someone from India, the postal code should be not available.
 
== {{CCMDB Data Integrity Checks}} ==
Unlike other tmp entries, this entry is not checked as part of the pre-send checker, it is sent when checking TMP complete.
PC must be '''''one ''of the following'''
* blank postal code, postal code missing check box checked
* postal code missing check box '''''un'''''checked and letter number letter number letter number
** example only: ''X1X1X1''
 
=== [[Province]] - Postal Code consistency ===
We used to have a consistency check between [[Province]] and postal code. It was eliminated because there are weird special cases where consistency between [[Province]], [[PHIN]] and postal code gave false-positives. The check between [[PHIN]] and [[Province]] is more important for us, so we eliminated the check for Postal Code vs [[Province]].
 
=== duplicates ===
Check for duplicate postal code entries was implemented as query ''s_tmp_Postal_duplicate'', not sure when. Ttenbergen 16:45, 2016 February 22 (CST)
 
== other integrity checks ==
see [[Postal code cross check]]
 
==[[CFE]]-[[Postal code cross check]]==
Main office weekly data check.  data vetting process.
 
== Dates ==
Start Date: new admissions on and after January 1, 2012
 
End Date: None / Permanent Collection
 
==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]
 
 
[[Category: L_TmpV2 Data]]
[[Category: Data Collection Guide]]
[[Category: All Projects ICU & Medicine]]

Latest revision as of 11:56, 30 July 2025

Legacy Content

This page contains Legacy Content.

Click Expand to show legacy content.

This article contained the information how to code postal code until it was moved to a new field. See history of article for 2016-07-25 for how it used to be coded. See Postal Code field for how it's coded now.