Postal Code field: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) →N/A-JDoe: Moved the info about chart numbers to John or Jane Doe patient#Chart since it has nothing to do with the subject of this page, postal codes. Tag: Manual revert |
||
| (17 intermediate revisions by 2 users not shown) | |||
| Line 28: | Line 28: | ||
* for data use considerations see [[#N/A]] | * for data use considerations see [[#N/A]] | ||
==== "N/A" - [[ | ==== "N/A" - [[homeless]]==== | ||
{{Collapsable | always = Code "N/A" for [[homeless]] patients. | full = | {{Collapsable | always = Code "N/A" for [[homeless]]patients. | full = | ||
* this includes: | * this includes: | ||
** [[homeless]] person admitted who lists their address as Siloam Mission or the Salvation Army/Booth's Place, code as "N/A" | ** [[homeless]]person admitted who lists their address as Siloam Mission or the Salvation Army/Booth's Place, code as "N/A" | ||
** Couch surfers, code as "N/A" | ** Couch surfers, code as "N/A" | ||
}} | }} | ||
For [[#Data Use]], this should often be grouped with "Winnipeg": most homeless are geographically located in Winnipeg, and the socioeconomic concept is already separately tracked in the [[Pre acute living situation field]]. | For [[#Data Use]], this should often be grouped with "Winnipeg": most [[homeless]] are geographically located in Winnipeg, and the socioeconomic concept is already separately tracked in the [[Pre acute living situation field]]. | ||
* for data use considerations see [[#N/A- | * for data use considerations see [[#N/A-homeless]] | ||
==== "N/A" - [[John or Jane Doe patient]] ==== | ==== "N/A" - [[John or Jane Doe patient]] ==== | ||
| Line 42: | Line 42: | ||
==== "N/A" - out-of-country resident ==== | ==== "N/A" - out-of-country resident ==== | ||
* our [[cross check]]s would flag the format of out-of-country postal codes, so enter "N/A" for these. | * our [[cross check]]s would flag the format of out-of-country postal codes, so enter "N/A" for these. | ||
{{DT | do we have a page for that to also include instructions about province etc. like we have for homeless... }} | {{DT | do we have a page for that to also include instructions about province etc. like we have for [[homeless]]... }} | ||
* for data use considerations see [[#N/A-notCanada]] | * for data use considerations see [[#N/A-notCanada]] | ||
==== "N/A" - in-country resident ==== | |||
* there are cases where not [[homeless]] and province is in Canada (e.g. MB and non-MB) with N/A postal code entry | |||
* for data use considerations see [[#N/A-Canada]] | |||
=== Special Cases === | === Special Cases === | ||
| Line 50: | Line 54: | ||
==== International Students ==== | ==== International Students ==== | ||
{{DT | do we have a page for that to also include instructions about province etc. like we have for homeless... }} | {{DT | do we have a page for that to also include instructions about province etc. like we have for [[homeless]]... }} | ||
If they have an address in the [[Province]], enter it, otherwise treat them as [[#"N/A" - out-of-country resident]]. | If they have an address in the [[Province]], enter it, otherwise treat them as [[#"N/A" - out-of-country resident]]. | ||
{{Discuss | | {{Discuss | | ||
I understand the sentiment in the following, but this should either be rules or not mentioned at all, or it will cause confusion, since it would be relevant specifically in the edge cases when it would fall apart. So it might be better to address the specific edge cases and make a rule and cross check where relevant. | I understand the sentiment in the following, but this should either be rules or not mentioned at all, or it will cause confusion, since it would be relevant specifically in the edge cases when it would fall apart. So it might be better to address the specific edge cases and make a rule and cross check where relevant. | ||
Where this bears on data use, we should make sure we define once what we will check for and how we adjudicate or interpret inconsistencies, like we did for homeless patients. [[User:Ttenbergen|Ttenbergen]] 16:10, 11 July 2025 (CDT) | Where this bears on data use, we should make sure we define once what we will check for and how we adjudicate or interpret inconsistencies, like we did for [[homeless]] patients. [[User:Ttenbergen|Ttenbergen]] 16:10, 11 July 2025 (CDT) | ||
=== Relationship between [[Province]], PHIN and Postal code === | === Relationship between [[Province]], PHIN and Postal code === | ||
| Line 97: | Line 102: | ||
==== N/A ==== | ==== N/A ==== | ||
Anyone with a | Anyone with a | ||
==== N/A- | ==== N/A-[[homeless]] ==== | ||
* patients collected as [[#"N/A" - | * patients collected as [[#"N/A" - homeless]] | ||
* this should often be grouped with [[#MB-Winnipeg]]: most homeless are geographically located in Winnipeg, and the socioeconomic concept is already separately tracked in the [[Pre acute living situation field]]. | * this should often be grouped with [[#MB-Winnipeg]]: most [[homeless]] are geographically located in Winnipeg, and the socioeconomic concept is already separately tracked in the [[Pre acute living situation field]]. | ||
===== Data integrity for homeless patients ===== | ===== Data integrity for [[homeless]] patients ===== | ||
{{Discuss | | {{Discuss | | ||
* CCMDB have [[pre_acute_living_situation field]] | * CCMDB have [[pre_acute_living_situation field]] [[homeless]] with Postal Code, should the Postal code be ignored and replaced by N/A. Should the R_Province entry be affected by Postal Code N/A? --[[User:JMojica|JMojica]] 10:54, 24 June 2025 (CDT) | ||
** We are currently reviewing some of the definitions of | ** We are currently reviewing some of the definitions of [[homeless]]ness. It is possible that details will change as outcome from that. The concept has been broadened to include some ambiguous states and terminology changed to houselessness. Next meeting later this week about that. | ||
** I don't expect that it would change instructions of how to code Postal Code; so, it makes sense to me to update vetted data for postal code to "N/A" if the [[Pre acute living situation]] is "homeless". | ** I don't expect that it would change instructions of how to code Postal Code; so, it makes sense to me to update vetted data for postal code to "N/A" if the [[Pre acute living situation]] is "[[homeless]]". | ||
** Also, we have discussed whether it would be better to do this as an actual change in data, or as an logical change by function or encoded data in the [[Data Meaning Layer]]. Julie, you already do some other things in that layer to re-write data, if I interpret your SAS code correctly. [[User:Ttenbergen|Ttenbergen]] 17:11, 18 July 2025 (CDT) | |||
}} | }} | ||
{{Discuss| | {{Discuss| | ||
* once this settles we should | * once this settles we should | ||
** ensure we have [[Data Integrity Checks]] to flag entries like that | ** ensure we have [[Data Integrity Checks]] to flag entries like that (related: [[Community and Long Term Care Master List]]) | ||
** [[Data definition for factor candidates for the Overstay2 project#???]] is updated accordingly | ** [[Data definition for factor candidates for the Overstay2 project#???]] is updated accordingly | ||
}} | }} | ||
| Line 119: | Line 125: | ||
* this situation often resolves later in an admission, so this may well be different in initial data than in vetted data | * this situation often resolves later in an admission, so this may well be different in initial data than in vetted data | ||
{{DT | | {{DT | | ||
* this is related to [[ | * this is related to [[Minimal Data Set]] and when it's used... do we document this as a concept? | ||
}} | }} | ||
==== N/A-Canada ==== | |||
* patients collected as [[#"N/A" - in-country resident]] | |||
* if province is MB, this should be grouped with [[#MB-Rest]] . | |||
* if province is not MB, this should be grouped with [[#Non_MB-Rest]] . | |||
==== N/A-notCanada ==== | ==== N/A-notCanada ==== | ||
* patients collected as [[#"N/A" - out-of-country resident]] | * patients collected as [[#"N/A" - out-of-country resident]] | ||
* this should | * this should almost always be grouped with [[#Non-MB-Rest]] since that is what it is. | ||
==== Non-MB-Rest==== | ==== Non-MB-Rest==== | ||
* Any code not in the other categories above | * Any code not in the other categories above | ||
* In use, this should often be grouped with [[#N/A-notCanada]] | * In use, this should often be grouped with [[#N/A-notCanada]] | ||
=== SAS Program === | |||
The SAS macro code is in S:\MED\MED_CCMED\Julie\SAS_CFE\CFE_macros\PostalCode_AreaGroup.sas | |||
=== [[Postal Code Master table]] === | === [[Postal Code Master table]] === | ||
We cross-check this data against the [[Postal Code Master table]] and use it to group by RHA. | |||
{{Data Integrity Check List}} | {{Data Integrity Check List}} | ||
| Line 150: | Line 162: | ||
The Postal Code from tmp populated the PostalCode field of Centralized_data on Jun 22, 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: Registry Data]] | [[Category:Registry Data]] | ||
[[Category: Demographics]] | [[Category:Demographics]] | ||