Postal Code field: Difference between revisions

(56 intermediate revisions by 7 users not shown)

Line 1:

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

{{Data_element

| field_name = PostalCode

| CCMDB_label = Postal Code

| CCMDB_tab = Dispo

| element_description = The patient's postal code.

| in_table = L_Log table

| data_type = string

| datafield_length = 6

| program_collecting = Med and CC

| created_raw = Raw

| data_element_start_date = 2012-01-01

| data_element_sort_index = 33

}}

The [[Postal_Code field]] ~~will contain~~ [[~~Postal code collection~~]] ~~data~~.

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.

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

Line 10:

Line 21:

* upper case letters

* example only: X0X0X0

When the postal code is '''not''' available 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 ===

~~Consider special cases from~~ [[Postal code ~~collection~~]] ~~for now~~, ~~I will move those over here~~ when ~~we set~~ the ~~old field to legacy~~. ~~Please comment here though~~ if the ~~instructions for old field would~~ not ~~work in new setup~~.

==== [[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, 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 / 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 ====

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

=== 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. Enter "not applicable" or the out of province postal code if available, and also, there should not be a PHIN number.

== Data Use ==

[[Postal ~~code collection~~]] ~~will be moved to or referenced from here.~~

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

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

== Start/end Dates ==

Start Date: new admissions on and after January 1, 2012

End Date: None / Permanent Collection

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

==Wikipedia Postal codes listings across Canada==

* will reject empty field

[http://en.wikipedia.org/wiki/List_of_postal_codes_in_Canada Wikipedia, Postal codes in Canada]

* will reject invalid postal code

* will reject invalid combinations of postal code and [~~[Province~~]].

== ~~Implementation~~ ==

== Related Articles ==

== 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: Data Collection Guide]]

[[Category: Postal Codes| *]]

[[Category: Registry Data]]

[[Category: Demographics]]

@@ Line 1: / Line 1: @@
- ''This field is currently being implemented, please check the instructions and put a discussion for anything that isn't clear. ''
+{{Data_element
+| field_name = PostalCode
+| CCMDB_label = Postal Code
+| CCMDB_tab = Dispo
+| element_description = The patient's postal code.
+| in_table = L_Log table
+| data_type = string
+| datafield_length = 6
+| program_collecting = Med and CC
+| created_raw = Raw
+| data_element_start_date = 2012-01-01
+| data_element_sort_index = 33
+}}
-The [[Postal_Code field]] will contain [[Postal code collection]] data.
+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.
-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 ==
@@ Line 10: / Line 21: @@
 * upper case letters
 * example only: X0X0X0
-When the postal code is '''not''' available 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 ===
-Consider special cases from [[Postal code collection]] for now, I will move those over here when we set the old field to legacy. Please comment here though if the instructions for old field would not work in new setup.
+==== [[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, 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 / 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 ====
+If they have an address in the [[Province]], enter it, otherwise treat them as [[#Out-of-Country patients]].
+=== 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. Enter "not applicable" or the out of province postal code if available, and also, there should not be a PHIN number.
 == Data Use ==
-[[Postal code collection]] will be moved to or referenced from here.
+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 Check List}}
+== [[Postal Code Master table]] ==
+== Start/end Dates ==
+Start Date: new admissions on and after January 1, 2012
+End Date: None / Permanent Collection
-== {{CCMDB Data Integrity Checks}} ==
+==Wikipedia Postal codes listings across Canada==
-* will reject empty field
+[http://en.wikipedia.org/wiki/List_of_postal_codes_in_Canada Wikipedia, Postal codes in Canada]
-* will reject invalid postal code
-* will reject invalid combinations of postal code and [[Province]].
-== Implementation ==
+== Related Articles ==
+{{Related Articles}}
 == 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: Data Collection Guide]]
+[[Category: Postal Codes| *]]
+[[Category: Registry Data]]
+[[Category: Demographics]]