Project Overstay2
| Projects | |
| Active?: | planned |
| Program: | Med |
| Requestor: | Dan Roberts |
| Collection start: | 2025-07-02 |
| 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
Data required in addition to Minimal Data Set
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: |
- 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
|
what part of File:DPST GGH.pdf? |
|
|
|
Sources
- File:DPST GGH.pdf
- usual collection from chart
<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 |