HUD reports are increasingly relying on [Client Location of Head of Household] for CoC-wide reporting. Specifically this is required for:
- System Performance Measures (SPM)
- Longitudinal System Analysis (LSA) (formerly AHAR)
The following are steps for developing a suggested Look for identifying Enrollments with CoC issues.
- Explore - HMIS Performance model
- Add the following fields to the Look:
- Personal ID (Clients folder)
- Enrollment ID (Enrollments)
- CoC Code of Client at Project Start
- CoC Code of Client's HoH at Project Start
- Change the Reporting Period Filter to the report date range
- Change from "is in past" to "is in range"
- Enter the [report start date] until (before) [report end date] +1
- Adding 1 to the [report end date] includes the last day of the reporting period in the results
- Adding 1 to the [report end date] includes the last day of the reporting period in the results
- Add additional filters as needed to meet your needs:
- CoC Code of Client's HoH at Project Start
- CoC Code of Client at Project Start
- Agency Name
- Program Name
- etc.
The following shows an excerpt of the Look and highlights a potential problem:
If you were running a report for CoC CA-612, the highlighted enrollment, including all members of the household, would not be included in the results of a SPM or LSA report. Why? Because the Head of Household has a NULL CoC Code.
To link to the enrollment, click on the "..." next to Enrollment ID.
Then choose "Clarity Program Enrollment." An new window will open taking you to the enrollment. Make the necessary corrections.
Advanced Option
A table calculation can be added to the Look to highlight enrollments where the Client CoC and HoH CoC are not equal. Here are the steps:
- Click on "Calculations"
- Give the calculation a name (default is Calculation 1)
- Copy and paste the following into the calculation area:
if(${entry_screen.client_location}=${hoh_client_location.hoh_client_location},"Match","Different")
- "Save Table Calculations"
- The calculation will be added as the right-most column
- Sort by the table calculation