Dispo field: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (clean-up and re-linking in prep for discussion with Laura)
Line 69: Line 69:


This will become relevant to the Dispo field when data is brought across from the old [[discharge to]] field.
This will become relevant to the Dispo field when data is brought across from the old [[discharge to]] field.
{{discussion}}
* How were those populated, or were they left blank? Ttenbergen 16:35, 2016 November 28 (CST)


These records had been populated by the data value 'survive(Legacy)' in the [[dispo]] field.


[[Category: 2016 Time and Place changes]]
[[Category: 2016 Time and Place changes]]

Revision as of 16:27, 2017 March 16

Data Element (edit)
Field Name: dispo
CCMDB Label: Dispo
CCMDB tab: not stated
Table: L_Log
Data type: integer
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

If you know the location exactly, you can type it. Otherwise press the "?" button to take you to the S dispo chooser‎ to help filter options if desired.

surviving patients

For each patient,

  • enter the location that most closely matches
    • for wards where we don't collect, enter e.g. HSC_ward
    • for wards where we do collect enter the actual ward as available in the dropdown
  • consider bed borrows

AMA

  • for patients who leave against medical advice, enter "AMA (left against medical advice)" (type "AMA" to open up drop down where you want it)

Parked in ER

Operating room visits

deceased patients

  • for patients who expire, one of
    • "Died - Organ_Donor" (follow definitions in that article)
    • "Died - NOT Organ Donor"

Data Use

  • Mortality Rate
  • Intra or Inter Transfer Rate
  • Discharges out of hospital
  • Organ donor rate
  • AMA Rate
  • Linking admissions

Template:CCMDB Data Integrity Checks

Following might still need to be implemented:

  • Check organ donors must be dead - this is a dx cross check - can it wait for ICD10? Template:ICD10 Actually, I don't think this dx will be available in ICD10, since it's not a diagnosis. So, likely it will only be coded in dispo field once ICD10 is in place, at which point this comment could go. Ttenbergen 09:56, 2016 June 16 (CDT)

Implementation

The field is populated with options from the s_dispo table.

Legacy

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 are 6762 very old ICU records who are listed as survived but don’t have a discharge-to. This is from HSC-only days when there simply were no checks. We will leave these be, just documenting here.

This will become relevant to the Dispo field when data is brought across from the old discharge to field.

These records had been populated by the data value 'survive(Legacy)' in the dispo field.