DEHCR HOME ARP Report

Background

This report is submitted to DEHCR on a quarterly basis for HOME-ARP Supportive Services programs. It can be generated by any user with a Looker license and reviewed for data quality and completeness.

Instructions

Step 1: Click on the Launchpad Icon, and select the Reports icon.

**Step 2: Once on the Reports main page navigate to the Data Analysis tab**

Then click the down arrow next to the DASHGreatLakes folder to expand the section. Scroll down until you see the DEHCR heading and click "RUN" on the DEHCR HOME ARP Report.

Step 3: Select First Set of Prompts & Run the Report

Reporting Period Filter
- Select the reporting period filter start and end dates. For Looker reports, the reporting period end date is always "+1 day". Ex: for a reporting period of 1/1/2025 through 3/31/2025, select a report start date of 1/1/2025 and a report end date of 4/1/2025.
CLS Information Date
- This will be the same as the "Reporting Period Filter", but "+1 day" for the start date. In this example, the prompt is set to "is from 01/02/2025 until 04/01/2025".
Status Update Added Date (On or Before Report Start) and CLS Information Date (On or Before Report Start)
- Set both of these filters to "is before" the Reporting Period Start Date "+1 day". In this example, the prompt is set to "is before 01/02/2025"
Non Federal Funding Source
- Leave as "is DEHCR HOME ARP"
Program Name
- Select your agency's Program Name
Head of Household (Yes / No)
- Leave as "is Yes"
Client ID (Homeless Households)
- Leave as "is any value" to start
Client ID (Non-Homeless Households)
- Leave as "is any value" to start

Once all prompts have been correctly updated, click the "Update" button to generate the report. This is what the prompts should look like: Step 4: Update the Prompts and Refresh the Report

Copy the list of Client IDs from the "Homeless Households (McKinney-Vento) List" tile and paste them into the "Client ID (Homeless Households)" filter.
Copy the list of Client IDs from the "Non-Homeless Households (Homeless Prevention) List" and paste them into the "Client ID (Non-Homeless Households)" filter.
Click "Update" to refresh the report.

Step 5: Review the Report for Missing Information

Pay particular attention to the "Details Table". Clients should have a Current Living Situation (CLS) assessment documented at project entry, and for each month they remain in the program. Clients who have had 0 CLS assessments documented during the reporting period will be flagged in this table, indicating that a CLS assessment needs to be added to their enrollment during the reporting period.