Postal Code field: Difference between revisions

(39 intermediate revisions by 6 users not shown)

Line 4:

| CCMDB_tab = Dispo

| element_description = The patient's postal code.

| in_table = L_Log

| in_table = L_Log table

| data_type = string

| datafield_length = 6

Line 14:

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 ==

Line 20:

Line 21:

* 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.

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.

=== 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, do NOT use that place's postal code as provided, use N/A for postal code

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

==== 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 ====

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

~~{{discussion}}~~

==== International Students ====

~~What do we enter for patients that are here from another country on a student VISA? These patients~~ have ~~a MB PHIN, but if I enter their PHIN, then I would have to enter their province as MB, and give their local postal code.~~[[~~User:Mlagadi|Mlagadi~~]] ~~09:57~~, ~~2017 May 3 (CDT)~~

If they have an address in the [[Province]], enter it, otherwise treat them as [[#Out-of-Country patients]].

* Hey Michele, I had a quick look at a Manitoba Government website, international students that are here for 6 months or longer are eligible for health coverage under the province, so I would put down the postal code for their current residence here in Manitoba. Had a discussion amongst Lois, Laura, Elaine and myself and came up with this! I know it ~~says permanently resides above but this seems to make the most sense~~, ~~any other thoughts?~~ [[~~User:Lkaita|Lisa Kaita~~]] ~~14:02, 2017 May 3 (CDT)~~

=== 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.

*if [[Province]] code is '''not''' MB then the postal code should not be a MB postal code. Enter "not applicable" or the out of province postal code if available, and also, there should not be a PHIN number.

== 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]]==~~

~~Main office weekly data check. data vetting process.~~

~~Uses query ''NDC_Bad_Postal_Code'' and table ''Postal_Code_Master''.~~

==~~= table ''Postal_Code_Master'' ===~~

== [[Postal Code Master table]] ==

~~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.~~

~~The country-wide component was based on an older table I think we go it from Stats Can.~~

== Start/end Dates ==

Line 65:

Line 63:

==Wikipedia Postal codes listings across 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 ==

== 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.

[[Category: 2016 Time and Place changes]]

[[Category: Data Collection Guide]]

[[Category: Postal Codes|*]]

[[Category: Postal Codes| *]]

[[Category: Registry Data]]

[[Category: Demographics]]

@@ Line 4: / Line 4: @@
 | CCMDB_tab = Dispo
 | element_description = The patient's postal code.
-| in_table = L_Log
+| in_table = L_Log table
 | data_type = string
 | datafield_length = 6
@@ Line 14: / Line 14: @@
 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 ==
@@ Line 20: / Line 21: @@
 * 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.
+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.
 === 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, do NOT use that place's postal code as provided, use N/A for postal code
 Code "couch surfers" as "N/A".
 ==== 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 ====
 Our cross checks would flag the format of out-of-country postal codes, so enter "N/A" for these.
-{{discussion}}
+==== International Students ====
-What do we enter for patients that are here from another country on a student VISA? These patients have a MB PHIN, but if I enter their PHIN, then I would have to enter their province as MB, and give their local postal code.[[User:Mlagadi|Mlagadi]] 09:57, 2017 May 3 (CDT)
+If they have an address in the [[Province]], enter it, otherwise treat them as [[#Out-of-Country patients]].
-* Hey Michele, I had a quick look at a Manitoba Government website, international students that are here for 6 months or longer are eligible for health coverage under the province, so I would put down the postal code for their current residence here in Manitoba.  Had a discussion amongst Lois, Laura, Elaine and myself and came up with this! I know it says permanently resides above but this seems to make the most sense, any other thoughts? [[User:Lkaita|Lisa Kaita]] 14:02, 2017 May 3 (CDT)
 === 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.
+*if [[Province]] code is '''not''' MB then the postal code should not be a MB postal code. Enter "not applicable" or the out of province postal code if available, and also, there should not be a PHIN number.
 == 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'' ===
+== [[Postal Code Master table]] ==
-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.
-The country-wide component was based on an older table I think we go it from Stats Can.
 == Start/end Dates ==
@@ Line 65: / Line 63: @@
 ==Wikipedia Postal codes listings across 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 ==
 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: Data Collection Guide]]
-[[Category: Postal Codes|*]]
+[[Category: Postal Codes| *]]
 [[Category: Registry Data]]
+[[Category: Demographics]]