Release Notes

Data Analysis Release Notes 11/27/2023

 

Release Notes Summary

The changes outlined here will be released to all looker instances on 11/27/2023. There may be changes to this article until the release date. 

We acknowledge this release is on a abbreviated timeline.  We appreciate your understanding as Data Services attempt to keep Looker analytics synchronized with Clarity changes. If there are any concerns, please contact your BFF or Help Desk and we can hold your instance's Looker release back a week.

 

LookML Dashboards

All five LSA Cleanup dashboards had a few minor updates to address additional factors related to the 2024 Data Standard Updates plus the addition of 3 new Looks to identify LSA flags.

Ten retired Dashboards have been removed.

A new Data Quality Supplemental LookML dashboard has been published.

 

Data Quality Model:

Retired Error check fields have been removed.

 

Services Model: 

Updated the dimension “type_provided_text” in the Services view  in the Services model to match the 2024 Data Standards

 

Detailed Notes

LookML Dashboards

All five LSA Cleanup dashboards had a few minor updates to address additional factors related to the 2024 Data Standard Updates plus the addition of 3 new Looks to identify LSA flags. 

Dashboards Impacted:

  • LSA Data Cleanup: Funding Source and Configuration Issues
  • LSA Data Cleanup: Length of Stay and Utilization Overview
  • LSA Data Cleanup: Overlapping Enrollments
  • LSA Data Cleanup: Project Descriptor Data Issues
  • LSA Data Cleanup: Head of Household Data

The following retired LookML Dashboards have been removed.

  • Coordinated Entry Matchmaker and Stakeholder – No Wrong Door
  • Client Summary
  • Ethnicity Outcomes
  • Equity and Distribution
  • PATH Dashboard
  • Program Management
  • Race Outcomes Equity and Distribution
  • Runaway and Homeless Youth Dashboard
  • Reservations Dashboard
  • Street Outreach w/ Field Interactions

A new Data Quality Supplemental LookML dashboard  has been released - 

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.
There is more information on the new dashboard here.

Required Actions: None

 

Data Quality Model:

The following Error and Error Count fields have been removed from the retired group in the "DQ Client Program Specific"  View in the Data Quality Model

  • dq_client_program_demographics.worst_housing_situation_error - "Worst Housing Situation Error"
  • dq_client_program_demographics.worst_housing_situation_error - "Reason Receiving Public HIV / AIDS Medical Assistance Error"
  • dq_client_program_demographics.worst_housing_situation_error_count - "Reason Receiving Public HIV / AIDS Medical Assistance Error Count"
  • dq_client_program_demographics.reason_not_receiving_public_hiv_aids_medical_assistance_error - "Reason Not Receiving Public HIV / AIDS Medical Assistance Error"
  • dq_client_program_demographics.reason_not_receiving_public_hiv_aids_medical_assistance_error_count - "Reason Not Receiving Public HIV / AIDS Medical Assistance Error Count"
  • dq_client_program_demographics.last_permanent_address_city_error - "Last Permanent Address City Error"
  • dq_client_program_demographics.last_permanent_address_city_error_count - "Last Permanent Address City Error Count"
  • dq_client_program_demographics.last_permanent_address_state_error - "Last Permanent Address State Error"
  • dq_client_program_demographics.last_permanent_address_state_error_count - "Last Permanent Address State Error Count"
  •  dq_client_program_demographics.last_permanent_address_street_error - "Last Permanent Address Street Error"
  • dq_client_program_demographics.last_permanent_address_street_error_count - "Last Permanent Address Street Error Count"
  • dq_client_program_demographics.last_permanent_address_zip_error - "Last Permanent Address ZIP Code Error"
  • dq_client_program_demographics.last_permanent_address_zip_error_count - "Last Permanent Address ZIP Code Error Count"
  • dq_client_program_demographics.ssvf_hp_targeting_criteria_annual_household_gross_income_amount_error - "SSVF HP Targeting Criteria - Annual household gross income amount Error"
  • dq_client_program_demographics.ssvf_hp_targeting_criteria_annual_household_gross_income_amount_error_count - "SSVF HP Targeting Criteria - Annual household gross income amount Error Count"
  • dq_client_program_demographics.ssvf_hp_targeting_criteria_any_veteran_in_household_served_in_iraq_or_afghanistan_error - "SSVF HP Targeting Criteria - Any Veteran in household served in Iraq or Afghanistan Error"
  • dq_client_program_demographics.ssvf_hp_targeting_criteria_any_veteran_in_household_served_in_iraq_or_afghanistan_error_count - "SSVF HP Targeting Criteria - Any Veteran in household served in Iraq or Afghanistan Error"
  • dq_client_program_demographics.ssvf_hp_targeting_criteria_at_least_one_dependent_child_under_age_six - "SSVF HP Targeting Criteria - At least one dependent child under age 6 Error"
  • dq_client_program_demographics.ssvf_hp_targeting_criteria_at_least_one_dependent_child_under_age_six_count - "SSVF HP Targeting Criteria - At least one dependent child under age 6 Error Count"
  • dq_client_program_demographics.ssvf_hp_targeting_criteria_current_household_income_zero_error - "SSVF HP Targeting Criteria - Current Household Income is 0 Error"
  • dq_client_program_demographics.ssvf_hp_targeting_criteria_current_household_income_zero_error_count - "SSVF HP Targeting Criteria - Current Household Income is 0 Error Count"
  • dq_client_program_demographics.ssvf_hp_targeting_criteria_female_veteran_error - "SSVF HP Targeting Criteria - Female Veteran Error"
  • dq_client_program_demographics.ssvf_hp_targeting_criteria_female_veteran_error_count - "SSVF HP Targeting Criteria - Female Veteran Error Count"
  • dq_client_program_demographics.ssvf_hp_targeting_criteria_history_of_literal_homelessness_error - "SSVF HP Targeting Criteria - History of Literal Homelessness Error"
  • dq_client_program_demographics.ssvf_hp_targeting_criteria_history_of_literal_homelessness_error_count - "SSVF HP Targeting Criteria - History of Literal Homelessness Error Count"
  • dq_client_program_demographics.ssvf_hp_targeting_criteria_major_change_in_household_composition_error - "SSVF HP Targeting Criteria - Major change in household composition Error"
  • dq_client_program_demographics.ssvf_hp_targeting_criteria_major_change_in_household_composition_error_count - "SSVF HP Targeting Criteria - Major change in household composition Error Count"
  • dq_client_program_demographics.ssvf_hp_targeting_criteria_rental_evictions_within_the_past_seven_years_error - "SSVF HP Targeting Criteria - Rental Evictions within the Past 7 Years Error"
  • dq_client_program_demographics.ssvf_hp_targeting_criteria_rental_evictions_within_the_past_seven_years_error_count - "SSVF HP Targeting Criteria - Rental Evictions within the Past 7 Years Error Count"
  • dq_client_program_demographics.ssvf_hp_targeting_criteria_sudden_significant_cash_decrease_expense_increase_error - "SSVF HP Targeting Criteria - Sudden Significant Cash Decrease or Expense Increase Error"
  • dq_client_program_demographics.ssvf_hp_targeting_criteria_sudden_significant_cash_decrease_expense_increase_error_count - "SSVF HP Targeting Criteria - Sudden Significant Cash Decrease or Expense Increase Error Count"
  • dq_client_program_demographics.ssvf_hp_targeting_criteria_urgent_referral_error - "SSVF HP Targeting Criteria - Urgent Referral Error"
  • dq_client_program_demographics.ssvf_hp_targeting_criteria_urgent_referral_error_count - "SSVF HP Targeting Criteria - Urgent Referral Error Count"

The following fields have been removed from the retired group in the DQ Project Descriptor View

  • dq_project_descriptor.tracking_method_error - "Tracking Method Error" 
  • dq_project_descriptor.tracking_method_error_count - "Tracking Method Error Count" 


    Required Actions: Update any content that uses the above fields. 

 

Services Model:

Updated the dimension “type_provided_text” in the Services view  in the Services model to match the 2024 Data Standards

Required Actions: Update any content where the above field is hardcoded in custom filters or custom fields.

Updated : 11/15/2023