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)

• 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 Med

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

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.

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