Postal Code field: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Line 25: Line 25:


== Data Use ==
== Data Use ==
[[Postal code collection]] will be moved to or referenced from here.
The most common use for postal codes is for researchers to link to Stats Canada for economic status and to for us to get a distribution of patients by MB RHAs outside of Winnipeg.  It’s also a cross-check on [[Province]] for out-of-province patients. - Randy Martens - Sept 11.15.


== {{CCMDB Data Integrity Checks}} ==
== {{CCMDB Data Integrity Checks}} ==

Revision as of 14:48, 2016 July 25

This field is currently being implemented, please check the instructions and put a discussion for anything that isn't clear. 

The Postal_Code field will contain Postal code collection data.

The field will move to a different tab probably, not sure yet how things will look when the old fields are all cleaned out.

Collection Instruction

Enter the Postal code

  • no space
  • upper case letters
  • example only: X0X0X0

When the postal code is not available (e.g. John/Jane Doe or chart doesn't have postal code) enter "N/A" or click the "N/A" button to enter it for you.

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.

Code "couch surfers" as "N/A".

Institutionalized patients

For institutionalized patients (e.g. prison inmates, care homes), use the institution's postal code.

Out-of-Country patients

Our cross checks would flag the format of out-of-country postal codes, so enter "N/A" for these.

Data Use

The most common use for postal codes is for researchers to link to Stats Canada for economic status and to for us to get a distribution of patients by MB RHAs outside of Winnipeg. It’s also a cross-check on Province for out-of-province patients. - Randy Martens - Sept 11.15.

Template:CCMDB Data Integrity Checks

Implemented:

  • will reject empty field
  • will reject invalid postal code
  • will reject invalid combinations of postal code and Province. (pc_province_match)

Implementation

Legacy

Data started out being collected in the tmp field.