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." A 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