Bed occupancy: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
JMojica (talk | contribs)
 
(4 intermediate revisions by 2 users not shown)
Line 13: Line 13:


==Occupancy Calculation==
==Occupancy Calculation==
===Definition1 :Actual hours occupying a bed per day for each patient===
===Definition1: Actual hours occupying a bed per day for each patient===
*If admit date the same as discharge date - calculate the difference between the discharge time and admit time.
*If admit date the same as discharge date - calculate the difference between the discharge time and admit time.
*if admit date is not the same as disch date
*if admit date is not the same as disch date
Line 24: Line 24:
===Definition2: Get the maximum bed census and minimum bed census per day===
===Definition2: Get the maximum bed census and minimum bed census per day===
*This is being done by defining a counter for people admitted  and discharged to an ICU.  The counter is a -1 or +1.  The Admit date/time is used as the time to  +1 to census.  The discharge date/time is used as the time to  -1 to census.  On a chronological order of time,  the patient admitted is added and the patient discharged is subtracted based on time per day.  
*This is being done by defining a counter for people admitted  and discharged to an ICU.  The counter is a -1 or +1.  The Admit date/time is used as the time to  +1 to census.  The discharge date/time is used as the time to  -1 to census.  On a chronological order of time,  the patient admitted is added and the patient discharged is subtracted based on time per day.  
*Per day, the minimum and maximum census are used to  calculate the daily bed occupancy as follows:
*Per day, get the minimum and maximum census  
*Bed occupancy per day = (Minimum + Maximum)/2
*Daily Bed occupancy for a given time period (i.e. month, quarterly, year) = (Average of Minimum + Average of Maximum)/2
** use in CC Program
** use in CC Program


Line 48: Line 48:


==Definition and Derivation==
==Definition and Derivation==
# Average Daily Bed Occupancy based on Definition1
* Average Daily Bed Occupancy based on Definition1
# Average Daily Occupancy/Number of Beds in %  based on Definition2
* Average Daily Occupancy/Number of Beds in %  based on Definition2
*The number of beds opened per unit is taken from the [[Bed Census]] Database.


===Numerator===
===Numerator===
Line 63: Line 64:


==Data Sources==
==Data Sources==
[[Admit DtTm]], [[Dispo DtTm]]
[[Admit DtTm]], [[Dispo DtTm]], [[Bed Census]]


==SAS Program==
==SAS Program==
S:\MED\MED_CCMED\Julie\SAS_CFE\CFE_macros\all_bed_occupancy.sas
S:\MED\MED_CCMED\Julie\SAS_CFE\CFE_macros\all_bed_occupancy.sas
==Report Users==
*Critical Care Directors and Site  Managers
*Critical Care Quality Improvement Team (QIT)
*Medicine Directors and Site  Managers


== Related articles ==  
== Related articles ==  

Latest revision as of 08:29, 2023 November 3

Count of full or partial days patients occupy beds. Partial days are reported in a decimal fraction of a day. There are also other ways to calculate daily bed occupancy.

Indicators
Indicator: Bed occupancy
Created/Raw: Created
Program: Critical Care and Medicine
Start Date:
End Date:
Reports: Directors Quarterly and Annual Report (Critical Care), Directors Quarterly and Annual Report (Medicine)


  • Cargo


  • SMW:
  • Categories
  • Default form:

for the WRHA Regional Daily ICU Bed census (White Board) see Bed census.mdb

Bed occupancy is usually used in aggregate form as "per location" and/or "per timeframe", e.g. by day/month/quarter/year x Ward/Unit x Hospital.

Occupancy Calculation

Definition1: Actual hours occupying a bed per day for each patient

  • If admit date the same as discharge date - calculate the difference between the discharge time and admit time.
  • if admit date is not the same as disch date
    • for first date - calculate the difference between 2400 and admit time
    • for in between date - consider 1 full day
    • for last date - calculate the difference between Dispo DtTm - 001
  • Bed Occupancy per day = sum of bed occupied by all patients in a given day
    • use in CC and Medicine Programs

Definition2: Get the maximum bed census and minimum bed census per day

  • This is being done by defining a counter for people admitted and discharged to an ICU. The counter is a -1 or +1. The Admit date/time is used as the time to +1 to census. The discharge date/time is used as the time to -1 to census. On a chronological order of time, the patient admitted is added and the patient discharged is subtracted based on time per day.
  • Per day, get the minimum and maximum census
  • Daily Bed occupancy for a given time period (i.e. month, quarterly, year) = (Average of Minimum + Average of Maximum)/2
    • use in CC Program

Definition3: The number of bed census per slice of time

  • This means for a given hour of the day, how many beds are occupied.
  • This is done by adding the patient admitted and subtracting the patient discharged based on time per day as in Definition2 above.
  • Bed Occupancy per day at ##Hour = number of patients occupying a bed at ##Hour.
    • use in CC Program

QI domain

  • Timely

Significance

This measure captures the proportion of time where the ICU is functioning at or over capacity with respect to ICU beds. High occupancy indicates lack of critical care capacity or challenges with patient flow. A unit that has all their beds occupied will have difficulties admitting new patients in a timely fashion.

Sampling Plan / Procedure

Inclusion Criteria

100% all admissions

Exclusion Criteria

None

Frequency

Monthly, quarterly or yearly based on calendar dates

Definition and Derivation

  • Average Daily Bed Occupancy based on Definition1
  • Average Daily Occupancy/Number of Beds in % based on Definition2
  • The number of beds opened per unit is taken from the Bed Census Database.

Numerator

  • Definition1 Num = Sum of the Daily Bed occupancy in a given time frame
  • Definition2 Num = Sum of the Daily Bed occupancy in a given time frame

Denominator

  • Definition1 Denom = Number of calendar days in the same time frame
  • Definition2 Denom = (Number of calendar days in the same time frame) * (Number of beds)

Formula

  • Definition1 Average Daily Bed Occupancy = Definition1 Num / Definition1 Denom
  • Definition2 Average Daily Occupancy/Number of Beds in %= (Definition2 Num / Definition2 Denom) * 100

Data Sources

Admit DtTm, Dispo DtTm, Bed Census

SAS Program

S:\MED\MED_CCMED\Julie\SAS_CFE\CFE_macros\all_bed_occupancy.sas

Related articles

Related articles: