Data definition for factor candidates for the Overstay2 project

From CCMDB Wiki
Jump to navigation Jump to search

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

Overstay

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 in years 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" (present/yes=1, absent/no =0)

PCH/Chronic Care

Pre acute living situation field in ("Personal Care Home", "Chronic Health Facility") (present/yes=1, absent/no =0)

FromNonWPGfacility

Previous Location or Pre-admit Inpatient Institution corresponding to s_dispo.geog in ('out-of-WPG','out-of-MB','out-of-CAN') (present/yes=1, absent/no =0)

Postal Code field based

Winnipeg_Plus
MB

Province = 'MB' or maybe Postal Code (present/yes=1, absent/no =0)

North-Western Ontario

construct based on Postal Code field#ON-NorthWestern (present/yes=1, absent/no =0)

Northern MB

construct based on Postal Code field#MB-Northern (present/yes=1, absent/no =0)

Rest MB

construct based on Postal Code field#MB-Rest (present/yes=1, absent/no =0)

Rest

construct based on [[Postal Code field#Postal Code field#Grouping by Geographical Area

(present/yes=1, absent/no =0)

Procedures

ImplantDevice

has Admit Procedure with CCI2 code Implantation of Internal Device (53) or ( CCI2 code Dilation (50) and Therapeutic only ) (present/yes=1, absent/no =0)

  • Book meeting with Lisa and Julie to work out Ttenbergen 16:40, 11 July 2025 (CDT)
    • There are other procedures that may contribute to DC delay, but are not necessarily implantation of internal device, things such as TIPS (picklist), ERCP (picklist), permanent pacemaker (picklist) tunneled line insertion, CVC (picklist) but it is code only first so it may not be captured if they had a temp line that was coded as their first CVC, I'm sure there are more that I can't think of right now Lisa Kaita 08:26, 13 July 2025 (CDT)
      • OK, that is an interesting additional concept: people waiting for a procedure who might otherwise be ready for discharge. I'll break that out into #Procedure waits that cause discharge delays. I was looking for something different with this, though: many community settings have criteria that exclude people who require extra work/medical expertise, or who increase risk; so, people who have had a procedure that leaves them with a device have fewer discharge options, leading to delays. This is what I was trying to capture with this element. What is your take on this element with that lens? Let me know if better to meet. Ttenbergen 16:56, 18 July 2025 (CDT)
  • SMW


  • Cargo


  • Categories

Procedure waits that cause discharge delays

There are procedures that may contribute to DC delay due to waits for the procedure itself. For example:

  • Keeping in mind that the Overstay2 model only considers Admit Diagnoses and Comorbid Diagnoses, this might not be a signal that is available. Are there diagnoses that make it especially likely that one of those will be the chosen therapy? Those might be a signal available at admission. However, also keep in mind that this model tests not for LOS, but for Discharge Delay, so it would only catch patients who have been cleared for discharge, which those waiting for a procedure would probably not be, right? But: does this general line of inquiry make anyone think of similar things that we might be able to capture? Ttenbergen 16:56, 18 July 2025 (CDT)
  • SMW


  • Cargo


  • Categories

Diagnoses

ICD10 Diagnoses (Admit Diagnosis or Comorbid Diagnosis) that might prevent/delay meeting PCH/Home Care criteria.

Opioids

Acute/Overdose Toxicity

(present/yes=1, absent/no =0)

Chronic Addiction

(present/yes=1, absent/no =0)

Dementia

(present/yes=1, absent/no =0)

Palliative

(present/yes=1, absent/no =0)

Trach

(present/yes=1, absent/no =0)

PEG

  • PEG (Percutaneous Feeding Tube)

Gastrostomy, has one (Z93.1) (present/yes=1, absent/no =0)

Prosthetic Implant Graft

(present/yes=1, absent/no =0)

Suprapubic Catheter

(present/yes=1, absent/no =0)

Artificial Opening

(present/yes=1, absent/no =0)

Ileostomy Colostomy

(present/yes=1, absent/no =0)

Heart Assist Device

(present/yes=1, absent/no =0)

to be confirmed

  • SMW


  • Cargo


  • Categories

Internal Device

(present/yes=1, absent/no =0)

InterImplant Device

(present/yes=1, absent/no =0)

Charlson Diagnoses

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 Comorbidity Index

Charlson Score * NH

Charlson Comorbidity Index * PCH/Chronic Care

Glasgow Coma Scale

Eye

points associated with the AP_Eye field of the 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

component score 0-3-6 of ADL Bathing

ADL_dress

component score 0-3-6 of ADL Dressing

ADL_toilet

component score 0-3-6 of ADL Toiletting

ADL_transfer

component score 0-3-6 of ADL Transfering

ADL_feed

component score 0-3-6 of ADL Feeding

ADL_continence

component score 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

  • SMW


  • Cargo


  • Categories

Implementation

  • Template:OSDD should be used to refer to these to consistently link here
  • SAS: See S:\MED\Med_CCMED\​Julie\MedProjects\Overstay_Project_2025\Data\6Feb2025_Oct2020toDec2024Data\prepdata_7Feb2025.sasS:\MED\Med_CCMED\Julie\MedProjects\Overstay_Project_2025\Data\6Feb2025_Oct2020toDec2024Data\prepdata_7Feb2025.sas contains the code that defines these for the model.
  • CFE: Overstay2 module Function Get_Overstay_Parameters_from_ID

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Data_definition_for_factor_candidates_for_the_Overstay2_project&oldid=165063"