Dashboard Library
      Back to home
      1. Clarity Human Services Help Center
      2. Data Analysis
      3. Dashboard Library

      Data Quality Supplemental Dashboard

      Purpose 

      The Data Quality Supplemental LookML dashboard utilizes the Data Quality report section of the HUD HMIS Reporting Glossary and HUD HMIS Data Dictionary Data Elements as focal points to review data completion and data quality. This dashboard contains information to help maintain and obtain data quality with an emphasis on the HMIS Data Dictionary Universal Data Elements and some Program Specific Data Elements.  The dashboard in some instances performs checks above and beyond the requirements of the HUD HMIS Reporting Glossary. These differences are noted in the details for each applicable Look listed below.

      The dashboard content is broken down into seven sections – Q2 Personally Identifiable Information (PII), Q3 Universal Data Elements, Q4 Income and Housing Data Quality, Q5 Chronically Homeless (ES SH SO), Q5 Chronically Homeless (TH), Q5 Chronically Homeless (PH), Q5 Chronically Homeless (CE), Q5 Chronically Homeless (SSO DS HP) and Q6 Timeliness – containing 20 Looks.  

      The Data Quality Supplemental Dashboard checks all enrollments during the reporting period versus focusing on the latest enrollment as noted in the HMIS Reporting Glossary. This ensures all enrollments are checked for potential data quality issues.

      Dashboard Filters 

      There are six filters on this dashboard to limit data by Reporting Period, CoC, Project Type, Agency Name, Program Name, and Assigned Staff. The table below outlines what Looks the filters apply to and the default values.  

      Reporting Period  

      Default: is in the last 1 quarter 

      Applies to all Looks

      CoC Code 

      Default: is any value

      Applies to all Looks 

      Selection impacts filter options for Agency Name and Program Name 

      Project Type Code 

      Default: is any value 

      Applies to all Looks 

      Selection impacts filter options for Program Name 

      Agency Name 

      Default: is any value 

      Applies to all Looks 

      Selection impacts filter options for Program Name and Assigned Staff

      Program Name 

      Default: is any value 

      Applies to all Looks 

      Assigned Staff 

      Default: is any value 

      Applies to all Looks 

      Content 

      The following Looks make up the Data Quality LookML dashboard. For more information on how each Look is configured, what fields are used, or custom fields, please review the Look by selecting ‘Explore from Here’ within the ellipses in the upper right corner.  

      Q2 Personally Identifiable Information (PII) 

      Social Security Number

      This section of the Look contains issue counts for the "3.02 Social Security Number and SSN Data Quality" Universal Data Elements and the count of unduplicated clients potentially impacted by these UDE errors.  

      Date of Birth

      This section of the Look contains issue counts for the "3.03 Date of Birth and Date of Birth Data Quality" Universal Data Elements and the count of unduplicated clients potentially impacted by these UDE errors.  

      Race & Ethnicity

      This section of the Look contains issue counts for the "3.04 Race & Ethnicity" Universal Data Element and the count of unduplicated clients potentially impacted by these UDE errors.  

      Gender

      This section of the Look contains issue counts for the "3.06 Gender" Universal Data Element and the count of unduplicated clients potentially impacted by these UDE errors.  

      Q2  Client Detail

      This Look contains a detailed list of the enrollments with Q2 data quality issues.  Please note that if a client has no Q2 data quality issues they will not appear in the detail table.  Issues are broken out into the below categories where applicable for each data element:

      • "None" - no data quality issues for this data element.
      • "Missing" - data element not answered or has a picklist value indicating it is missing per HUD Reporting Glossary.
      • "DKPNTA" - data element answered as either "Don't know" or "Client prefers not to answer"
      • "Data Issues" - data element has one or more data quality issues as noted per the HUD Reporting Glossary.

      Q3 Universal Data Elements 

      Veteran Status

      This section of the Look contains issue counts for the "3.07 Veteran Status" Universal Data Element and the count of unduplicated clients potentially impacted by these UDE errors.  

      Disabling Condition

      This section of the Look contains issue counts for the "3.08 Disabling Condition" Universal Data Element and the following Program Data Elements: "4.05 Physical Disability", "4.06 Developmental Disability", "4.07 Chronic Health Condition", "4.08 HIV/AIDS", "4.09 Mental Health Disorder", and "4.10 Substance Use Disorder", along with the count of unduplicated clients potentially impacted by these UDE errors.   

      Beyond the HUD Reporting Glossary, this section checks for instances where the "3.08 Disabling Condition" Universal Data Element is answered "Yes" and all of the associated Program Data Elements are either "No" or all left blank.

      Enrollment CoC

      This section of the Look contains issue counts for the "3.16 Enrollment CoC" Universal Data Element and the count of unduplicated heads of household potentially impacted by these UDE errors.  

      Relationship to HoH

      This section of the Look contains issue counts for the "3.15 Relationship to Head of Household" Universal Data Element and the count of unduplicated clients potentially impacted by these UDE errors.  

      Q3 Client Detail

      This Look contains a detailed list of the enrollments with Q3 data quality issues.  Please note that if a client has no Q3 data quality issues they will not appear in the detail table.  Issues are broken out into the below categories where applicable for each data element:

      • "None" - no data quality issues for this data element.
      • "Missing" - data element not answered or has a picklist value indicating it is missing per HUD Reporting Glossary.
      • "DKPNTA" - data element answered as either "Don't know" or "Client prefers not to answer"
      • "Data Issues" - data element has one or more data quality issues as noted per the HUD Reporting Glossary.

      Q4 Income and Housing Data Quality

      Destination

      This section of the Look contains issue counts for the 3.12 Destination Universal Data Element and the count of unduplicated leavers potentially impacted by this Universal Data Element and some Program Data Element errors.  

      Income and Sources at Start

      This section of the Look contains issue counts for the "4.02 Income and Sources" as of Project Start Date Program Data Elements and the count of unduplicated adults and heads of household potentially impacted by these errors. 

      Beyond the HUD Reporting Glossary, this section checks for issues where the "Income from Any Source" data element is answered "No" and any of the individual income sources are answered "Yes". It also checks for issues where the "Income from Any Source" data element is answered "Yes" and all of the individual income sources are answered "No".

      Income and Sources at Annual Assessment

      This section of the Look contains issue counts for the "4.02 Income and Sources" as of Annual Assessment Program Data Elements and the count of unduplicated adults and heads of household potentially impacted by these errors. 

      Beyond the HUD Reporting Glossary, this section checks for issues where the "Income from Any Source" data element is answered "No" and any of the individual income sources are answered "Yes". It also checks for issues where the "Income from Any Source" data element is answered "Yes" and all of the individual income sources are answered "No".

      Income and Sources at Exit

      This section of the Look contains issue counts for the "4.02 Income and Sources" as of Project Exit Date Program Data Elements and the count of unduplicated adults and heads of household potentially impacted by these errors.  

      Beyond the HUD Reporting Glossary, this section checks for issues where the "Income from Any Source" data element is answered "No" and any of the individual income sources are answered "Yes". It also checks for issues where the "Income from Any Source" data element is answered "Yes" and all of the individual income sources are answered "No".

      Q4 Client Detail

      This Look contains a detailed list of the enrollments with Q4 data quality issues.  Please note that if a client has no Q4 data quality issues they will not appear in the detail table.  Issues are broken out into the below categories where applicable for each data element:

      • "None" - no data quality issues for this data element.
      • "Missing" - data element not answered or has a picklist value indicating it is missing per HUD Reporting Glossary.
      • "DKPNTA" - data element answered as either "Don't know" or "Client prefers not to answer"
      • "Data Issues" - data element has one or more data quality issues as noted per the HUD Reporting Glossary.

      Q5 Chronically Homeless (ES-EE, ES-NbN, SH, SO)

      This pair of Looks focus on the Emergency Shelter - Entry Exit, Emergency Shelter - Night-by-Night, Safe Haven, and Street Outreach project types and the collection of the data elements associated with checking chronically homeless status as of the project start date.

      Approximate Date Started 

      This section of the Look contains issue counts for the "3.917 Approximate date this episode of homelessness started" Universal Data Element and the count of unduplicated clients potentially impacted by these UDE errors.  

      Number of Times

      This section of the Look contains issue counts for the "3.917 Regardless of where they stayed last night, number of times the client has been on the streets, in ES, or SH in the past three years including today" Universal Data Element and the count of unduplicated clients potentially impacted by these UDE errors.   

      Number of Months

      This section of the Look contains issue counts for the "3.917 Total number of months homeless on the street, in ES, or SH in the past three years" Universal Data Element and the count of unduplicated clients potentially impacted by these UDE errors.  

      Q5 ESSHSO Client Detail

      This Look contains a detailed list of the enrollments with Q5 data quality issues.  Please note that if a client has no Q5 data quality issues they will not appear in the detail table.  Issues are broken out into the below categories where applicable for each data element:

      • "None" - no data quality issues for this data element.
      • "Missing" - data element is not answered or has a picklist value indicating it is missing per HUD Reporting Glossary.
      • "DKPNTA" - data element is answered as either "Don't know" or "Client prefers not to answer"
      • "Data Issues" - data element has one or more data quality issues as noted per the HUD Reporting Glossary.

      Q5 Chronically Homeless (TH)

      This pair of Looks focus on the Transitional Housing project type and the collection of the data elements associated with checking chronically homeless status as of the project start date.

      Time in Institution

      This section of the Look contains issue counts for the "3.917 Did you stay less than 90 days? (Institutional Situations)" Universal Data Element and the count of unduplicated clients potentially impacted by these UDE errors.  

      Time in Housing

      This section of the Look contains issue counts for the "3.917 Did you stay less than 7 nights? (Temporary, Permanent and Other Situations)" Universal Data Element and the count of unduplicated clients potentially impacted by these UDE errors.   

      Approximate Date Started 

      This section of the Look contains issue counts for the "3.917 Approximate date this episode of homelessness started" Universal Data Element and the count of unduplicated clients potentially impacted by these UDE errors.  

      Number of Times

      This section of the Look contains issue counts for the "3.917 Regardless of where they stayed last night, number of times the client has been on the streets, in ES, or SH in the past three years including today" Universal Data Element and the count of unduplicated clients potentially impacted by these UDE errors.   

      Number of Months

      This section of the Look contains issue counts for the "3.917 Total number of months homeless on the street, in ES, or SH in the past three years" Universal Data Element and the count of unduplicated clients potentially impacted by these UDE errors.  

      Q5 TH Client Detail

      This Look contains a detailed list of the enrollments with Q5 data quality issues.  Please note that if a client has no Q5 data quality issues they will not appear in the detail table.  Issues are broken out into the below categories where applicable for each data element:

      • "None" - no data quality issues for this data element.
      • "Missing" - data element is not answered or has a picklist value indicating it is missing per HUD Reporting Glossary.
      • "DKPNTA" - data element is answered as either "Don't know" or "Client prefers not to answer"
      • "Data Issues" - data element has one or more data quality issues as noted per the HUD Reporting Glossary.

      Q5 Chronically Homeless (PH)

      This pair of Looks focus on the PH - Rapid Re-Housing, PH - Housing Only, PH - Permanent Supportive Housing (disability required for entry), and PH - Housing with Services (no disability required for entry) project types and the collection of the data elements associated with checking chronically homeless status as of project start date.

      Time in Institution

      This section of the Look contains issue counts for the "3.917 Did you stay less than 90 days? (Institutional Situations)" Universal Data Element and the count of unduplicated clients potentially impacted by these UDE errors.  

      Time in Housing

      This section of the Look contains issue counts for the "3.917 Did you stay less than 7 nights? (Temporary, Permanent and Other Situations)" Universal Data Element and the count of unduplicated clients potentially impacted by these UDE errors.   

      Approximate Date Started 

      This section of the Look contains issue counts for the "3.917 Approximate date this episode of homelessness started" Universal Data Element and the count of unduplicated clients potentially impacted by these UDE errors.  

      Number of Times

      This section of the Look contains issue counts for the "3.917 Regardless of where they stayed last night, number of times the client has been on the streets, in ES, or SH in the past three years including today" Universal Data Element and the count of unduplicated clients potentially impacted by these UDE errors.   

      Number of Months

      This section of the Look contains issue counts for the "3.917 Total number of months homeless on the street, in ES, or SH in the past three years" Universal Data Element and the count of unduplicated clients potentially impacted by these UDE errors.  

      Q5 PH Client Detail

      This Look contains a detailed list of the enrollments with Q5 data quality issues.  Please note that if a client has no Q5 data quality issues they will not appear in the detail table.  Issues are broken out into the below categories where applicable for each data element:

      • "None" - no data quality issues for this data element.
      • "Missing" - data element is not answered or has a picklist value indicating it is missing per HUD Reporting Glossary.
      • "DKPNTA" - data element is answered as either "Don't know" or "Client prefers not to answer"
      • "Data Issues" - data element has one or more data quality issues as noted per the HUD Reporting Glossary.

      Q5 Chronically Homeless (CE)

      This pair of Looks focus on the Coordinated Entry project type and the collection of the data elements associated with checking chronically homeless status as of the project start date.

      Time in Institution

      This section of the Look contains issue counts for the "3.917 Did you stay less than 90 days? (Institutional Situations)" Universal Data Element and the count of unduplicated clients potentially impacted by these UDE errors.  

      Time in Housing

      This section of the Look contains issue counts for the "3.917 Did you stay less than 7 nights? (Temporary, Permanent and Other Situations)" Universal Data Element and the count of unduplicated clients potentially impacted by these UDE errors.   

      Approximate Date Started 

      This section of the Look contains issue counts for the "3.917 Approximate date this episode of homelessness started" Universal Data Element and the count of unduplicated clients potentially impacted by these UDE errors.  

      Number of Times

      This section of the Look contains issue counts for the "3.917 Regardless of where they stayed last night, number of times the client has been on the streets, in ES, or SH in the past three years including today" Universal Data Element and the count of unduplicated clients potentially impacted by these UDE errors.   

      Number of Months

      This section of the Look contains issue counts for the "3.917 Total number of months homeless on the street, in ES, or SH in the past three years" Universal Data Element and the count of unduplicated clients potentially impacted by these UDE errors.  

      Q5 CE Client Detail

      This Look contains a detailed list of the enrollments with Q5 data quality issues.  Please note that if a client has no Q5 data quality issues they will not appear in the detail table.  Issues are broken out into the below categories where applicable for each data element:

      • "None" - no data quality issues for this data element.
      • "Missing" - data element is not answered or has a picklist value indicating it is missing per HUD Reporting Glossary.
      • "DKPNTA" - data element is answered as either "Don't know" or "Client prefers not to answer"
      • "Data Issues" - data element has one or more data quality issues as noted per the HUD Reporting Glossary.

      Q5 Chronically Homeless (SSO DS HP)

      This pair of Looks focuses on the Supportive Services Only, Day Shelter, and Homelessness Prevention project types and the collection of the data elements associated with checking chronically homeless status as of the project start date.

      Time in Institution

      This section of the Look contains issue counts for the "3.917 Did you stay less than 90 days? (Institutional Situations)" Universal Data Element and the count of unduplicated clients potentially impacted by these UDE errors.  

      Time in Housing

      This section of the Look contains issue counts for the "3.917 Did you stay less than 7 nights? (Temporary, Permanent and Other Situations)" Universal Data Element and the count of unduplicated clients potentially impacted by these UDE errors.   

      Approximate Date Started 

      This section of the Look contains issue counts for the "3.917 Approximate date this episode of homelessness started" Universal Data Element and the count of unduplicated clients potentially impacted by these UDE errors.  

      Number of Times

      This section of the Look contains issue counts for the "3.917 Regardless of where they stayed last night, number of times the client has been on the streets, in ES, or SH in the past three years including today" Universal Data Element and the count of unduplicated clients potentially impacted by these UDE errors.   

      Number of Months

      This section of the Look contains issue counts for the "3.917 Total number of months homeless on the street, in ES, or SH in the past three years" Universal Data Element and the count of unduplicated clients potentially impacted by these UDE errors.  

      Q5 SSODSHP Client Detail

      This Look contains a detailed list of the enrollments with Q5 data quality issues.  Please note that if a client has no Q5 data quality issues they will not appear in the detail table.  Issues are broken out into the below categories where applicable for each data element:

      • "None" - no data quality issues for this data element.
      • "Missing" - data element is not answered or has a picklist value indicating it is missing per HUD Reporting Glossary.
      • "DKPNTA" - data element is answered as either "Don't know" or "Client prefers not to answer"
      • "Data Issues" - data element has one or more data quality issues as noted per the HUD Reporting Glossary.

      Q6 Data Entry Timeliness 

      Q6 Data Entry Timeliness 

      This Look contains the count and percent of project start records and project exit records that fall within various day range tiers based on the Q6 Timeliness table in the HMIS Data Quality Report section of the HUD Reporting Glossary.  

      Q6 Timeliness Client Detail 

      This Look contains a detailed list of the enrollments counted in Q6 Data Entry Timeliness Look. "Time for Record" matches the same "Time for Record" column in the Q6 Data Entry Timeliness Look. "Data Entry Timeliness" shows the exact number of days between when the record was created and the date selected for the project start records and project exit records that fall within the selected analysis period.

       

      Updated: 11/27/2023