Release Notes Summary
The changes outlined here will be released to Looker training instances on 10/22/2024 and production instances on 11/5/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.
Client Model
A new field has been added to the "Programs" View.
Project Descriptor Model
Four new fields have been added to the “Program Templates” View.
Five new fields have been added to the "Referral Settings" View.
Project Descriptor, Inventory Model
Four new fields have been added to the “Inventory - Units” and “Inventory - Unit Configuration Beds” Views.
Outreach Model
A filter-only field has been added to the Outreach model to aid in filtering for geolocations active on a specific date.
Detailed Release Notes
Client Model
The "Program Deleted (Yes/No)" field has been added to the "Programs" View in the Client Model.
New Fields
"Program Deleted (Yes/No)"
- Description: "Denotes if a program has been deleted with 'Yes', while 'No' indicates program is not deleted."
- LookML Field Name: "programs.deleted"
Project Descriptor Model
"Added Date", "User Created", "Last Updated Date", and "User Updated" fields are added to the "Program Templates" View in the Project Descriptor Model
"Allow Multiple Referrals to Beds/Units", "Deny Multiple Referrals Upon Enrollment" have been added to the "Referral Settings" view. "Send to Community Queue", "Denied By Type", "Denied Reason", and "Denial Information" have been added to the "Referral Settings" view under the group label "Default Values".
New Fields in "Program Templates" View:
- “Added Date”
- Description: “Date the record was added”
- LookML Field Name: “Program_templates.added_date”
- “Added Month”
- Description: “Date the record was added”
- LookML Field Name: “Program_templates.added_month”
- “Added Quarter”
- Description: “Date the record was added”
- LookML Field Name: “Program_templates.added_quarter”
- “Added Time”
- Description: “Date the record was added”
- LookML Field Name: “Program_templates.added_time”
- “Added Week”
- Description: “Week the record was added”
- LookML Field Name: “Program_templates.added_year”
- “Added Year”
- Description: “Date the record was added”
- LookML Field Name: “Program_templates.added_year”
- “User Created”
- Description: “Username of the User that created the Program Template”
- LookML Field Name: “Program_templates.user_created”
- “Last Updated Date”
- Description: “Date the record was last updated”
- LookML Field Name: “Program_templates.last_updated_date”
- “Last Updated Month”
- Description: “Date the record was last updated”
- LookML Field Name: “Program_templates.last_updated_month”
- “Last Updated Quarter”
- Description: “Date the record was last updated”
- LookML Field Name: “Program_templates.last_updated_quarter”
- “Last Updated Time”
- Description: “Date the record was last updated”
- LookML Field Name: “Program_templates.last_updated_time”
- “Last Updated Week”
- Description: “Date the record was last updated”
- LookML Field Name: “Program_templates.last_updated_week”
- “Last Updated Year”
- Description: “Date the record was last updated”
- LookML Field Name: “Program_templates.last_updated_year”
- “User Updated”
- Description: “Username of the User that last updated the Program Template”
- LookML Field Name: “Program_templates.ref_user_updated_text”
New Fields in "Referral Settings" View:
- "Allow Multiple Referrals to Beds/Units"
- Description: "A Unit and/or a Bed can have more than one referral connected once 'Allow Multiple Referrals' is enabled."
- LookML Field Name: "referral_settings.allow_multiple_referrals"
- "Deny Multiple Referrals Upon Enrollment"
- Description: "Pending referrals to beds and units will be denied and will not remain in pending status once 'Deny Multiple Referrals Upon Enrollment' is enabled."
- LookML Field Name: "referral_settings.deny_multiple_referrals"
- "Send To Community Queue"
- Group Label: "Default Denial Fields Values"
- Description: "Is the 'Send to Community Queue' toggled on in the Referral Settings?"
- LookML Field Name: "referral_settings.send_to_cq"
- "Denied By Type"
- Group Label: "Default Denial Fields Values"
- Description: "The party who denied the Referral"
- LookML Field Name: "referral_settings.denied_by_type_text"
- "Denied Reason"
- Group Label: "Default Denial Fields Values"
- Description: "The default reason a Referral was denied"
- LookML Field Name: "referral_settings.denied_reason_text"
- "Denial Information"
- Group Label: "Default Denial Fields Values"
- Description: "A note explaining why a Referral was denied"
- LookML Field Name: "referral_settings.denied_message"
Project Descriptor, Inventory Model
Added the 'Allow Multiple Referrals" and “Maximum Referrals" fields to the Inventory - Building Units table and Inventory - Unit Configuration Beds table within the Project Descriptor Model and the Inventory Model
New Fields
- “Inventory - Building Units”: “Allow Multiple Referrals”
- Description: A unit can have more than one referral connected once 'Allow Multiple Referrals' is enabled.
- LookML Field Name: “units.allow_multiple_referrals”
- “Inventory - Building Units”: “Maximum Referrals”
- Description: The maximum number of pending referrals to a unit at any given time.
- LookML Field Name: “units.maximum_referrals”
- “Inventory - Unit Configuration Beds”: “Allow Multiple Referrals”
- Description: “A bed can have more than one referral connected once 'Allow Multiple Referrals' is enabled.”
- LookML Field Name: “unit_configuration_beds.allow_multiple_referrals”
- “Inventory - Unit Configuration Beds”: “Maximum Referrals”
- Description: “The maximum number of pending referrals to a bed at any given time.”
- LookML Field Name: “unit_configuration_beds.maximum_referrals”
Outreach Model
A new filter-only field has been added to the Outreach Model, under the “Filters” View. The ‘Outreach Time Filter’ is applied to the Geolocation History view and the Encampment Stays view. This filter allows users to look at Geolocation History and Encampment Stay data that was active as of a specific date, where the record start date is less than or equal to the Outreach Time selected in the filter, and the record end date is greater than the Outreach Time or there is no record end date. When the filter is initially applied to the query, the default date is the current date, until changed by the user. If the filter is not added to the query, Geolocation History and Encampment Stay data will be unaffected.
New Fields:
- “Outreach Time Filter”
- Description: “The "Outreach Time Filter" is a single date, and allows the 'Geolocation History' and 'Encampment Stays' views to filter results based on it, if the filter is added to the query. When the filter is enabled, only Geolocations and Geolocation History records active on the "Outreach Time Filter" date will be included in the results. If the filter is added to the query with no date selected, the filter will default to the current date. If the filter is not applied to the query, it will not affect the results.”
- LookML Field Name: “pit_date_filter.outreach_time_filter”