Postal code collection

From CCMDB Wiki
Jump to navigation Jump to search

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.

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.

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 Code, 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

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 their postal code as provided.

  • Question: I’m just wondering how to manage the postal code of a person with no fixed address and is just couch surfing. There is a postal code listed in the chart b/c pt had been staying at a particular address for some time but may not return to that address. Currently I have checked off no postal code available. I would like your thoughts on the best way to handle the postal code assignment in this situation. Judy K May 11, 2015.

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
  • out-of-country patient
  • chart doesn't have postal code

Template: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 unchecked and letter number letter number letter number
    • example only: X1X1X1

province - PC 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 PC vs Province.

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

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.

Map showing first letter used in postal codes across Canada