Beds occupied by transferrable patients (Critical Care): Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
JMojica (talk | contribs)
JMojica (talk | contribs)
No edit summary
Line 27: Line 27:


===Frequency===
===Frequency===
* Once the transfer ready date has been written and the allowable 2.0 hours has elapsed, compute [[Transfer Delay (Critical Care)]] or the total time it takes for ICU patient to leave the unit.  
* Recorded [[Transfer Delay (Critical Care)|Transfer Delay]]   
**If no time is indicated with the transfer ready date_tm field a proxy time of 10:00 am for day shift and midnight for night shift will be used for calculation purposes. 
* Monthly, quarterly or yearly basis based on either ICU Admission Dates or ICU Discharge Dates.
* To be completed at time of discharge from ICU, compute the total days spent in ICU (refer as [[LOS]])
* To be calculated and reported on a monthly, quarterly or yearly basis based on either ICU Admission Dates or ICU Discharge Dates.
* For the Director reports, the discharge dates are used as the time of reference.
* For the Director reports, the discharge dates are used as the time of reference.


==Definition and Derivation==
==Definition and Derivation==
Avoidable days is defined as the total time from date/time of transfer ready to date/time transfer out of ICU (in hours) less 2.0 hours (and divided by 24 to give yield total avoidable days)
*Refer to the definition of [[Transfer Ready DtTm]] and [[Transfer Delay (Critical Care)]]
*Refer to the definition of [[Transfer Ready DtTm]] and [[Transfer Delay (Critical Care)]]


Line 42: Line 38:


===Denominator===
===Denominator===
Denom =Total Patient Days on the same period as the numerator
Denom =number of calendar days in a given period
 
===Formula===
===Formula===
Avoidable Days (%) = Num / Denom * 100
Beds Occupied by transferable patient = Num / Denom  
 
===Example===
===Example===
*Time Reference: Discharge Dates from Jan 1, 2017 to March 31, 2017
*Time Reference: Discharge Dates from Jan 1, 2021 to March 31, 2021
*Total Avoidable Days of all patients with transfer ready date-time= 254.5
*Total Transfer Delays for patients who went to Ward/Home= 200
*Total LOS of all ICU discharges = 1175.3
*Beds Occupied by Transferable Patients to Ward/Home = 200 / 90 = 2.22
*Avoidable Days (%) = 254.5 / 1175.3 * 100= 21.7%
 
==Data Sources==
==Data Sources==
* Per patient [[Transfer Delay (Critical Care)]]  
* Per patient [[Transfer Delay (Critical Care)]]  
**Before Oct 1, 2020 : derived from [[Transfer Ready DtTm field]] and [[Dispo DtTm field]].
**Before Oct 1, 2020 : derived from [[Transfer Ready DtTm field]] and [[Dispo DtTm field]].
**Starting Oct 1, 2020: derived from the first transfer ready date and time in the [[Transfer Ready DtTm tmp entry]] and [[Dispo DtTm field]] .
**Starting Oct 1, 2020: derived from the first transfer ready date and time in the [[Transfer Ready DtTm tmp entry]] and [[Dispo DtTm field]] .
*Per patient [[LOS]] is derived from [[Accept DtTm field]] or [[Arrive DtTm field]] and [[Dispo DtTm field]]
==SAS Program==
==SAS Program==
X:\Julie\SAS_CFE\CFE_macros\logphiunit.sas
X:\Julie\SAS_CFE\CFE_macros\logphi.sas


== Data Integrity Checks ==
== Data Integrity Checks ==

Revision as of 16:43, 14 December 2021

Beds Occupied by Transferable Patients is the average number of ICU bed per day being occupied by the patient no longer requiring the intensity of care provided in an ICU setting.

Indicators
Indicator: Beds occupied by transferrable patients (Critical Care)
Created/Raw: Created
Program: Critical Care
Start Date: Jan 1 2013
End Date:
Reports: Critical Care Program Quality Indicator Report


  • Cargo


  • SMW:
  • Categories
  • Default form:

QI domain

  • Efficient

Reported as

Percent of total patient days

Significance

Beds Occupied by Transferable Patients is the average number of ICU bed occupied per day by patients no longer requiring the intensity of care provided in an ICU setting. It can identify and quantify issues around flow out of the ICU.

Sampling Plan / Procedure

Inclusion Criteria

100% of all patients physically present in an ICU bed awaiting transfer out of the ICU and having a date value on the Transfer Ready DtTm field

  • For the Critical Care Report, the Directors and QIT , agreed in 2018 to have two transfer delay calculation
    • when patient went to IICU or H6
    • when patient went to home, to other wards, to outside hospital ward, rehab, PCH and those who died

Exclusion Criteria

Frequency

  • Recorded Transfer Delay
  • Monthly, quarterly or yearly basis based on either ICU Admission Dates or ICU Discharge Dates.
  • For the Director reports, the discharge dates are used as the time of reference.

Definition and Derivation

Numerator

Num = Total Transfer Delay (Critical Care) in a given period

Denominator

Denom =number of calendar days in a given period

Formula

Beds Occupied by transferable patient = Num / Denom

Example

  • Time Reference: Discharge Dates from Jan 1, 2021 to March 31, 2021
  • Total Transfer Delays for patients who went to Ward/Home= 200
  • Beds Occupied by Transferable Patients to Ward/Home = 200 / 90 = 2.22

Data Sources

SAS Program

X:\Julie\SAS_CFE\CFE_macros\logphi.sas

Data Integrity Checks

Data use

see infobox

Report Users

  • Critical Care Directors and Site Managers
  • Critical Care Quality Improvement Team (QIT)

Change Log

July 1, 2018 - Definition changed "Avoidable days is defined as the total time from date/time of transfer ready to date/time transfer out of ICU (in hours) less 2.0 hours (and divided by 24 to give yield total avoidable days)" from 4 hrs as per instruction by p:Jodi Walker Tweed.

Related articles

Related articles: