Dispo field: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (moved content about a location to its own page HSC Stepdown Units)
 
(168 intermediate revisions by 15 users not shown)
Line 1: Line 1:
''This field is currently being implemented, please check the instructions and put a discussion for anything that isn't clear. ''
{{Data element
| CCMDB_tab = Dispo
|field_name=dispo
|CCMDB_label=Dispo
|Rank=Dispo
|in_table=L Log table
|data_type=number
|datafield_length=long
|program_collecting=Med and CC
|created_raw=Raw
|data_element_start_date=2016-07-01
|data_element_sort_index=41
|element_description=The Dispo field contains information about what happens to the patient at the end of their admission.
}}


The [[Dispo field]] contains information about what happens to the patient at the end of their admission.
== Collection Instruction ==
=== surviving patients ===
* Enter:
{{PrePrevDispo listing}}
 
* see [[Visits to temporary locations]] for dispo to temporary locations, ie. OR, dialysis, procedure suites of all types, imaging suites/radiology
 
==== [[HSC Stepdown Units]] ====


== Collection Instruction ==
==== [[AMA]] ====
For each patient,
* enter the location that most closely matches
Alternatively,
* for patients who expire, one of
** "Died - Organ Donor"
** "Died - NOT Organ Donor"
* for patients who leave against medical advice, enter "Left AMA"


If you know the location exactly, you can type it. Otherwise press the "magic wand" button to take you to the [[S dispo chooser‎]] to help filter options if desired.
==== [[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]].


== Questions ==
==== [[Prison / Jail / Correctional Institution]] ====
=== ICU Accept time ===
If a patient is '''discharged to prison, jail or a correctional institution''', code this as a '''Institution NOS'''.
*For the ICU we do not have an accept time so what do we do with this field? Lois
*[[Pre acute living situation field]] should be coded as: Jail/correctional institution.
** You do have an ICU accept time, just most of the time it's the same as the arrive time. I have added a button to just populate it. Ttenbergen 15:49, 2016 April 13 (CDT)


=== generic PCHs ===
===[[Chronic Health Facility]] ===
*Unable to access Peguis PCH or any generic PCH, tried using magic wand but did not work.--[[User:CMarks|CMarks]] 09:52, 2016 April 13 (CDT)
{{PCH Riverview Deer Lodge}}
** Yes, we need to figure out how to code the WPG generic and out of town PCHs; emailed Trish to discuss. Ttenbergen 15:49, 2016 April 13 (CDT)


=== missing Var1/2 equivalents ===
==== Discharged to ER or [[Urgent Care]] ====
{{Discussion}}
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:
*is dispo field replaces Discharge to and Var 2, why are there wards missing, example HSC RR6, HSC surgical wards?
* 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.)
*Not all the wards for St.B are listed ie. I send most of my patients to CR4 which is not on the list. Lois
* email Pagasa so she can enter your ER / Urgent Care location as dispo.
** see discussion at [[Var_1_-_Admit-from_Ward#Wards_where_we_don.27t_collect]] Ttenbergen 15:35, 2016 April 13 (CDT)


=== missing USA? ===
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.
{{Discussion}}
*missing from list is ADMIT From or discharge USA.  USA is not Other Continent
** USA is on list and can be filtered as out of country; If you can still not see it please let me know how you are going about looking for it. If you can see it now, pls delete. Ttenbergen 15:35, 2016 April 13 (CDT)


=== why not combine fields at dispo? ===
==== [[Visits to temporary locations]] ====
{{Discussion}}
See [[Visits to temporary locations]]
*I know we are trying to combine Admit from, Var 1 and Hospital previous, so why not at discharge, if to other city or province, why not include specifically where if we know?
** should be able to enter that into dispo field, what are you searching for that you can't find? Ttenbergen 15:35, 2016 April 13 (CDT)


=== responsibility to fill in ===
=== [[Deceased patients]] ===
* Who is responsible for filling in the dispo fields? If patient has been transferred around the site/s do we need to address all or just immediate prior? --[[User:Llemoine|Llemoine]] 12:45, 2016 March 23 (CDT)
See
** I think this will need to be filled in properly everywhere. We would not necessarily link patient stays together if there is a question for records, we only do it if a whole stay is required. This is probably something we should tweak further and see what Julie thinks as well. - Ttenbergen 14:16, 2016 March 24 (CDT)
* [[Deceased patients#General instructions for deceased patients]]
* [[Guideline for coding organ donation after death]]
* [[Visits to temporary locations]]


=== values not being accepted ===
{{Location dropdown cleanup}}
{{discussion}}
*Some of drop down site locations aren't being accepted into field as error code pops up and declares too much text --[[User:Llemoine|Llemoine]] 12:45, 2016 March 23 (CDT)
** Can you give an example? I have not got any errors like that in my testing. Which field is this? Ttenbergen 14:16, 2016 March 24 (CDT)


== Data Use ==
== Data Use ==
{{discussion}} Many things, need to pull them together Ttenbergen 12:59, 2016 March 21 (CDT)
* [[Unit Mortality]]
* Intra or Inter Transfer Rate
* Discharges out of hospital
* Organ donor rate
* AMA Rate
* Linking admissions


== {{CCMDB Data Integrity Checks}} ==
== Cross checks ==
* Organ donor dx consistent with "died - ..."
{{Data Integrity Check List}}


== Implementation ==
== Implementation ==
The field is populated with options from the [[s_dispo table]].
The field is populated with options from the [[s dispo table]].
 
== Related Articles ==
{{Related Articles}}


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


It a combination of our previous  
It a combination of our previous  
* [[Admit From & Discharged To | Discharge To]]
* [[Admit From & Discharged To|Discharge To]]
* [[Var 2 - Discharge-to Ward]]
* [[Var 2 - Discharge-to Ward]]
* [[ICU Var 6 - AMA]]
* [[ICU Var 6 - AMA]]
* [[Survive / Expired]]
* [[Survive / Expired]]
Data from these fields has been back-populated to the this field so data is available from the beginning of the database.
Related articles:  
Related articles:  
* [[Organ Donor]]/[[Braindead]]
* [[Organ Donor]]/[[Braindead]]


{{discussion}}
=== Very early missing Discharge-tos ===
clean-up required:
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.
* delete '''X:\!AdmitFrom_DischTO_NEW_Dispo_codes'''
 


When data was brought across from the old [[discharge to]] field the [[dispo]] fields of these records were set to 'survive(Legacy)'.


[[Category: 2016 Time and Place changes]]
[[Category:2016 Time and Place changes]]
[[Category: Admit/Discharge]]
[[Category:Admit/Discharge]]
[[Category:Registry Data]]
[[Category:Dispo]]
[[Category:Data Collection Guide]]

Latest revision as of 10:56, 2023 December 13

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

HSC Stepdown Units

AMA

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.

Chronic Health Facility

If a patient is discharged to a PCH bed at Deer Lodge or Riverview, then the option "Winnipeg PCH" should be used in the Dispo field.

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.

Visits to temporary locations

See Visits to temporary locations

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.

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)

 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

Implementation

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

Related Articles

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

Retrieved from "https://ccmdb.kuality.ca/index.php?title=Dispo_field&oldid=160488"