Location Utilization Scorecard

Review 3 months of OR location utilization to better understand your staffing needs.


Sample PDF Report (click to download)


Filter Default Setting Action Applied Tiles
Is Voided is = No Removes all voided cases All
Is Test Facility is = No Removes all cases from Test Facility All
Is Anes Case is = Yes Includes only Anes case forms (ie. excludes OOR forms) All
Is OB Case is any value Includes OB and non-OB case types All
M1_Date of Service is in range [2020-04-01] until (before) [2020-05-01] Includes all cases with date of service in April. Q30 Min Utilization (M1)
M2_Date of Service is in range [2020-05-01] until (before) [2020-06-01] Includes all cases with date of service in May. Q30 Min Utilization (M2)
M3_Date of Service is in range [2020-06-01] until (before) [2020-07-01] Includes all cases with date of service in June. Q30 Min Utilization (M3)
Is Day of Week matches (advanced) -Saturday,-Sunday Removes any cases performed on a weekend day. Q30 Min Utilization (M1, M2, and M3), Max Locations per Hour of Day, Frequency of Max Locations per Month
Qtr_Date of Service is in range [2020-04-01] until (before) [2020-07-01] Includes all cases with date of service in April, May, or June Max Locations per Hour of Day and Frequency of Max Locations per Month
Max Location in Use is not equal to [0] Excludes any max location use of “0” Frequency of Max Locations per Month
Date of Service is in the past = 1 month Shows all cases in current month  
Facility is equal to [blank] Includes all Facilities (except Test Facility) Q30 Min Utilization (M1, M2, and M3), Max Locations per Hour of Day, Frequency of Max Locations per Month
Anes Provider is equal to [blank] Includes all Anes Providers All
Surgeon is equal to [blank] Includes all Surgeons All

 

Q30 Min Utilization (M1)

  • Description: Heat map showing number of OR locations in use for every 30 minute block of every day of month defined in filter for “M1” (Month 1). It is important to set the date range for M1 filter as follows:
    • Start date = First day of month desired
    • Finish date = First day of following month
    • For example to view September, date range for M1 would be 09/01/2020 - 10/01/2020.

Q30 Min Utilization (M2)

  • Description: Heat map showing number of OR locations in use for every 30 minute block of every day of month defined in filter for “M2” (Month 2). It is important to set the date range for M2 filter as follows:
    • Start date = First day of month desired
    • Finish date = First day of following month
    • For example to view September, date range for M2 would be 09/01/2020 - 10/01/2020.

Q30 Min Utilization (M3)

  • Description: Heat map showing number of OR locations in use for every 30 minute block of every day of month defined in filter for “M3” (Month 3). It is important to set the date range for M3 filter as follows:
    • Start date = First day of month desired
    • Finish date = First day of following month
    • For example to view September, date range for M3 would be 09/01/2020 - 10/01/2020.

Max Locations per Hour of Day

  • Description: Visualizes the maximum number of locations used at any given 30-minute block of time for a given month. Three lines are simultaneous shown, representing the maximum locations for a given 30-minute time block for M1, M2, and M3.
  • Purpose: Allows you to better determine BOTH actual maximum resource demand AND when it occurs. For example, max resource demand may be 6 locations for any 30-minute time block for a given month or quarter, but it never occurs after 12:00pm.

Max Locations per Hour of Day

  • Description: Visualizes the frequency of max locations used for all 30-minute time blocks for every day for the given month. Up to 3 bar graphs will be shown for each maximum location used represented on the x-axis.
  • Purpose: Allows you to better determine how frequently maximum resources are actually being used. It does not show what time of day they are needed, but does show you may only be in a “worse case” scenario much less (or more) frequently per quarter than perceived.