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! This page contains the collection instructions and the data description for the Overstay2 project. For other information, see Overstay2 Overview.

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

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 generation and Storage

A button on the Patient viewer form triggers code in VBA module Overstay2 that generates an overstay score and colours the button based on that value.

The value is stored in L_TmpV2 table with Project "Overstay2" and Item "Overstay Score". During early testing, the score is 999998 just to have a crazy outlier so we remember to exclude these later. That number turns the button blue.

Data Use

This data is being collected as for Project Overstay2.

Files

SAS, analysis reports and data files are at

• \\ad.wrha.mb.ca\WRHA\HSC\shared\MED\MED_CCMED\Julie\MedProjects\Overstay_Project_2025

Consistency Checks

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

Data Integrity Checks (automatic list)

	App	Status
Query check_tmp_Overstay2	CCMDB.accdb	needs review

Related articles