Conversion of old registry fields to new dispo fields: Difference between revisions
Ttenbergen (talk | contribs) m (m) |
Ttenbergen (talk | contribs) mNo edit summary |
||
(27 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
This article documents how the new [[:Category:2016 Time and Place changes]] fields are populated from old data. | This article documents how the new [[:Category:2016 Time and Place changes]] fields are populated from old data. | ||
==Pre acute living situation field== | {{Collapsable | ||
| always= Details only relevant from a historical / legacy perspective, click expand to see them. | |||
| full= | |||
== Steps == | |||
Run Sub Dispo_populate() in the Ttenbergen 19:02, 2016 July 8 (CDT) version of [[CFE]]. Can re-run whole thing if fixes are required. | |||
== Scope == | |||
The old fields are no longer being filled out as of dispo > 2016-07-01. | |||
The new fields have been filled in for some time before that, but checks were added over time, so earlier entries have quite unreliable data in them. | |||
New fields were cross-checked and populated from old data where appropriate. Discussed and finalized w Julie some time ago Ttenbergen 15:31, 2016 November 21 (CST) | |||
== location fields == | |||
===Pre acute living situation field=== | |||
This will not be a direct translation with identical meaning. | This will not be a direct translation with identical meaning. | ||
: If [[Overstay]] Project, | : If [[Overstay]] Project, | ||
Line 11: | Line 26: | ||
:: -> "Chronic Health Facility" | :: -> "Chronic Health Facility" | ||
:: -> "Prison / Jail / Correctional Institution" | :: -> "Prison / Jail / Correctional Institution" | ||
:: -> "Homeless" | :: -> "[[Homeless]]" | ||
:: "From other" -> "other - known but not listed" | :: "From other" -> "other - known but not listed" | ||
:: "From location missing" -> "location missing/unknown" | :: "From location missing" -> "location missing/unknown" | ||
:: else -> new value '''"legacy empty"''' that would not be available to collectors | :: else (for CC or Med before overstay project) -> new value '''"legacy empty"''' that would not be available to collectors | ||
==Pre-admit Inpatient Institution field== | ===Pre-admit Inpatient Institution field=== | ||
This will not be a direct translation with identical meaning. | This will not be a direct translation with identical meaning. | ||
: if [[Hospital previous]] | : if [[Hospital previous]] + type of unit from [[admit from]] correspond to inpt location | ||
:: then -> [[Hospital previous]] + type of unit from [[admit from]] | :: then -> [[Hospital previous]] + type of unit from [[admit from]] | ||
:: else -> new value '''"legacy empty"''' that would not be available to collectors | :: else -> new value '''"legacy empty"''' that would not be available to collectors | ||
==Previous Service field== | ===[[Previous Service field]]=== | ||
This will not be a direct translation with identical meaning. | This will not be a direct translation with identical meaning. | ||
: If [[Service Sending to ICU]] | : If [[Service Sending to ICU]] | ||
Line 30: | Line 43: | ||
:: "Cardiology" -> "Cardiology | :: "Cardiology" -> "Cardiology | ||
:: "Family Medicine" -> "Family Medicine | :: "Family Medicine" -> "Family Medicine | ||
:: "General surgery" -> "General surgery | :: "General surgery" -> "General surgery" | ||
:: "Medicine" -> "Medicine | :: "Medicine" -> "Medicine" | ||
:: "Nephrology" -> "Nephrology | :: "Nephrology" -> "Nephrology" | ||
:: "Neurosurgery" -> "Neurosurgery | :: "Neurosurgery" -> "Neurosurgery" | ||
:: "Ob/Gyne" -> "Ob/Gyne | :: "Ob/Gyne" -> "Ob/Gyne" | ||
:: "Ortho surgery" -> "Ortho surgery | :: "Ortho surgery" -> "Ortho surgery" | ||
:: "Plastic surgery" -> "Plastic surgery | :: "Plastic surgery" -> "Plastic surgery" | ||
:: "Psych" -> "Psych | :: "Psych" -> "Psych" | ||
:: "Thoracic surgery" -> "Thoracic surgery | :: "Thoracic surgery" -> "Thoracic surgery" | ||
:: "Urologic surgery" -> "Urology surgery | :: "Urologic surgery" -> "Urology surgery" | ||
:: "Vascular surgery" -> "Vascular surgery | :: "Vascular surgery" -> "Vascular surgery" | ||
:: "z_not an inpatient" -> " | :: "z_not an inpatient" -> "not applicable" | ||
:: "z_not applicable" -> "not applicable" | :: "z_not applicable" -> "not applicable" | ||
:: "z_other" -> "other (known but not on list)" | :: "z_other" -> "other (known but not on list)" | ||
:: "z_other not on list" -> "other (known but not on list)" | :: "z_other not on list" -> "other (known but not on list)" | ||
:: "z_unknown" -> "unknown" | :: "z_unknown" -> "unknown" | ||
:: else -> new value '''"legacy empty"''' that would not be available to collectors | :: else -> new value '''"legacy empty"''' that would not be available to collectors | ||
No equivalents exist in old data for new | No equivalents exist in old data for new "Emergency Medicine", "Neurology" and "Oncology" so these would be captured under "other" if they ever happened. | ||
===Previous Location field=== | |||
: -> combination of [[Hospital previous]], [[Admit from]] and [[Var 1 - Admit-from Ward]] | |||
I will generate a table ''translations_previous_location'' for this and discuss only unclear cases here. | |||
==Service/Location== | ===Service/Location=== | ||
: -> [[Location field]] | |||
==Off ward field== | |||
==Dispo field== | ===Off ward field=== | ||
: if one of | |||
:::: [[ICU Var 3 - Overflow]] > "" | |||
:::: [[ICU Var 4 - Parked in ER]] = "P" | |||
:::: [[ICU Var 5 - Overflow]] > "" | |||
:::: [[Med Var 5]] > "" | |||
:: then -> true | |||
:: else -> false | |||
===Dispo field=== | |||
: if [[Survive / Expired]] = Expire | : if [[Survive / Expired]] = Expire | ||
:: then if exists [[Organ Donor]] | :: then if exists [[Organ Donor]] | ||
::: then -> "died - organ donor" | ::: then -> "died - organ donor" | ||
::: else -> "died - NOT organ donor" | ::: else -> "died - NOT organ donor" | ||
:: else | :: else | ||
::: if [[ICU Var 6 - AMA]] then -> "AMA" | ::: if [[ICU Var 6 - AMA]] then -> "AMA" | ||
::: else '''''combination of [[discharge to]] and [[Var 2 - Discharge-to Ward]]''''' | |||
==Visit Admit DtTm field== | I will generate a table ''translations_dispo'' for this and discuss only unclear cases here. | ||
== Time Fields == | |||
===Visit Admit DtTm field=== | |||
(needs to be reconciled with [[Encounter processing]] which will likely need updating) | (needs to be reconciled with [[Encounter processing]] which will likely need updating) | ||
==Accept DtTm field== | ===Accept DtTm field=== | ||
: -> [[admit date and time]] | : -> [[admit date and time]] | ||
==Arrive DtTm field== | ===Arrive DtTm field=== | ||
: -> [[admit date and time]] | : -> [[admit date and time]] | ||
: If exists [[ER Wait]] dttm | : If exists [[ER Wait]] dttm | ||
:: then overwrite with -> [[ER Wait]] dttm | :: then overwrite with -> [[ER Wait]] dttm | ||
==Transfer Ready DtTm field== | ===Transfer Ready DtTm field=== | ||
* old [[Transfer Ready date and time]] | * old [[Transfer Ready date and time]] | ||
==TR info status field== | ===TR info status field=== | ||
: if [["No Transfer Date" in Medicine]] | : if [["No Transfer Date" in Medicine]] | ||
:: -> "not available" | :: -> "not available" | ||
Else don't back-populate. | |||
==Dispo DtTm field== | ===Dispo DtTm field=== | ||
* old [[discharge date and time]] | * old [[discharge date and time]] | ||
== Related articles == | |||
{{Related Articles}} | |||
[[Category:Dispo]] | [[Category:Dispo]] | ||
[[Category:2016 Time and Place changes]] | [[Category:2016 Time and Place changes]] | ||
}} |
Latest revision as of 11:37, 2019 September 19
This article documents how the new Category:2016 Time and Place changes fields are populated from old data.
Details only relevant from a historical / legacy perspective, click expand to see them. | ||
StepsRun Sub Dispo_populate() in the Ttenbergen 19:02, 2016 July 8 (CDT) version of CFE. Can re-run whole thing if fixes are required. ScopeThe old fields are no longer being filled out as of dispo > 2016-07-01. The new fields have been filled in for some time before that, but checks were added over time, so earlier entries have quite unreliable data in them. New fields were cross-checked and populated from old data where appropriate. Discussed and finalized w Julie some time ago Ttenbergen 15:31, 2016 November 21 (CST) location fieldsPre acute living situation fieldThis will not be a direct translation with identical meaning.
Pre-admit Inpatient Institution fieldThis will not be a direct translation with identical meaning.
Previous Service fieldThis will not be a direct translation with identical meaning.
No equivalents exist in old data for new "Emergency Medicine", "Neurology" and "Oncology" so these would be captured under "other" if they ever happened. Previous Location field
I will generate a table translations_previous_location for this and discuss only unclear cases here. Service/LocationOff ward field
Dispo field
I will generate a table translations_dispo for this and discuss only unclear cases here. Time FieldsVisit Admit DtTm field(needs to be reconciled with Encounter processing which will likely need updating) Accept DtTm fieldArrive DtTm field
Transfer Ready DtTm fieldTR info status field
Else don't back-populate. Dispo DtTm fieldRelated articles
|