Release Notes Summary
The changes outlined here will be released to Looker training instances on 7/29/2024 and production instances on 08/12/2024. Deployment should be complete by 8am ET. There may be slight delays when accessing Looker after the release as the system updates are being applied.
Looker Upgrade
The Data Analysis Tool will be upgraded to Looker version 24.10 during the maintenance window on August 4, 2024. Release notes for Looker can be found here.
In this upgrade, The Maps(Legacy) visualization type is no longer available. Existing looks or dashboard tiles using the Maps(Legacy) visualization type will now display as the Google Maps visualization type.
Action Required: Looks that were created using the Maps(Legacy) visualization type will display as a Google Maps visualization type. Looks may need to be edited and resaved for data to display properly on the maps.
LookML Bug Fixes
Beginning August 5, 2024, Bug fixes for the LookML project will be released on Mondays between 4 AM and 6 AM Pacific Standard Time. Communication about the changes will be available on the 2024 Data Services Change Log. Customers may experience slower than usual performance on the Looker Application during this window of time. Customers with embedded dashboards set as their login screens may experience slow login times during the release window. The schedule of bug fixes is subject to change, and additional bug fixes may be released as needed outside of the described window.
Action Required: None
LookML Dashboards
The HMIS Data Quality Supplemental LookML Dashboard logic was updated to align with the addition of 'x' placeholders in Social Security Numbers as referenced in the HMIS Reporting Glossary for Table Q2. Personally Identifiable Information (PII) Row 3 Social Security Number (3.02).
Action Required: None
Inventory Model, Project Descriptor Model
Two new fields have been added to the "Buildings", "Units", and "Programs" Views: "Agencies Sending Referrals" and "Other Agency Referrals Allowed".
Project Descriptor Model
Twelve new fields have been added to the "Outreach Settings" view in the Project Descriptor model. Four fields have updated descriptions. The "Restrict by CoC" field has been changed from a yes/no datatype to a string datatype.
Outreach Model
In the "Outreach Settings" view, four fields have updated descriptions. The "Restrict by CoC" field has been changed from a yes/no datatype to a string datatype.
Data Quality Model
Two new fields have been added to the "Programs" View: "Agencies Sending Referrals" and "Other Agency Referrals Allowed".
Added additional checks to the "SSN Error" field.
Reservations Model
Two new fields have been added to the "Programs" View: "Agencies Sending Referrals" and "Other Agency Referrals Allowed".
Client Model, Coordinated Entry Model, HMIS Performance Model, Project Descriptor Model, Data Quality Model, Outreach Model, Inventory Model, Services Model, Population Over Time Model
Added Country to Location group in each view where geolocation information is present.
Detailed Release Notes
Inventory Model, Project Descriptor Model
Two new fields have been added to the "Buildings" View. "Agencies Sending Referrals" and "Other Agency Referrals Allowed".
- New Fields:
- "Agencies Sending Referrals"
- Description: "A list of the agencies sending referrals to the building."
- Field name: “buildings.agencies_sending_referrals”
- “Other Agency Referrals Allowed”
- Description: "Are referrals to the building from outside agencies allowed?"
- Field name: “buildings.other_agency_referrals_allowed”
- "Agencies Sending Referrals"
Two new fields have been added to the "Units" View.
- New Fields:
- "Agencies Sending Referrals"
- Description: "A list of the agencies sending referrals to the unit."
- Field name: "units.agencies_sending_referrals"
- "Other Agency Referrals Allowed"
- Description: "Are referrals to the unit from outside agencies allowed?"
- Field name: "units.other_agency_referrals_allowed"
- "Agencies Sending Referrals"
Two new fields have been added to the "Inventory - Unit Configuration Beds" View.
- New Fields:
- "Agencies Sending Referrals"
- Description: "A list of the agencies sending referrals to the bed."
- Field name: "unit_bed_settings.agencies_sending_referrals"
- "Other Agency Referrals Allowed"
- Description: "Are referrals to the bed from outside agencies allowed?"
- Field name: "unit_bed_settings.other_agency_referrals_allowed"
- "Agencies Sending Referrals"
Two new fields have been added to the "Programs" View.
- New Fields:
- "Agencies Sending Referrals"
- Description: "A list of the agencies sending referrals to the program."
- Field name: "programs.agencies_sending_referrals"
- "Other Agency Referrals Allowed"
- Description: "Are referrals to the program from outside agencies allowed?"
- Field name: "programs.other_agency_referrals_allowed"
- "Agencies Sending Referrals"
Action Required: None
Project Descriptor Model, Outreach Model
Twelve new fields have been added to the "Outreach Settings" view. Four fields have updated descriptions, and one field has been changed from a yes/no datatype to a string datatype.
- New Fields:
- Agency Name
- Description: "The name of the agency of the user creating the record"
- Field Name: "outreach_settings.ref_agency_text"
- Agency Updated Name
- Description: "The name of the agency of the user updated the record"
- Field Name: "outreach_settings.ref_agency_updated_text"
- Area Limited By
- Description:"The location search is limited by the chosen area once the 'Limit Geographic Area Address Suggestions' is enabled ."
- Field Name: "outreach_settings.limit_area_text"
- Automated Housed Notifications
- Description: "Is the 'Automated Label when Housed or Sheltered' toggle enabled?"
- Field Name: "outreach_settings.housed_notification"
- Agency Name
-
- Display Active Encampment Enrollments
- Description: "Is the 'Display Active Encampment Enrollments on Client Profile' toggle enabled?"
- Field Name: "outreach_settings.enable_enrollment_info"
- Display Active Encampment Enrollments
-
- Encampment Screen ID
- Description: "ID Number of this particular Encampment Screen"
- Field Name: "outreach_settings.ref_screen_text"
- Encampment Screen ID
-
- Encampment Screen Name
- Description: "Name of the Encampment Screen"
- Field Name: "outreach_settings.encampment_screen_name"
- Encampment Screen Name
-
- Limit Radius
- Description: "The location search is limited by the specified number of miles radius."
- Field Name: "outreach_settings.limit_radius"
- Limit Suggestions
- Description: Is the 'Limit Geographic Area Address Suggestions' toggle enabled?"
- Field Name: "outreach_settings.limit_suggestions"
- Published
- Description: "Has the 'Location & Outreach Setting' changes been published?"
- Field Name: "outreach_settings.must_be_published"
- Limit Radius
-
- User Created
- Description:"Username of the User who created the record."
- Field Name: "outreach_settings.ref_user_text"
- User Created
-
- User Updated
- Description: "Username of the User who updated the record."
- Field Name: "outreach_settings.ref_user_updated_text"
- User Updated
- Changed Descriptions:
- Encampment Program Agency ID
- Description now reads: "ID of the Agency Associated with the Encampment Program"
- Field Name: "outreach_settings.ref_agency"
- Encampment Program Agency ID
-
- Encampment Program Agency Name
- Description now reads: "Name of the Agency Associated with the Encampment Program"
- Field Name: "outreach_settings.ref_agency_name"
- Encampment Program
- Description now reads: "Is the 'Encampment Programs' toggle enabled?"
- Field Name: "outreach_settings.encampment_program"
- Last Updated
- Description now reads: "The date this field was most recently updated"
- Field Name: "outreach_settings.last_updated_date"
- Encampment Program Agency Name
- Changed Data Type:
- Restrict By CoC
- Field changed from yes/no datatype to string datatype.
- Field Name:"outreach_settings.restrict_by_coc"
- Restrict By CoC
Action Required: Update any custom fields or filters that incorporate the "Outreach Settings: Restrict By CoC" field to account for the new string datatype.
Data Quality Model
Two new fields have been added to the "Programs" View.
- New Fields:
- "Agencies Sending Referrals"
- Description: "A list of the agencies sending referrals to the program."
- Field name: "dq_project_descriptor.agencies_sending_referrals"
- "Other Agency Referrals Allowed"
- Description: "Are referrals to the program from outside agencies allowed?"
- Field name: "dq_project_descriptor.other_agency_referrals_allowed"
- "Agencies Sending Referrals"
Added additional checks to the "SSN Error" field. Social Security Numbers with the following characteristics will now be flagged as "Possibly Invalid":
- Last 4 digits of SSN are 0000
- First 3 digits of SSN are 000, 666, or 999
- First digit of SSN is 9
- Middle two digits of SSN are 00
- All numbers in SSN are repeating (e.g., 222-22-2222 or 555-55-5555)
- All numbers in SSN are sequential (e.g., 123-45-6789 or 543-21-0987)
Action required: None
Reservations Model
Two new fields have been added to the "Programs" View
- New Fields:
- "Agencies Sending Referrals"
- Description: "A list of the agencies sending referrals to the program."
- Field name: "programs.agencies_sending_referrals"
- "Other Agency Referrals Allowed"
- Description: "Are referrals to the program from outside agencies allowed?"
- Field name: "programs.other_agency_referrals_allowed"
- "Agencies Sending Referrals"
Action Required: None
Client Model, Coordinated Entry Model, HMIS Performance Model, Project Descriptor Model, Data Quality Model, Outreach Model, Inventory Model, Services Model, Population Over Time Model
Added Country to Location group in each view where geolocation information is present.
- View: "Program Sites"
- New Field: "Location: Country"
- Description: "Country for the Program Site"
- Lookml Field Name: "sites_geolocations.country"
- Models where this view is included: Client Model, Project Descriptor Model, Data Quality Model, Population over Time Model
- View: "Client Addresses"
- New Field: "Location: Country"
- Description: "Country for the address"
- Lookml Field Name: "client_addresses_geolocations.country"
- Models where this view is included: Client Model, Coordinated Entry Model, HMIS Performance Model, Services Model
- View: Services
- New Field: “Service Location: Country”
- Description: “Country for the address”
- Lookml Field Name: "client_services_geolocations.country"
- Models where this view is included: Client Model, Coordinated Entry Model, HMIS Performance Model, Services Model
- View: Clients
- New Field: “Location: Country”
- Description: “Country of the geolocation on the client profile screen”
- Lookml Field Name: "client_geolocations.country"
- Models where this view is included: Client Model, Coordinated Entry Model, HMIS Performance Model, Population Over Time Model
- View: Entry Screen
- New Field: “Location: Country”
- Description: “Country for the address”
- Lookml Field Name: "entry_screen_geolocations.country"
- Models where this view is included: Client Model, Coordinated Entry Model, HMIS Performance Model, Population Over Time Model
- View: Update/Exit Screen
- New Field: “Location: Country”
- Description: “Country for the address on the update/exit screen”
- Lookml Field Name: last_screen_geolocations.country
- Models where this view is included: Client Model, Coordinated Entry Model, HMIS Performance Model, Population Over Time Model
- View: Status Update Screen
- New Field: “Location: Country”
- Description: “Country for the address on the status update screen”
- Lookml Field Name: "update_screen_geolocations.country"
- Models where this view is included: Client Model, Coordinated Entry Model, HMIS Performance Model
- View: Current Living Situation
- New Field: “Location: Country”
- Description: “Country for the current living situation address”
- Lookml Field Name: "update_screen_geolocations.country"
- Models where this view is included: Client Model, Coordinated Entry Model, HMIS Performance Model
- View: Agencies
- New Field: “Location: Country”
- Description: “The country associated with the agency”
- Lookml Field Name: "agencies_geolocations.country"
- Models where this view is included: Population Over Time Model, Project Descriptor Model, Services Model:
- View: Client Assessments
- New Field: “Location: Country”
- Description: “The country associated with the agency”
- Lookml Field Name: "client_assessment_demographics_geolocations.country"
- Models where this view is included: Client Model, Coordinated Entry Model
- View: Client Field Interaction
- New Field: “Location: Country”
- Description: “Country of the geolocation record”
- Lookml Field Name: "client_field_interactions_geolocations.country"
- Models where this view is included: Client Model, HMIS Performance Model
- View: Followup Screen
- New Field: “Location: Country”
- Description: “Country for the follow-up screen address”
- Lookml Field Name: "followup_screen_geolocations.country"
- Models where this view is included: Client Model, HMIS Performance Model
- View: Agency Sites
- New Field: “Location: Country”
- Description: “Country of Agency Site”
- Lookml Field Name: "agency_sites_geolocations.country"
- Models where this view is included: Project Descriptor Model
- View: Programs
- New Field: "CoC Information: Country"
- Description: "The country for the programs’ primary site"
- LookML Field Name: "primary_programs_geolocations.country"
- Models where this view is included: Project Descriptor Model, HMIS Performance Model
Action Required: None