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.

  • "Q"(note, that's the last field on the form, not the first!): enter the patient's postal code example only: X1X1X1, ie no space
    • Use Upper Case letters in the postal code with no space between please.
    • When the postal code is not available, tick off the "B" and leave the space for postal code blank

Important Collection Detail to consider

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 outside of MB, USA or out of country, then the postal code should not be a MB postal code and also, there should not be an PHIN number.

There have been some integrity checks applied to ccmdb to help collectors further with this.

Wikipedia Postal codes listings across Canada

wikipedia List_of_postal_codes_of_Canada

  • at the bottom 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

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.

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

  • If reside in Province: MB, then patients need to have a postal code record to be final checked or check box "B" if unable to find on chart.
  • Unlike other tmp entries, this entry is not checked as part of the pre-send checker.
  • Postal Codes must be in upper case, no spaces allowed format should be: example only: "X1X1X1"
  • code to check that postal codes are of the right letter/number format
  • confirmed 2014-Jul-07 that this check will prevent final-check for tmp when no postal code is entered.
  • if province MB than postal code must start with "R"
  • Template:Discussion anything else for here?

Dates

Start Date: 2011-Dec-12

Start putting in the postal code for all new admissions on and after January 1, 2012

End Date: None / Permanent Collection