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
- If you are running the report for the most recent completed quarter, select "is in the last 1 complete quarters".
- If you are running the report for a different reporting period, select "is in range" and enter the appropriate start and end dates.
CLS Information Date
- Set this to match the Reporting Period.
Status Update Added Date (Before Report Start Date) and CLS Information Date (Before Report Start Date)
- Set both of these filters to "is before" the Reporting Period Start Date.
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.

NOTE: If there are 0 client IDs in the "Homeless Households (McKinney-Vento) List" or "Non-Homeless Households (Homeless Prevention) List", you will set the corresponding Client ID filter to "is null".

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.

Related Trainings

DEHCR HOME ARP by Stephanie Van Hulst

Training Date: January 14, 2025
Length of Training: 14 minutes