Dispo field: Difference between revisions
Ttenbergen (talk | contribs) mNo edit summary |
|||
Line 38: | Line 38: | ||
{{DL| | {{DL| | ||
* you removed <nowiki>{{PCH Riverview Deer Lodge}}</nowiki>; that template is also linked from [[Chronic Health Facility]]. The two will now show inconsistent content. When content is driven by a template like that it is always so it stays consistent across the wiki. Pls have a look at [[Template:PCH Riverview Deer Lodge]] and [[Chronic Health Facility]] to consider if (a) the two should really be inconsistent now or (b) we should re-instate the template and fix its content. Catch me on teams if you want more information or help with this. [[User:Ttenbergen|Ttenbergen]] 14:05, 2024 October 16 (CDT) | * you removed <nowiki>{{PCH Riverview Deer Lodge}}</nowiki>; that template is also linked from [[Chronic Health Facility]]. The two will now show inconsistent content. When content is driven by a template like that it is always so it stays consistent across the wiki. Pls have a look at [[Template:PCH Riverview Deer Lodge]] and [[Chronic Health Facility]] to consider if (a) the two should really be inconsistent now or (b) we should re-instate the template and fix its content. Catch me on teams if you want more information or help with this. [[User:Ttenbergen|Ttenbergen]] 14:05, 2024 October 16 (CDT) | ||
*Lets set up a time to discuss this, I don't think I knew they were templates, I thought I was editing an article [[User:Lkaita|Lisa Kaita]] 13:16, 2024 October 31 (CDT) | |||
}} | }} | ||
Revision as of 12:16, 2024 October 31
Data Element (edit) | |
Field Name: | dispo |
CCMDB Label: | Dispo |
CCMDB tab: | Dispo |
Table: | L Log table |
Data type: | number |
Length: | long |
Program: | Med and CC |
Created/Raw: | Raw |
Start Date: | 2016-07-01 |
End Date: | 2300-01-01 |
Sort Index: | 41 |
The Dispo field contains information about what happens to the patient at the end of their admission.
Collection Instruction
surviving patients
- Enter:
- see Visits to temporary locations for dispo to temporary locations, ie. OR, dialysis, procedure suites of all types, imaging suites/radiology
- HSC_stepdown unit
|
- AMA see also BedHeldEnd DtTm
Homeless patients
If a homeless patient is discharged, either to a place like Siloam Mission or even without a specific plan, then code them as discharged to home. Consider whether they might have left AMA.
Prison / Jail / Correctional Institution
If a patient is discharged to prison, jail or a correctional institution, code this as a Institution NOS.
- Pre acute living situation field should be coded as: Jail/correctional institution.
Chronic Health Facility
- use <site>_ward e.g. Riverview stroke rehab, Oaks ward
- If the patient is discharged to the PCH portion of Deer Lodge or Riverview use Winnipeg PCH
|
Discharged to ER or Urgent Care
If you discharge a patient to the ER or Urgent Care, you can't enter this in the dispo field. The reason is that this should not happen. If it really does happen:
- enter Not Canada or USA - unknown/other (this is a very rare entry so when we see it, we can question it. Put a note in to the Notes field so Pagasa can check there first.)
- email Pagasa so she can enter your ER / Urgent Care location as dispo.
We don't want ER to be available in the dropdown because it had been mistakenly entered a number of times. If it turns out there are a lot of legitimate discharges to ER we will make the option available.
Deceased patients
See
- Deceased patients#General instructions for deceased patients
- Guideline for coding organ donation after death
- Visits to temporary locations
"Can we remove the items that are no longer Service/Locations, Previous Locations, Pre-admit Inpatient Institutions or dispo locations from the dropdowns?"
We can and will remove them, but that can only happen once no more laptops use them. We will need to keep track of this and then remove them when ready. If I removed them now, then any box that currently has them enter would misbehave.
query of what is currently available
SQL |
SELECT s_dispo.location_name, s_dispo.Site, s_dispo.active, s_dispo.inpatient, s_dispo.previous_location, s_dispo.s_location, s_dispo.dispo FROM s_dispo WHERE (((s_dispo.Site)>"") AND ((s_dispo.active)=True) AND ((s_dispo.inpatient)=True)) OR (((s_dispo.Site)>"") AND ((s_dispo.active)=True) AND ((s_dispo.previous_location)=True)) OR (((s_dispo.Site)>"") AND ((s_dispo.active)=True) AND ((s_dispo.s_location)=True)) OR (((s_dispo.Site)>"") AND ((s_dispo.active)=True) AND ((s_dispo.dispo)=True)); |
Query of what is currently used
query z_s_dispo_inactivatable
Data Use
- Unit Mortality
- Intra or Inter Transfer Rate
- Discharges out of hospital
- Organ donor rate
- AMA Rate
- Linking admissions
Cross checks
Data Integrity Checks (automatic list)
App | Status | |
---|---|---|
Check pre acute consistent | CCMDB.accdb | declined |
Function Validate Dispo | CCMDB.accdb | implemented |
Check function location NE dispo | CCMDB.accdb | implemented |
Query check ICD10 dx implying death must have appropriate dispo | CCMDB.accdb | implemented |
Query check dispo lower acuity than location | CCMDB.accdb | retired |
Link suspect dead then alive query | Centralized data front end.accdb | implemented |
Link suspect mismatch to ours incomplete query | Centralized data front end.accdb | implemented |
Link suspect not same visitAdmitDtTm query | Centralized data front end.accdb | implemented |
Query cardiac arrest throughout admission | Centralized data front end.accdb | needs review |
Implementation
The field is populated with options from the s dispo table.
Related Articles
Legacy
This field is part of the 2016 Time and Place changes and was affected by the PatientFollow_Project.
It a combination of our previous
Data from these fields has been back-populated to the this field so data is available from the beginning of the database.
Related articles:
Very early missing Discharge-tos
There were 6762 very old ICU records who are listed as survived but didn’t have a discharge-to. This is from HSC-only days when there simply were no checks.
When data was brought across from the old discharge to field the dispo fields of these records were set to 'survive(Legacy)'.