Bed Turnover Rate Report

Bed Turnover Rate is the rate at which beds are made available for a given project. While typically used in hospital settings, Bed Turnover Rate can also be used by providers and agencies to evaluate the speed and efficiency with which clients receive services.

Bed Turnover Rate is calculated as the number of exits divided by the bed inventory, then multiplied by 100 to be expressed as a percentage. The number of exits is calculated as the number of clients who have an exit date, and for housing projects, who also have a valid housing-move-in date. Bed inventory is calculated as the total number of beds in a project multiplied by the total number of days in the reporting period.

A higher turnover rate can indicate that beds, and by extension services, are being used efficiently. The types of services provided can also influence turnover rate. For example, a Permanent Supportive Housing project will likely have a lower turnover rate than an Emergency Shelter.

This report can be run by all project types except for Night-by-Night projects.

Running the Report

Report Path

Folders
> Public Folder
    > missouri_live_folder
      > Outcomes
        > Bed Turnover Rate Report

Recommended Export Format

Schedule to Microsoft Excel - Reports

Setting the Prompts

Prompt	Instructions
Select Provider(s):	Select the project(s) for which you wish to run the report.
Select Reporting Group(s):	Select the reporting group or which you wish to run the report.
Select CoC(s):	This prompt is for use by ICA System Administrators only. Leave set to "none selected".
EDA Provider	If only one project is selected in the "Enter value(s) for Provider:" prompt above, select the same project here. If more than one project is selected in the "Enter value(s) for Provider:" prompt, then select one of the projects.
Enter effective date	Enter the date after the last date of the reporting period in M/d/yyyy format. For example, if you're running a report for 7/1/2023-6/30/2024, the date entered in this box would be 7/1/2024.
Enter Start Date:	Enter the start date for the reporting period in m/d/yyyy format. For example, if you're running a report for 7/1/2023-6/30/2024, the date entered in this box would be 7/1/2023.
Enter End Date PLUS 1 Day:	Enter the date after the last date of the reporting period in m/d/yyyy format. For example, if you're running a report for 7/1/2024-6/30/2025, the date entered in this box would be 7/1/2025.
Show client names?	Select "Yes" if cient names should be displayed in the report, and "No" if the client names should be hidden in the report. Important! If you include client names when you run this report, then the report cannot be emailed (even within agencies) unless encrypted, nor can it be shared outside of the agency.

Using the Report

This report has four tabs, each serving a specific purpose.

Important! Because the report contains identifying information (names), the report cannot be emailed (even within agencies) unless encrypted, nor can it be shared outside of the agency.

Summary

This tab contains a summary table listing all the projects with active beds during the reporting periods, the number of clients entering and exiting those projects, the average length of stay in the project, the bed inventory, and the bed turnover rate for each project.

This tab also contains a table with the bed turnover rate for each project type, and, if a reporting group and/or CoC is selected, a separate table with the turnover rate for each reporting group and/or CoC will be visible.

Entering Clients

This tab shows demographic and enrollment information for clients who entered the selected projects during the reporting period. Enrollment information includes the date the clients entered and exited the projects, the housing move-in date (if applicable), and the number of bed nights they stayed in the project.

Exiting Clients

This tab shows demographic and enrollment information for clients who exited the selected projects during the reporting period. Enrollment information includes the date the clients entered and exited the projects, the housing move-in date (if applicable), and the number of bed nights they stayed in the project.

Additional Information

This tab contains information about what was selected for the prompts and what information was pulled into the report by the reporting tool. This tab is utilized by ICA for troubleshooting purposes in the event a user contacts the helpdesk seeking assistance with the report.

Need Assistance?

If you need assistance running the report, understanding the information in the report, or troubleshooting potential errors, please reach out to the ICA Missouri Helpdesk. Include the name and date of the BusinessObjects report as it appears in your BI Inbox in your request for assistance. Do not attach the report to any emails going to the helpdesk as the report contains personally identifying information and cannot be transmitted unless encrypted.