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

so should we do this by what is listed at Postal Code field#Grouping by Area or the simpler "R2* or R3*" Ttenbergen 09:45, 25 June 2025 (CDT)

• SMW

• Cargo

• Categories

FromNonWPGfacility

Previous Location corresponding to s_dispo.geog in ('out-of-WPG','out-of-MB','out-of-CAN')

Also see #post Overstay2 scoring model for Grace Hospital candidates for how this definition changes for future models.

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

• SMW

• Cargo

• Categories

Rest

Details needed...

• SMW

• Cargo

• Categories

???

we talked about a grouping that deals with the "N/A" outside of Winnipeg, if we do that we need to integrate it here.

• SMW

• Cargo

• Categories

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) Saw your log entry in Overstay2 scoring model for Grace Hospital - do your new Opioid groupings follow the list below? Ttenbergen 00:20, 30 June 2025 (CDT)

• SMW

• Cargo

• Categories

Acute/Overdose Toxicity

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

• 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

on Re-analysis and generation of Overstay2 model it had said "score of the component is used" but I think you said that you used 1/0... which is it? Ttenbergen 11:06, 25 June 2025 (CDT)

• SMW

• Cargo

• Categories

MI

has ICD10 Dx classified as component score for Charlson Component "Myocardial infarction"

CHF

has ICD10 Dx classified as component score for Charlson Component "Congestive heart failure"

PVD

has ICD10 Dx classified as component score for Charlson Component "Peripheral vascular disease"

CVA

has ICD10 Dx classified as component score for Charlson Component "Cerebrovascular disease"

Pulmonary

has ICD10 Dx classified as component score for Charlson Component "Chronic pulmonary disease"

Connective

has ICD10 Dx classified as component score for Charlson Component "Rheumatic disease"

Ulcer

has ICD10 Dx classified as component score for Charlson Component "Peptic ulcer disease"

Plegia

has ICD10 Dx classified as component score for Charlson Component "Hemiplegia or paraplegia"

Diabetes

has ICD10 Dx classified as component score for Charlson Component "Diabetes with chronic complications"

Renal

has ICD10 Dx classified as component score for Charlson Component "Renal disease"

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 Score

ADL_Adlmean_NH

(ADL Score - 12) * (PCH/Chronic Care )

ADL_Adlmean_age

(ADL Score - 12) * ( 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 re pre admit for outside Winnipeg facility discussion, change from getting from Previous Location only to getting it from both Previous Location and Pre-admit Inpatient Institution; this was missed before because we based the initial fields on the last overstay project, and back then these two fields were still combined re-institute amputation; before we were only looking at the CCI code, but we should consider Past history, loss of limb(s) as well

• SMW

• Cargo

• Categories

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