Bed occupancy

• Is this per ward? hospital? Ttenbergen 15:02, 2013 December 23 (CST)
  • • We can make it per day per ward per hospital for now and sum up in any combinations in another queries later.
  • Defines as the total number of beds being occupied by patients in a given calendar day.
    • Decimal fractions for part-days? Ttenbergen 22:45, 2014 January 15 (CST)Template:Discussion
• The basic data for bed occupancy is per day per patient of each ward/ICU and can be sum up in any combination by day/month/quarter/year x Ward/Unit x Hospital. Yes, decimal fractions for partial days.

Is this related to Bed census.mdb?

• Occupancy for beds census is a one time observation each day at 1400 hrs.
• Ed occupancy program can pick any time of day and them summaries

Which reports use this?

• quarterly and Fiscal Year
• for Grace ICU, monthly

Occupancy Calculation

• Formula 1 - 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 disch time - 001
  • Bed Occupancy per day = sum of bed occupied by all patients in a given day
    • This formula is used in quarter/FY reports
• Formula 2 - Get the maximum bed census and minimum bed census per day
  • Bed occupancy per day = (Minimum + Maximum)/2
  • This formula is used in CVVSM.
• Formula 3 - Get 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.
  • Bed Occupancy per day at ##Hour = number of patients occupying a bed at ##Hour.
  • This formula is used in QI Team (Total Patient Days at 2300 HR) and in GRA ICU monthly reports

• • • In TMSX and MED TMS, they can calculate bed occupancy at various hour of the day (0 to 23 HR). I think he is using both Formula 1 and 3. I never asked Ed how he does his calculations. I asked the users of the data. I am using Ed's to crosscheck my numbers and we match.