CCMDB Wiki

Data definition for factor candidates for the Overstay2 project

Revision as of 12:34, 10 July 2025 by JMojica (talk | contribs) (→Location / living arrangement)

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

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

construct based on Postal Code field#Rest MB Postal Code Grouping

Rest

construct based on Postal Code field#Rest Non MB Postal Code Grouping

N/A Postal code

Postal code "N/A" is grouped separately as PC_NA .

Procedures

ImplantDevice

has Admit Procedure with CCI2 code Implantation of Internal Device (53); (present/yes=1, absent/no =0)

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

Dx in

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

Palliative

Palliative care (Z51.5) (present/yes=1, absent/no =0)

Trach

Tracheostomy, has one (Z93.0) (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

Iatrogenic, mechanical complication/dysfunction, internal prosthetic device or implant or graft NOS (T85.6) (present/yes=1, absent/no =0)

Suprapubic Catheter

Suprapubic catheter, indwelling, has one (Z93.5) (present/yes=1, absent/no =0)

Artificial Opening

Artificial opening NOS, has one (Z93.8) (present/yes=1, absent/no =0)

Ileostomy Colostomy

Ileostomy or colostomy, has one (Z93.4) (present/yes=1, absent/no =0)

Internal Device

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

InterImplant Device

has #ImplantDevice or has #Internal 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

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_toilet

component score 0-3-6 of ADL Toiletting

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=164967"