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.

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"

• 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 (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

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" -> "not applicable"

"z_not applicable" -> "Critical Care"

"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.

Template:Discussion Sent Julie excel sheet with possible combinations and translations. Ttenbergen 16:56, 2016 July 5 (CDT)

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

• old Transfer Ready date and time

TR info status field

if "No Transfer Date" in Medicine

-> "not available"

Else don't back-populate.

Dispo DtTm field

• old discharge date and time