Dispo field

From CCMDB Wiki
Jump to navigation Jump to search
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

Transition to PatientFollow Project

Use the new method for patients with a Dispo DtTm after the PatientFollow_Project#Transition_dates, even for patients who were accepted before the transition date.   

For other components of PatientFollow, the new instructions are based on a patient's Accept DtTm. The change to using e.g. "HSC_Med" in Dispo needs to be based on the Dispo DtTm because otherwise the old entries won't link up to the new entries when Pagasa does the Linking. Ttenbergen 16:50, 2020 October 23 (CDT)

Collection instructions

surviving patients

  • so if a patient is taken to the OR direct from your unit (either from medicine or ICU) the dispo loc will still be <site>_ward? (Sherry)
  • SMW

  • Cargo

  • Categories


Enter "AMA (left against medical advice)" for patients who leave against medical advice (type "AMA" to open up drop down).

AMA is used as follows:

  1. AMA is being excluded in the calculation of Readmission rate.
  2. AMA is being counted as HOME in reporting for the location the patient went after discharge.
  3. AMA as itself for specific request.

AMA should be entered whether the patient follows the WRHA AMA process (signing form etc) or just goes AWOL. This will lead to proper reporting for the first two points, and it will allow a chart review to exclude AWOL person depending on the data requirements in the third case.

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.

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 Other Continents - 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

Deceased patients


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

  • Julie contacted Pam re STB Transitional, and will contact Lisa about HSC transitional and Lennox Bell and other HSC locations.
  • SMW

  • Cargo

  • Categories

Swiss Army Knife.svg

  • Since no one person knows when an s_dispo item is no longer used on any laptop. Made CFE query z_s_dispo_inactivatable to check. Should check that query occasionally to review if other things can be cleaned up.
  • added: 2020-10-20
  • action: 2022-01-05
  • Cargo

  • Categories

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

  • is there any chance we can have the Dispo list cleaned up if we're using the above options? There are still +++ inpatient options for the hospitals? I guess this would also apply to the Previous Location and Pre-Admit lists as well.
  • SMW

  • Cargo

  • Categories

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)

Function Validate DispoCCMDB.accdbimplemented
Check function location NE dispoCCMDB.accdbimplemented
Query check ICD10 dx implying death must have appropriate dispoCCMDB.accdbimplemented
Check pre acute consistentCCMDB.accdbneeds review
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


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

Related Articles

Related articles:


This field is part of the 2016 Time and Place changes.

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