Postal Code field: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (m)
(24 intermediate revisions by 6 users not shown)
Line 4: Line 4:
| CCMDB_tab = Dispo
| CCMDB_tab = Dispo
| element_description = The patient's postal code.
| element_description = The patient's postal code.
| in_table = L_Log
| in_table = L_Log table
| data_type = string
| data_type = string
| datafield_length = 6
| datafield_length = 6
| program_collecting = Med and CC
| program_collecting = Med and CC
| created_raw = Raw
| created_raw = Raw
| data_element_start_date = 2016-07-01
| data_element_start_date = 2012-01-01
| data_element_sort_index = 33
| data_element_sort_index = 33
}}
}}
Line 20: Line 20:
* upper case letters  
* upper case letters  
* example only: X0X0X0
* 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.
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.


=== Special Cases ===
=== Special Cases ===
==== Homeless with proxy address ====
==== [[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.
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".
Code "couch surfers" as "N/A".


==== Institutionalized patients ====
==== Institutionalized patients ====
For institutionalized patients (e.g. prison inmates, care homes), use the institution's postal code.
For institutionalized patients (e.g. [[Prison / Jail / Correctional Institution]] inmates, care homes), use the institution's postal code.


==== Out-of-Country patients ====
==== Out-of-Country patients ====
Our cross checks would flag the format of out-of-country postal codes, so enter "N/A" for these.
Our cross checks would flag the format of out-of-country postal codes, so enter "N/A" for these.
==== International Students ====
Patients who are here on a '''student visa''' for 6 months or longer are eligible for health coverage under the province. see https://www.gov.mb.ca/ie/study/medical.html  For these, enter as you would a regular patient.


=== Relationship between [[Province]], PHIN and Postal code ===
=== Relationship between [[Province]], PHIN and Postal code ===
Line 38: Line 41:
*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 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.
*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.
== Data Use ==
== 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.
Postal Codes are used group patients geographically for purposes such as:  
Data is used for socioeconomic stratification of population by geographic area.


== {{CCMDB Data Integrity Checks}} ==
* distribution of patients by MB RHAs outside of Winnipeg
Implemented:
* linking to Stats Canada for socioeconomic stratification of population by geographic area
* will reject empty field  
* cross-checking our data's [[Province field]] for out-of-province patients
* will reject invalid postal code


==[[CFE]]-[[Postal code cross check]]==
{{Data Integrity Check List}}
Main office weekly data check.  data vetting process.
Uses query ''NDC_Bad_Postal_Code'' and table ''Postal_Code_Master''.


=== table ''Postal_Code_Master'' ===
== table ''Postal_Code_Master'' ==
This is the table that postal codes get checked again. It includes the [[MB RHA]] that a postal code is affiliated with.  
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 [[Julie Mojica]] 2016-09-08.  
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.
The country-wide component was based on an older table I think we go it from Stats Can.


Line 62: Line 62:
==Wikipedia Postal codes listings across Canada==
==Wikipedia Postal codes listings across Canada==
[http://en.wikipedia.org/wiki/List_of_postal_codes_in_Canada Wikipedia, Postal codes in 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]
== Related Articles ==
{{Related Articles}}


== Legacy ==
== Legacy ==
Data started out being collected in the tmp field.
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.
 


[[Category: 2016 Time and Place changes]]
[[Category: 2016 Time and Place changes]]
[[Category: Data Collection Guide]]
[[Category: Data Collection Guide]]
[[Category: Postal Codes|*]]
[[Category: Postal Codes| *]]
[[Category: L_Log table]]
[[Category: Registry Data]]
[[Category: Registry Data]]
[[Category: Demographics]]

Revision as of 01:36, 2019 February 7

Data Element (edit)
Field Name: PostalCode
CCMDB Label: Postal Code
CCMDB tab: Dispo
Table: L_Log table
Data type: string
Length: 6
Program: Med and CC
Created/Raw: Raw
Start Date: 2012-01-01
End Date: 2300-01-01
Sort Index: 33

The patient's postal code.

  • SMW

Legacy implementation right in the table

  • Cargo


  • Categories
  • Forms


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.

Collection Instruction

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.

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 that place's postal code as provided.

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

Institutionalized patients

For institutionalized patients (e.g. Prison / Jail / Correctional Institution 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.

International Students

Patients who are here on a student visa for 6 months or longer are eligible for health coverage under the province. see https://www.gov.mb.ca/ie/study/medical.html For these, enter as you would a regular patient.

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.

Data Use

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)

 AppStatus
Check pre acute consistentCCMDB.accdbdeclined
Check Function Validate PostalCodeCCMDB.accdbimplemented
Query NDC Bad Postal CodeCentralized data front end.accdbimplemented
Query NDC Postal Code over timeCentralized data front end.accdbimplemented

table Postal_Code_Master

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/end 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

Related Articles

Related articles:

Legacy

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.