Bed occupancy: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
|||
| (10 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 20: | Line 20: | ||
** for last date - calculate the difference between [[Dispo DtTm]] - 001 | ** 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 | *Bed Occupancy per day = sum of bed occupied by all patients in a given day | ||
** use in CC and | ** use in CC and Medicine Programs | ||
===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 | *Per day, get the minimum and maximum census | ||
*Bed occupancy | *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 === | ===Definition3: The number of bed census per slice of time === | ||
| Line 31: | Line 32: | ||
*This is done by adding the patient admitted and subtracting the patient discharged based on time per day as in Definition2 above. | *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. | *Bed Occupancy per day at ##Hour = number of patients occupying a bed at ##Hour. | ||
** use in CC Program | |||
===QI domain=== | ===QI domain=== | ||
*[[QualityDomain::Timely]] | *[[QualityDomain::Timely]] | ||
==Significance== | ==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. | 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. | ||
| Line 47: | Line 48: | ||
==Definition and Derivation== | ==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=== | ===Numerator=== | ||
Num = | *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=== | ===Denominator=== | ||
Denom = Number of calendar days | *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=== | ===Formula=== | ||
Average Daily Bed Occupancy = Num / Denom | *Definition1 Average Daily Bed Occupancy = Definition1 Num / Definition1 Denom | ||
*Definition2 Average Daily Occupancy/Number of Beds in %= (Definition2 Num / Definition2 Denom) * 100 | |||
==Data Sources== | ==Data Sources== | ||
[[Admit DtTm]], [[Dispo DtTm]], [[Bed Census]] | |||
==SAS Program== | ==SAS Program== | ||
Latest revision as of 09: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) |
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