This article documents how the new Category:2016 Time and Place changes fields are populated from old data.
Expand
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.
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 "
"From other" -> "other - known but not listed"
"From location missing" -> "location missing/unknown"
else (for CC or Med before overstay project) -> new value "legacy empty" that would not be available to collectors Pre-admit Inpatient Institution field This will not be a direct translation with identical meaning.
if Hospital previous + type of unit from admit from correspond to inpt location
then -> Hospital previous + type of unit from admit from
else -> new value "legacy empty" that would not be available to collectors 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" -> "not applicable"
"z_not applicable" -> "not applicable"
"z_other" -> "other (known but not on list)"
"z_other not on list" -> "other (known but not on list)"
"z_unknown" -> "unknown"
else -> new value "legacy empty" that would not be available to collectors 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 -> Location 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
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 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)
Accept DtTm field -> admit date and time 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" Else don't back-populate.
Dispo DtTm field Related articles