Table of Contents
Purpose
The LSA Data Cleanup: Household and Enrollment Data dashboard is designed to aid in federal reporting season preparation, submission, and follow-up. This dashboard enables users to review common issues with household and enrollment data for data quality clean up initiatives and general review.
Dashboard Access
Dashboards are available to all instances with Data Analysis enabled. This dashboard is a LookML Dashboard. How you access it depends on whether you use standalone or embedded Looker and your access rights. In either case, you must have Data Analysis enabled in your access role at a minimum. See Rights Glossary for Access Roles for information about Data Analysis access rights.
Note: For accurate systemwide results, the user running the report must have an access role that includes the Systemwide Data Analysis access right.
Standalone Looker
This dashboard is accessible in Looker by utilizing the following pathway:
- "All Folders"
- "LookML Dashboards"
- "[Dashboard Name]"
- "LookML Dashboards"
Once selected, the dashboard will begin to run. The utilized models are dashboard-dependent.
Embedded Looker
LookML Dashboards accessed through embedded Looker must first be enabled for the instance in standalone Looker, then toggled on in the Data Analysis settings before they're available in the Built In Reports folder in the Data Analysis tab in the Report Library.
For steps to enable and access these reports, see the Embedded Looker: Looker - Clarity Human Services Integration article.
Dashboard Filters
There are seven filters on this dashboard to filter data for reporting needs and targeted analysis. The table below outlines which Looks the filters apply to and the default values.
|
Analysis Period Default: 10/01/2025 – 10/01/2026 |
This filter applies to all Looks. |
|
Overlapped Program CoC Default: is any value |
This filter applies to all Looks.
Selection impacts filter options for Agency Name and Program Name. |
|
Overlapped Agency Name |
|
|
Overlapped Program Name |
|
|
Overlapped Project Type |
|
|
Overlapping Enrollment CoC Default: is any value |
This filter applies to all Looks.
Selection impacts filter options for Program Name. |
|
Overlapping Agency Name Default: is any value |
This filter applies to all Looks. |
|
Overlapping Program Name Default: · Emergency Shelter – Entry Exit · Emergency Shelter – Night-by-Night · Transitional Housing · PH – Permanent Supportive Housing (disability required for entry) · Safe Haven · PH – Housing Only* · PH – Housing with Services (no disability required for entry)* · PH – Rapid Re-Housing *OPH enrollment data is only included for canned LSA reporting when the ‘HIC’ Scope is selected per programming specifications. |
This filter applies to all Looks.
Selection impacts filter options for Program Name. |
|
Overlapping Project Type Default: Yes |
This filter applies to all Looks. |
|
Analysis Period Default: 10/01/2023 – 10/01/2024 |
This filter applies to all Looks. |
|
Overlapped Program CoC Default: is any value |
This filter applies to all Looks.
Selection impacts filter options for Agency Name and Program Name. |
|
Overlapped Agency Name |
|
|
Overlapped Program Name |
|
|
Overlapped Project Type |
|
|
Overlapping Enrollment CoC Default: is any value |
This filter applies to all Looks.
Selection impacts filter options for Program Name. |
|
Overlapping Agency Name Default: is any value |
This filter applies to all Looks. |
|
Overlapping Program Name Default: · Emergency Shelter – Entry Exit · Emergency Shelter – Night-by-Night · Transitional Housing · PH – Permanent Supportive Housing (disability required for entry) · Safe Haven · PH – Housing Only* · PH – Housing with Services (no disability required for entry)* · PH – Rapid Re-Housing *OPH enrollment data is only included for canned LSA reporting when the ‘HIC’ Scope is selected per programming specifications. |
This filter applies to all Looks.
Selection impacts filter options for Program Name. |
|
Overlapping Project Type Default: Yes |
This filter applies to all Looks. |
|
Analysis Period Default: 10/01/2023 – 10/01/2024 |
This filter applies to all Looks. |
|
Program CoC Default: is any value |
This filter applies to all Looks.
Selection impacts filter options for Agency Name and Program Name. |
|
Agency Name Default: is any value |
This filter applies to all Looks.
Selection impacts filter options for Program Name. |
|
Program Name Default: is any value |
This filter applies to all Looks. |
|
Project Type Default: · Emergency Shelter – Entry Exit · Emergency Shelter – Night-by-Night · Transitional Housing · PH – Permanent Supportive Housing (disability required for entry) · Safe Haven · PH – Housing Only* · PH – Housing with Services (no disability required for entry)* · PH – Rapid Re-Housing *OPH enrollment data is only included for canned LSA reporting when the ‘HIC’ Scope is selected per programming specifications. |
This filter applies to all Looks.
Selection impacts filter options for Program Name. |
|
Continuum Project Default: Yes |
This filter applies to all Looks. |
|
Victim Service Provider Default: No |
This filter applies to all Looks. |
Content
The following Looks make up the LSA Data Cleanup: Household and Enrollment Data dashboard. The overview below is broken down into sections within the dashboard and includes a summary of the Looks’ content. For more information on how a Look is configured and what fields/custom fields are used, please review the Look by selecting the ‘Explore from Here’ icon or within the ‘Tile Actions’ menu (three-dot icon) in the upper right corner.
A.Household Data Issues
i) Program Enrollment Household with No Head of Household
This Look contains a list of enrollment households active within the reporting period with no Head of Household.
ii) Heads of Households Less Than 6 Yrs Old at Project Start/Reporting Period Start
This Look contains a list of clients that are identified as the enrollment Head of Household and are under the age of 6. Age calculations utilize date of birth and the more recent of Project Start Date and Reporting Period Start Date to align with HUD Age as defined in the HMIS Reporting Glossary. Within the table, enrollment household and profile household information is included to identify potential data quality clean-up opportunities.
iii) Clients with Missing Date of Birth
This Look contains a list of clients with a blank/null/missing Date of Birth, Date of Birth Data Quality, and enrollment information.
Enrollment Data Issues
i) Clients Born After their Enrollment Start Date
This Look contains a list of clients that have a Date of Birth after their enrollment start date. If the client is a newborn, HUD Guidance as outlined in the HMIS Data Standards Manual advises that the Project Start Date should ‘reflect the date the project started providing housing or services to the newborn’.
ii) Heads of Household with Move-in Dates Outside of Enrollment
This Look identifies Heads of Household with Housing Move-in Dates outside of the enrollment. For more information on Housing Move-in Date guidance, please review the HMIS Data Standards.
iii) Enrollments with a Retired Prior Living Situation, Current Living Situation, or Exit Destination
This Look identifies enrollments that have an invalid living situation within the 3.917 Prior Living Situation, Current Living Situation, or Exit Destination. Valid Living Situations are outlined in Appendix A within the HMIS Data Dictionary and should be updated to ensure alignment.
iv) Enrollments with an Invalid Enrollment CoC
This Look identifies enrollments with a HoH’s Enrollment CoC that do not align with the CoCs selected within the Program Setup, or are null/blank.
Additional Resources
For additional support with federal reporting data cleanup, refer to the following LookML dashboard article:
Updated: 10/09/2026