Dispo field: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
Line 91: Line 91:
== Related Articles ==
== Related Articles ==
{{Related Articles}}
{{Related Articles}}
{{DJ |
* "Hospice - other, WPG" is currently not grouped as Hospital {{=}} "Other Institution in WPG" as the other hospices - should it be? [[User:Ttenbergen|Ttenbergen]] 17:03, 11 March 2025 (CDT)
}}


== Legacy ==
== Legacy ==
* 2025-03-11
** one other option in EPR for discharge to was "TRSF to Residential Care" - we decided not to switch to this because we currently record more detailed information.
{{DL |
That more detailed info included things like [[HSC Lennox Bell]]; we discussed whether or not we need to document the details of this. If so, the following is likely a starting point:
* Home
* Home with support
* Institution NOS
* TRSF Group/Supportive housing
* TRSF to Correctional Facility
* any [[Hospice]]s
* GH-Transitional care
* HSC - Transitional care
* Misericordia  - Transitional care
* STB - Transitional care
* VIC - Transitional care
* HSC Lennox Bell
* Manitoba Adolescent Treatment Center - unknown/other
}}
* 2025-03-07
* 2025-03-07
** started to collect "TRSF to Correctional Facility" as dispo to be consistent with EPR; for [[Previous Location]] continue to use the old entry "Institution, NOS"
** started to collect "TRSF to Correctional Facility" as dispo to be consistent with EPR; for [[Previous Location]] continue to use the old entry "Institution, NOS"


=== earlier legacy info ===
This field is part of the [[2016 Time and Place changes]] and was affected by the [[PatientFollow_Project]].
This field is part of the [[2016 Time and Place changes]] and was affected by the [[PatientFollow_Project]].



Revision as of 17:03, 11 March 2025

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.

  • SMW

Legacy implementation right in the table

  • Cargo


  • Categories
  • Forms


Collection Instruction

surviving patients

Homeless patients

If a homeless patient is discharged, either to a place like Siloam Mission, shelter 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 "TRSF to Correctional Facility" as dispo to be consistent with EPR

See Prison / Jail / Correctional Institution for additional coding instructions that may apply.

Additional options similar to "Home"

We have several "Home" like discharge options:

  • Home with Support - ???details
  • pls fill definition details above
    • well I'm not sure I should be the one to define this, I would think home with support would be HC services? but do we want to include if they have a nurse coming for say dressing changes?
      • I'd think so, since it would still risk delaying discharge. I thought the whole reason this came up is because these are now in EPR... Ttenbergen 10:31, 10 March 2025 (CDT)
  • the EPR is not specific to what services they will receive unless you read it in the chart and that is dependent on how good the documentation is. Allyson used it for a person who went home but had visits to a clinic arranged after. I would not have used it for that because they leave their home to go to the clinic, but it needs clarifying what is included Lisa Kaita 12:39, 10 March 2025 (CDT)
    • The suggestion to include it in collection came up because there was talk about adding it as a specific dispo in EPR. Has that not happened yet, then. We should absolutely clarify what it means, though. Ttenbergen 17:48, 10 March 2025 (CDT)
      • It has been there for a long time, we have haven't used it though Lisa Kaita 21:01, 10 March 2025 (CDT)
        • Yes, we have not coded it; we discussed that it would be useful to have. So, if it's in EPR one way to define it would be to simply code it from there. Often we include times when that should be overruled. Ttenbergen 00:46, 11 March 2025 (CDT)
  • SMW


  • Cargo


  • Categories


  • TRSF Group/Supportive housing - ???details
  • supportive housing may be difficult to parse out but I assume for the LAU project that allied health will be heavily involved and would document this
    • I thought the whole reason this came up is because these are now in EPR... Ttenbergen 10:31, 10 March 2025 (CDT)
  • Have not seen this yet in EPR Lisa Kaita 21:01, 10 March 2025 (CDT)
    • Possible it has not been rolled out. I seem to remember an email they were doing this and then another cancelling that. Ttenbergen 00:46, 11 March 2025 (CDT)
  • SMW


  • Cargo


  • Categories

If the entry from ADT doesn't align with what is found in the chart then correct the entry to what you think is correct.

Chronic Health Facility

This is somewhat messy and fluid, so see Chronic Health Facility

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.

Manitoba Nursing Station

  • use outside city -unknown/other

Deceased patients

See

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

SQL query of what is currently available   
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)

 AppStatus
Check pre acute consistentCCMDB.accdbdeclined
Function Validate DispoCCMDB.accdbimplemented
Check function location NE dispoCCMDB.accdbimplemented
Query check ICD10 dx implying death must have appropriate dispoCCMDB.accdbimplemented
Query check dispo lower acuity than locationCCMDB.accdbretired
Link suspect dead then alive queryCentralized data front end.accdbimplemented
Link suspect mismatch to ours incomplete queryCentralized data front end.accdbimplemented
Link_suspect_not_same_visitAdmitDtTm queryCentralized data front end.accdbimplemented
Query cardiac arrest throughout admissionCentralized data front end.accdbneeds review
Link_suspect_visitAdmitDtTm_mult_to-from-home queryCentralized data front end.accdbready to implement

Implementation

The field is populated with options from the s dispo table.

Related Articles

Related articles:


  • "Hospice - other, WPG" is currently not grouped as Hospital = "Other Institution in WPG" as the other hospices - should it be? Ttenbergen 17:03, 11 March 2025 (CDT)
  • SMW


  • Cargo


  • Categories

Legacy

  • 2025-03-11
    • one other option in EPR for discharge to was "TRSF to Residential Care" - we decided not to switch to this because we currently record more detailed information.

That more detailed info included things like HSC Lennox Bell; we discussed whether or not we need to document the details of this. If so, the following is likely a starting point:

  • Home
  • Home with support
  • Institution NOS
  • TRSF Group/Supportive housing
  • TRSF to Correctional Facility
  • any Hospices
  • GH-Transitional care
  • HSC - Transitional care
  • Misericordia - Transitional care
  • STB - Transitional care
  • VIC - Transitional care
  • HSC Lennox Bell
  • Manitoba Adolescent Treatment Center - unknown/other
  • SMW


  • Cargo


  • Categories
  • 2025-03-07
    • started to collect "TRSF to Correctional Facility" as dispo to be consistent with EPR; for Previous Location continue to use the old entry "Institution, NOS"

earlier legacy info

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