RRH/Permanent Housing Move-In Dates Report

This report was designed to assist users in reviewing household move-in dates for clients who exited into Rapid Re-Housing and Permanent Housing projects. Additionally, this report identifies data quality issues related to conflicting housing move-in dates between the Head of Household (HoH) and other household members.

Running the Report

Report Path

Folders
> Public Folder
> missouri_live_folder
> Data Quality and Completeness Reports
> RRH/Permanent Housing Move-In Dates

Recommended Export Format

Schedule to Microsoft Excel - Reports

Setting the Prompts

Prompt	Instructions
EDA Provider	If only one project is selected in the "Select Housing Program(s) Name:" prompt, select the same project here. If more than one project is selected in the "Select Housing Program(s) Name:" 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/2020-6/30/2021, the date entered in this box would be 7/1/2021.
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/2020-6/30/2021, the date entered in this box would be 7/1/2020.
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/2020-6/30/2021, the date entered in this box would be 7/1/2021.
Select Housing Program(s) Name:	Select the project(s) for which you wish to run the report.

Using the Report

This report has 3 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 table for each project selected indicating the number of individual clients and households whose days between project entry and move-in fell within 0-30 days, 31-60 days, 61-90 days, 91-120 days, 120+ days, clients and households who are still looking for housing, and clients and households who were exited from the project without moving into housing.

All Household Members tab

This tab shows all members of a household organized below the Head of Household (HoH). Any data quality issues with the Housing Move-In Date will show in red. Keep in mind that:

Housing Move In Dates must match the HoH, regardless of when the household members joined. This means that some household members who joined the household after the Head of Household was housed will have a Housing Move In Date before their Project Start Date.
A client cannot have a Housing Move In Date that is before their Project Start Date (unless they are a household member who joined the household after the Head of Household was housed). This typically happens when a household has been previously housed by another RRH or PSH project, and the Housing Move In Date simply needs to be cleared out at Project Entry when enrolling the client.

HoH Only tab

This tab provides the same information from the "All Household Members" tab but reports only on the HoH in each household.

Additional Information

This tab contains information about the report that can be utilized by ICA staff to determine whether the report was run properly by the user. If you seek assistance with this report from the ICA Missouri Helpdesk, please be prepared to read/send information off of this tab to the individual who assists you.

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.