Bed occupancy
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) |
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, the minimum and maximum census are used to calculate the daily bed occupancy as follows:
- Bed occupancy per day = (Minimum + 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
Numerator
Num = Sum of the Daily Bed occupancy in a given period
Denominator
Denom = Number of calendar days on the same period
Formula
Average Daily Bed Occupancy = Num / Denom
Data Sources
Admit DtTm, Dispo DtTm
SAS Program
S:\MED\MED_CCMED\Julie\SAS_CFE\CFE_macros\all_bed_occupancy.sas