Sample Looks

HMIS Performance: Client Location of Heads of Household

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.

  1. Explore - HMIS Performance model
  2. 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
  3. 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
  4. 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:


  • "Save Table Calculations"
  • The calculation will be added as the right-most column
  • Sort by the table calculation