Data definition for factor candidates for the Overstay2 project

This page documents the data definitions used in the Overstay2 scoring models, as defined during re-analysis and generation of Overstay2 model and implemented in Overstay2 module. See Overstay2 Overview for additional context.

Definitions

The first Transfer Ready DtTm tmp entry associated to a Medicine record fro this #Hospitalization

Final Dispo DtTm of the #Hospitalization, no matter if a medicine or critical care record
- If there is no #Discharge Ready DtTm this will be considered as no Overstay ie it will lead to a Overstay of 0

factors in italics may not currently be used by any Overstay2 scoring models

See Template:S:\MED\CCMED contains the code that defines these for the model.

Age: age on date of first medicine unit admission
Homeless: Pre acute living situation field = "Homeless"
PCH: Pre acute living situation field in ("Personal Care Home", "Chronic Health Facility")
WPG: construct based on Postal Code field#Grouping by Area
OutsideWPG: (Previous Location corresponding s_dispo.geog in ('out-of-WPG','out-of-MB','out-of-CAN') );
MB: Province = 'MB' or maybe Postal Code
Procedures
- InterImplantDevice: has CCI component2 CCI2 code 53 - Implantation of Internal Device
ICD10 Diagnoses (Admit Diagnosis or Comorbid Diagnosis)
- Opioids: Opioid/narcotic, overdose/toxicity (T40.6)
- Dementia: Dx in

Palliative: Palliative care (Z51.5)
Trach: {{ICD10ByCode|Z930'));
PEG: {{ICD10ByCode|Z931'));
ProstheticImplantGraft: {{ICD10ByCode|T856')); *Iatrogenic, mechanical complication/dysfunction, internal prosthetic device or implant or graft NOS*;
SuprapubicCatheter: Suprapubic catheter, indwelling, has one (Z93.5)
ArtificialOpening: Artificial opening NOS, has one (Z93.8)
IleostomyColostomy: (Z9.34)
InternalDevice

: Tracheostomy, has one (Z93.0)
: Gastrostomy, has one (Z93.1)
: Ileostomy or colostomy, has one (Z93.4)
: Suprapubic catheter, indwelling, has one (Z93.5)
: Artificial opening NOS, has one (Z93.8)
: Iatrogenic, mechanical complication/dysfunction, internal prosthetic device or implant or graft NOS (T85.6)

Charlson Diagnoses
- CHF: has ICD10 Dx classified as Charlson Component "Congestive heart failure"
- Plegia: has ICD10 Dx classified as Charlson Component "Hemiplegia or paraplegia"
- Diabetes: has ICD10 Dx classified as Charlson Component "Diabetes with chronic complications"
- Renal: has ICD10 Dx classified as Charlson Component "Renal disease"
- Charlson Comorbidity Index
Glasgow Coma Scale
- Motor: points associated with the AP_Motor field of the Glasgow Coma Scale
- Verb: points associated with the AP_Verbal field of the Glasgow Coma Scale
ADL Collection General Information
- ADL_bath: 0-3-6 of ADL Bathing
- ADL_toilet: 0-3-6 of ADL Toiletting
- ADL_continence: 0-3-6 of ADL Continence
- ADL_Adlmean_age: (ADL Score - 12) * (age as above)