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
Hospitalization
A hospitalization is defined as records with same (PHIN and Visit Admit DtTm).
Discharge Ready DtTm
- The first Transfer Ready DtTm tmp entry associated to a Medicine record from this #Hospitalization
Overstay
- #Discharge Ready DtTm - (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
Coefficients / factors
Not all of these factors are used, see model (list in Overstay2 scoring models) for actual use. Also see Re-analysis and generation of Overstay2 model for how they were selected.
Age
age at first medicine unit admission of this #Hospitalization
Location / living arrangement
Re-analysis and generation of Overstay2 model#Location Grouping considerations explains considerations we had in generating these groupings.
Homeless
Pre acute living situation field = "Homeless"
PCH/Chronic Care
Pre acute living situation field in ("Personal Care Home", "Chronic Health Facility")
Winnipeg
construct based on Postal Code field#Winnipeg Postal Code Grouping
|
|
FromNonWPGfacility
|
|
Pre-admit Inpatient Institution field or Previous Location says it's from data med fromregion, but doesn't explain how that is derived. |
corresponding s_dispo.geog in ('out-of-WPG','out-of-MB','out-of-CAN')
MB
Province = 'MB' or maybe Postal Code
North-Western Ontario
construct based on Postal Code field#North-Western Ontario Postal Code Grouping
Northern MB
construct based on Postal Code field#Northern MB Postal Code Grouping
Rest MB
|
Details needed... |
Rest
|
|
Details needed... |
???
|
|
|
Procedures
ImplantDevice
has Admit Procedure with CCI2 code Implantation of Internal Device (53)
Diagnoses
ICD10 Diagnoses (Admit Diagnosis or Comorbid Diagnosis) that might prevent/delay meeting PCH/Home Care criteria.
Opioids
|
|
Discussed these with Lisa; she figures the units would approach chronic addiction differently than one-time experimentation, so I pulled them apart like this, but we should validate both the concept and the groupings with someone medical. Ttenbergen 09:51, 25 June 2025 (CDT) |
Acute
- Opioid/narcotic, overdose/toxicity (T40.6), Opioid/narcotic, acute intoxication (F11.0)
- Cocaine, overdose/toxicity (T40.5), Cocaine, acute intoxication (F14.0)
- Stimulants incl. methamphetamine, poisoning (T43.6), Stimulants incl methamphetamine, acute intoxication (F15.0)
Chronic
- Opioid/narcotic, chronic abuse/dependence/addiction (F11.2), Opioid/narcotic, withdrawal (F11.3)
- Cocaine, chronic abuse/dependence/addiction (F14.2), Cocaine, withdrawal (F14.3)
- Stimulants incl methamphetamine, chronic abuse/dependence/addiction (F15.2), Stimulants incl methamphetamine, withdrawal (F15.3)
Dementia
Dx in
- Alzheimer's disease/dementia (G30)
- Dementia, NOS (F03)
- Multi-infarct dementia (F01.1)
Palliative
Palliative care (Z51.5)
Trach
Tracheostomy, has one (Z93.0)
PEG
PEG (Percutaneous Feeding Tube) Gastrostomy, has one (Z93.1)
Prosthetic Implant Graft
Iatrogenic, mechanical complication/dysfunction, internal prosthetic device or implant or graft NOS (T85.6)
Suprapubic Catheter
Suprapubic catheter, indwelling, has one (Z93.5)
Artificial Opening
Artificial opening NOS, has one (Z93.8)
Ileostomy Colostomy
Ileostomy or colostomy, has one (Z93.4)
Internal Device
- 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)
InterImplant Device
has #ImplantDevice or has #Internal Device
Charlson Diagnoses
|
|
|
MI
has ICD10 Dx classified as Charlson Component "Myocardial infarction"
CHF
has ICD10 Dx classified as Charlson Component "Congestive heart failure"
PVD
has ICD10 Dx classified as Charlson Component "Peripheral vascular disease"
CVA
has ICD10 Dx classified as Charlson Component "Cerebrovascular disease"
Pulmonary
has ICD10 Dx classified as Charlson Component "Chronic pulmonary disease"
Connective
has ICD10 Dx classified as Charlson Component "Rheumatic disease"
Ulcer
has ICD10 Dx classified as Charlson Component "Peptic ulcer disease"
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
Charlson Score * NH
Charlson Comorbidity Index * PCH/Chronic Care
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 Related
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 Score
ADL_Adlmean_NH
(ADL Score - 12) * (PCH/Chronic Care )
ADL_Adlmean_age
post Overstay2 scoring model for Grace Hospital candidates
We realized after finalizing the Overstay2 scoring model for Grace Hospital that some candidate codes would be better if their definition was tweaked.
|
Integrate these better
|
Implementation
- Template:OSDD should be used to refer to these to consistently link here
- SAS: See Template:S:\MED\CCMED contains the code that defines these for the model.
- CFE: Overstay2 module Function Get_Overstay_Parameters_from_ID