Postal Code field
|Data Element (edit)|
|CCMDB Label:||Postal Code|
|Program:||Med and CC|
The patient's postal code.
Legacy implementation right in the table
The Postal_Code field can be edited in the Dispo tab. 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.
We could define Postal Code as "on admission" or "on discharge". That would depend how we plan to use it. Do we care where someone came from, or do we use this with regard to discharge difficulties? If someone comes from Ashern, is in hospital for 3 months, and moves their home address to a care home in Winnipeg before discharge… what do we want to have in our DB? The original Cognos PC would be easiest and most consistent. But then we may not be able to use the PC for discharge based concepts. Or maybe we can, since the number of affected records might be small. I wonder if we should do a short term project where collectors enter when a PC changes from original Cognos import before discharge. A count would tell us how common this situation is, and help us decide how to proceed. It could be just documenting that we use initial PC and have found that a percentage of ??? changes during the hospital stay. Or it could be a change in definition. For discussion at task meeting, but please add observations here if you have any. Ttenbergen 10:05, 2023 November 5 (CST)
Enter the Postal code
- no space
- upper case letters
- example only: X0X0X0
When the postal code is not available (e.g. John or Jane Doe patient or chart doesn't have postal code) enter "N/A" or click the "N/A" button to enter it for you.
Don't trust Postal Codes from Cognos
Don't trust the postal codes that come from Cognos2, we know that the codes in the data dump can be wrong anc change from day to day, and have been unable get a fix from Decision Support Services. Confirm Postal Codes in EPR and enter the code from EPR if different from Cognos.
Homeless with proxy address
If you have a homeless person admitted who lists their address as Siloam Mission or the Salvation Army/Booth's Place, use that place's postal code as provided.
Code "couch surfers" as "N/A".
For institutionalized patients (e.g. Prison / Jail / Correctional Institution inmates, care homes), use the institution's postal code.
Our cross checks would flag the format of out-of-country postal codes, so enter "N/A" for these.
Relationship between Province, PHIN and Postal code
- 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.
Postal Codes are used group patients geographically for purposes such as:
- distribution of patients by MB RHAs outside of Winnipeg
- linking to Stats Canada for socioeconomic stratification of population by geographic area
- cross-checking our data's Province field for out-of-province patients
Data Integrity Checks (automatic list)
|Check pre acute consistent||CCMDB.accdb||declined|
|Check Function Validate PostalCode||CCMDB.accdb||implemented|
|Query NDC Bad Postal Code||Centralized data front end.accdb||implemented|
|Query NDC Postal Code over time||Centralized data front end.accdb||implemented|
This is the table that postal codes get checked again. It includes the MB RHA that a postal code is affiliated with. For the MB component we imported a version provided by Marc Silva to p:Julie Mojica 2016-09-08. The country-wide component was based on an older table I think we go it from Stats Can.
Start Date: new admissions on and after January 1, 2012 End Date: None / Permanent Collection
Wikipedia Postal codes listings across Canada
Data started out being collected in the tmp field until June 1, 2016. The Postal Code from tmp populated the PostalCode field of Centralized_data on Jun 22, 2016.