Project Overstay2

Projects
Active?:	planned
Program:	Med
Requestor:	Dan Roberts
Collection start:	within the next few weeks "within the next few weeks" contains an extrinsic dash or other characters that are invalid for a date interpretation.
Collection end:	continuous "continuous" contains an extrinsic dash or other characters that are invalid for a date interpretation.

Not live yet!

Data Collection

For any medicine record, enter the Minimal dataset +

• ADLs (ADL General Collection Information)
• Pre acute living situation - to know if they came from a Personal Care Home or Chronic Health Facility
• Province (although we could use the Postal Code instead)
• Glasgow Coma Scale
• any Admit Diagnoses contributing to the Charlson Comorbidities in ICD10 codes of Chronic pulmonary disease, Congestive heart failure, Rheumatic disease or Renal disease(as generated using same mechanism as s_ICD10_Charlson_Comorbids query; let's not use a separate list for this)

Project Overstay2-relevant Charlson codes

ICD10 code Diagnosis description Charlson component I27.81 Cor pulmonale (right heart failure due to lung disease without left heart failure) Chronic pulmonary disease I27.82 Pulmonary embolism (thromboembolism), chronic Chronic pulmonary disease I27.9 Pulmonary hypertension, NOS Chronic pulmonary disease J40 Bronchitis, acute or chronic not specified, infectious or noninfectious Chronic pulmonary disease J42 Bronchitis, chronic, infectious or noninfectious Chronic pulmonary disease J43.9 Pulmonary emphysema or bullous disease without COPD Chronic pulmonary disease J44.1 COPD, acute exacerbation Chronic pulmonary disease J44.8 COPD, without exacerbation Chronic pulmonary disease J45.901 Asthma, acute exacerbation Chronic pulmonary disease J45.909 Asthma, without acute exacerbation Chronic pulmonary disease J45.91 Status asthmaticus Chronic pulmonary disease J47 Bronchiectasis Chronic pulmonary disease J60 Coalworker's pneumoconiosis (black lung disease) Chronic pulmonary disease J61 Asbestos lung disease Chronic pulmonary disease J62 Silicosis of the lung (pneumoconiosis) Chronic pulmonary disease J64 Pneumoconiosis, NOS Chronic pulmonary disease J66 Airway disease due to inhaled organic dust Chronic pulmonary disease J67.90 Allergic bronchopulmonary aspergillosis (ABPA) Chronic pulmonary disease J67.99 Hypersensitivity pneumonitis (extrinsic allergic alveoliltis), NOS Chronic pulmonary disease J70.4 Interstitial lung disease, drug-induced (acute or chronic) Chronic pulmonary disease I09 Rheumatic heart disease, chronic Congestive heart failure I11 Heart disease, hypertensive (hypertensive cardiomyopathy) Congestive heart failure I25.5 Cardiomyopathy, ischemic Congestive heart failure I42.0 Cardiomyopathy, dilated Congestive heart failure I42.1 Cardiomyopathy, hypertrophic obstructive (HOCM, IHSS) Congestive heart failure I42.6 Cardiomyopathy, alcoholic Congestive heart failure I42.7 Cardiomyopathy, due to infection, drugs or external agents NOS Congestive heart failure I42.9 Cardiomyopathy, NOS Congestive heart failure I50.0 Congestive heart failure, NOS Congestive heart failure I50.1 Congestive heart failure with pulmonary edema Congestive heart failure I50.9 Heart failure, NOS Congestive heart failure I12 Kidney disease, hypertensive Renal disease N03 Nephritic syndrome, chronic Renal disease N04 Nephrotic syndrome Renal disease N05 Nephritic syndrome, NOS Renal disease N11 Kidney infection, chronic (pyelonephritis) Renal disease N12 Kidney, tubulo-interstitial nephritis/disease Renal disease N14 Kidney, nephropathy, drug or toxin induced Renal disease N18.1 Chronic kidney disease (chronic renal insufficiency, uremia) Stage 1, GFR GT 90 Renal disease N18.2 Chronic kidney disease (chronic renal insufficiency, uremia) Stage 2, GFR 60-89 Renal disease N18.3 Chronic kidney disease (chronic renal insufficiency, uremia) Stage 3, GFR 30-59 Renal disease N18.4 Chronic kidney disease (chronic renal insufficiency, uremia) Stage 4, GFR 15-29 Renal disease N18.5 Chronic kidney disease (end-stage renal/kidney disease, ESRD), Stage 5, GFR LT 15 Renal disease N18.9 Chronic kidney/renal disease, NOS (stage unspecified) Renal disease N19 Kidney, renal failure/insufficiency/uremia, unspecified as acute or chronic Renal disease N25.0 Kidney, renal osteodystrophy Renal disease N25.1 Diabetes insipidus (DI), nephrogenic Renal disease N25.8 Kidney, renal tubular acidosis (RTA, all types) Renal disease N25.9 Kidney, renal tubular disorder, NOS Renal disease Z49 Renal dialysis care, including dialysis itself Renal disease Z94.0 Past history, transplanted kidney Renal disease M05 Rheumatoid arthritis, joint involvement Rheumatic disease M05.1 Rheumatoid arthritis lung disease Rheumatic disease M05.3 Rheumatoid arthritis, involvement of organs NOS Rheumatic disease M06.4 Inflammatory/immune arthritis, NOS Rheumatic disease M32 Systemic lupus erythematosis (SLE, lupus) Rheumatic disease M33 Dermatomyositis/polymyositis Rheumatic disease M34 Scleroderma or CREST syndrome (systemic sclerosis) Rheumatic disease M35.1 Collagen-vascular overlap syndrome Rheumatic disease M35.3 Polymyalgia rheumatica Rheumatic disease

• Admit Diagnosis or Comorbid Diagnosis of Dementia:

Dementia codes:

Alzheimer's disease/dementia Dementia, NOS Multi-infarct dementia

• Previous Location if that is still what we want to use for "from out of town" now that we have Postal Code.

Generation of data (will be moved before go-live)

• In the generation of data, I have used the following:

OutsideWPG - I have used Previous Location because Leigh Anne specified the patient came from a facility outside of Winnipeg. MB - I would think Leigh Anne had used the Province because the data set has no Postal Code yet I just checked the query check_from_out_of_town I used to derive this and it only considered Pre-admit Inpatient Institution having geog like "out-of*"! Ttenbergen 16:57, 24 January 2025 (CST) Will ask Dr. Roberts what this was all about to better understand what to use now. Specifically, if we use previous locaiton, would we only care about hospitals, or also e.g. nursing stations, PCH, hospice, "unknown/other" loc_types. Ttenbergen 16:51, 24 January 2025 (CST)

• SMW

• Cargo

• Categories

Charlson categories are provided but the CCMDB Script model only includes MI, Pulmonary, Connective, Renal I think "connective" became "Rheumatic disease" in ICd10, right? Ttenbergen 16:41, 24 January 2025 (CST)

• SMW

• Cargo

• Categories

• • NH (Nursing Home) - these data are from the tmp Overstay and the NH start dates from Manitoba Health which DR Roberts requested. we do not have the Pre acute living situation at that time but I agree just to use the Pre acute living situation . When I Have looked at the CCMDB script I noticed that NH includes PCH and Chronic Health Facility, is this correct?
• ADL score - I have used the 0,3,6 values (same ADL as in ALERT score)

{{{1}}}

• SMW

• Cargo

• Categories

• • same with Adlmean_age = (ADLScore - 12)*(age), what does 12 mean?
  • Charlson_nh = (Charlson score)*(from a nursing home) -- this is clear. --JMojica 13:53, 24 January 2025 (CST)

Data Entry Instructions

will add these as we come closer to implementing, but it will be a button again

Sources

• for green, a form TBD
• rest: as usual

<details?>

<clarifications, usually come up during first few days of collection>

Special Cases

Data Use

This data is being collected as for Project Overstay2.

Consistency Checks

• we will need to re-apply what was set up before or set up new ones.

Data Integrity Checks (automatic list)

none found

Related articles