Conversion of old registry fields to new dispo fields
This article documents how the new Category:2016 Time and Place changes fields are populated from old data.
Pre acute living situation field
This will not be a direct translation with identical meaning.
- If Overstay Project,
- "From Apartment" -> "Apartment"
- "From Assisted Living" -> "Assisted Living"
- "From Personal Care Home" -> "Personal Care Home"
- "From Supportive Housing" -> "Supportive Housing"
- "From House" -> "House"
- -> "Chronic Health Facility"
- -> "Prison / Jail / Correctional Institution"
- -> "Homeless"
- can we just say other -> other, since other might have been jail? I think it's the most reasonable, but pls confirm Julie.
- "From other" -> "other - known but not listed"
- "From location missing" -> "location missing/unknown"
- else -> new value "legacy empty" that would not be available to collectors
- So for CC or Med before overstay project the data value is legacy empty and not location missing/unknown, correct? I agree for these 3 items. JMojica 13:56, 2016 July 5 (CDT)
Pre-admit Inpatient Institution field
This will not be a direct translation with identical meaning.
- if Hospital previous
- then -> Hospital previous + type of unit from admit from
- else -> new value "legacy empty" that would not be available to collectors
Previous Service field
This will not be a direct translation with identical meaning.
- If Service Sending to ICU
- "Cardiac surgery" -> "Cardiac surgery
- "Cardiology" -> "Cardiology
- "Family Medicine" -> "Family Medicine
- "General surgery" -> "General surgery
- "Medicine" -> "Medicine
- "Nephrology" -> "Nephrology
- "Neurosurgery" -> "Neurosurgery
- "Ob/Gyne" -> "Ob/Gyne
- "Ortho surgery" -> "Ortho surgery
- "Plastic surgery" -> "Plastic surgery
- "Psych" -> "Psych
- "Thoracic surgery" -> "Thoracic surgery
- "Urologic surgery" -> "Urology surgery
- "Vascular surgery" -> "Vascular surgery
- "z_not an inpatient" -> this should be "not applicable" JMojica 14:16, 2016 July 5 (CDT)
Template:Discussion what should become of these? Ttenbergen 13:13, 2016 July 5 (CDT)
- "z_not applicable" -> "not applicable" - this should be Critical Care as per guideline JMojica 14:16, 2016 July 5 (CDT)
- "z_other" -> "other (known but not on list)"
- "z_other not on list" -> "other (known but not on list)"
- "z_unknown" -> "unknown"
Template:Discussion do we need to capture "Emergency Medicine" for everyone from ER? Ttenbergen 13:09, 2016 July 5 (CDT)
- Not all from ER is EMERGENCY MEDICINE. I think safe to put legacy empty.
- else -> new value "legacy empty" that would not be available to collectors
No equivalents exist in old data for new "Critical Care", "Emergency Medicine", "Neurology" and "Oncology" so these would be captured under "other" if they ever happened.
- except Critical Care - equivalent to not applicable in the old JMojica 14:16, 2016 July 5 (CDT)
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
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
- then if exists Organ Donor
- then -> "died - organ donor"
- else -> "died - NOT organ donor"
- else
- if ICU Var 6 - AMA then -> "AMA"
- else combination of discharge to and Var 2 - Discharge-to Ward
- then if exists Organ Donor
I will generate a table translations_dispo for this and discuss only unclear cases here.
Visit Admit DtTm field
(needs to be reconciled with Encounter processing which will likely need updating)
Accept DtTm field
Arrive DtTm field
- -> admit date and time
- If exists ER Wait dttm
- then overwrite with -> ER Wait dttm
Transfer Ready DtTm field
TR info status field
- if "No Transfer Date" in Medicine
- -> "not available"
- under what circumstances?; actually, we might not need to back-populate this since it was just meant for collectors to not leave this blank... Julie? Template:Discussion
- -> "not transfer ready"