Release Notes Summary
The changes outlined here will be released to all looker instances on 12/18/2023. There may be changes to this article until the release date.
We acknowledge this release is on an abbreviated timeline. We appreciate your understanding as Data Services attempts 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.
The "Start Date" field has been added to the Sites, Buildings and Unit Configurations views in the Project Descriptor and Inventory Models, and the Program Sites view in the HMIS Performance and Client models
The "Created Date" field has been added to the Referrals and Referral History views in the Client, Coordinated Entry, and Inventory models, and Referral History: Added Date has been updated in line with other date fields.
The field "Bed and Unit Management" under the "Referral Settings" view in the Project Descriptor model has been updated in line with changes in Clarity Human Services.
A new field "Default Bed and Unit Management Value" has been added to the Project Descriptor model in the "Referral Settings" view.
New fields "Bed and Unit Management" and "Direct Unit/Bed Referrals" have been added to the Project Descriptor model in the "Programs" view.
The Gender and Race Ethnicity fields in the Clients view in all models have been refactored to avoid using Persistent Derived Tables. This was done to improve performance as we add new Gender and Race Ethnicity fields with different categories in a future release. We expect aliasing to take care of the changes in existing content but there may be some updates needed in cases where the fields are used in custom filters and fields.
Client Model:
The following dimensions in the Clients view have been refactored to avoid using Persistent Derived Tables. The field names will change as shown below.
- "Gender",
- "client_demographics_gender.gender_text" will be replaced by "static_demographics.gender_text"
- "Woman (Girl if child)",
- "client_demographics_gender.gender_0_text" will be replaced by "static_demographics.gender_0_text"
- "Man (Boy if Child)",
- "client_demographics_gender.gender_1_text" will be replaced by "static_demographics.gender_1_text"
- "Culturally Specific Identity",
- "client_demographics_gender.gender_2_text" will be replaced by "static_demographics.gender_2_text"
- "Different Identity",
- "client_demographics_gender.gender_3_text" will be replaced by "static_demographics.gender_3_text"
- "Non-Binary",
- "client_demographics_gender.gender_4_text" will be replaced by "static_demographics.gender_4_text"
- "Transgender",
- "client_demographics_gender.gender_5_text" will be replaced by "static_demographics.gender_5_text"
- "Questioning",
- "client_demographics_gender.gender_6_text " will be replaced by "static_demographics.gender_6_text"
The hidden "gender_raw" dimension has been removed. It was aliased as "static_demographics.gender_raw" and "client_demographics_gender.gender_raw".
The following dimensions in the Clients view have been refactored to avoid using Persistent Derived Tables. The field names will change as shown below.
- "Race and Ethnicity",
- "client_demographics_race_ethnicity.race_ethnicity_text" will be replaced by "static_demographics.race_ethnicity_text"
- "American Indian, Alaska Native, or Indigenous",
- "client_demographics_race_ethnicity.race_ethnicity_1_text" will be replaced by "static_demographics.race_ethnicity_1_text"
- "Asian or Asian American",
- "client_demographics_race_ethnicity.race_ethnicity_2_text" will be replaced by "static_demographics.race_ethnicity_2_text"
- "Black, African American, or African",
- "client_demographics_race_ethnicity.race_ethnicity_3_text" will be replaced by "static_demographics.race_ethnicity_3_text"
- "Native Hawaiian or Pacific Islander",
- "client_demographics_race_ethnicity.race_ethnicity_4_text" will be replaced by "static_demographics.race_ethnicity_4_text"
- "White",
- "client_demographics_race_ethnicity.race_ethnicity_5_text" will be replaced by "static_demographics.race_ethnicity_5_text"
- "Hispanic/Latina/e/o",
- "client_demographics_race_ethnicity.race_ethnicity_6_text" will be replaced by "static_demographics.race_ethnicity_6_text"
- "Middle Eastern or North African"
- "client_demographics_race_ethnicity.race_ethnicity_7_text" will be replaced by "static_demographics.race_ethnicity_7_text"
A new field has been added to the Program Sites view.
- "Start Date" -
- sites.start_date
- sites.start_month
-
- sites.start_quarter
- sites.start_week
-
- sites.start_year
- sites.start_year
A new dimension group has been added to the Referrals and Referral History views:
- "Created Date" -
- referrals.created_date
- referrals.created_month
- referrals.created_quarter
- referrals.created_week
- referrals.created_year
- referral_history.created_date
- referral_history.created_month
- referral_history.created_quarter
- referral_history.created_week
- referral_history.created_year
The "Referral History: Added date" field has been updated to a dimension grouped in line with other date fields.
- referral_history.added_date
- referral_history.added_month
- referral_history.added_quarter
- referral_history.added_time
- referral_history.added_week
- referral_history.added_year
This field will automatically be replaced in content with the “Added Date” value from the “Added Date” dimension group. The previous “Added Date” dimension was a 'datetime' field, and included the time in the single value. Using the dimension group fields, “Added Date” will now only be a date. To display the date and time, the customer will need to use the field “Added Time”.
Required Action:
The gender and race fields will be aliased so we do not expect existing content to break, but content using these the gender or race and ethnicity fields in a custom filter or custom dimensions may need to be updated to the new field names.
"Referrals History: Added Date” will now only be a date. Existing content displaying the date and time, will need to be updated to use the field “Added Time”.
Coordinated Entry Model:
The following dimensions in the Clients view have been refactored to avoid using Persistent Derived Tables. We are updating the following fields.
- "Gender",
- "client_demographics_gender.gender_text" will be replaced by "static_demographics.gender_text"
- "Woman (Girl if child)",
- "client_demographics_gender.gender_0_text" will be replaced by "static_demographics.gender_0_text"
- "Man (Boy if Child)",
- "client_demographics_gender.gender_1_text" will be replaced by "static_demographics.gender_1_text"
- "Culturally Specific Identity",
- "client_demographics_gender.gender_2_text" will be replaced by "static_demographics.gender_2_text"
- "Different Identity",
- "client_demographics_gender.gender_3_text" will be replaced by "static_demographics.gender_3_text"
- "Non-Binary",
- "client_demographics_gender.gender_4_text" will be replaced by "static_demographics.gender_4_text"
- "Transgender",
- "client_demographics_gender.gender_5_text" will be replaced by "static_demographics.gender_5_text"
- "Questioning",
- "client_demographics_gender.gender_6_text" will be replaced by "static_demographics.gender_6_text"
The hidden "gender_raw" dimension has been removed. It was aliased as "static_demographics.gender_raw" and "client_demographics_gender.gender_raw".
The following dimensions in the Clients view have been refactored to avoid using Persistent Derived Tables. The field names will change as shown below.
- "Race and Ethnicity",
- "client_demographics_race_ethnicity.race_ethnicity_text" will be replaced by "static_demographics.race_ethnicity_text"
- "American Indian, Alaska Native, or Indigenous",
- "client_demographics_race_ethnicity.race_ethnicity_1_text" will be replaced by "static_demographics.race_ethnicity_1_text"
- "Asian or Asian American",
- "client_demographics_race_ethnicity.race_ethnicity_2_text " will be replaced by "static_demographics.race_ethnicity_2_text"
- "Black, African American, or African",
- "client_demographics_race_ethnicity.race_ethnicity_3_text" will be replaced by "static_demographics.race_ethnicity_3_text"
- "Native Hawaiian or Pacific Islander",
- "client_demographics_race_ethnicity.race_ethnicity_4_text" will be replaced by "static_demographics.race_ethnicity_4_text"
- "White",
- "client_demographics_race_ethnicity.race_ethnicity_5_text" will be replaced by "static_demographics.race_ethnicity_5_text"
- "Hispanic/Latina/e/o",
- "client_demographics_race_ethnicity.race_ethnicity_6_text" will be replaced by "static_demographics.race_ethnicity_6_text"
- "Middle Eastern or North African"
- "client_demographics_race_ethnicity.race_ethnicity_7_text "will be replaced by "static_demographics.race_ethnicity_7_text"
A new field has been added to the Program Sites view .
- "Start Date" -
- sites.start_date
- sites.start_month
- sites.start_quarter
- sites.start_week
- sites.start_year
A new dimension group has been added to the Referrals and Referral History views:
- "Created Date" -
- referrals.created_date
- referrals.created_month
- referrals.created_quarter
- referrals.created_week
- referrals.created_year
- referral_history.created_date
- referral_history.created_month
- referral_history.created_quarter
- referral_history.created_week
- referral_history.created_year
The "Referral History: Added date" field has been updated to a dimension group in line with other date fields.
- referral_history.added_date
- referral_history.added_month
- referral_history.added_quarter
- referral_history.added_time
- referral_history.added_week
- referral_history.added_year
This field will automatically be replaced in content with the “Added Date” value from the “Added Date” dimension group. The previous “Added Date” dimension was a 'datetime' field, and included the time in the single value. Using the dimension group fields, “Added Date” will now only be a date. To display the date and time, the customer will need to use the field “Added Time”.
Required Action:
The gender and race fields will be aliased so we do not expect existing content to break, but content using these the gender or race and ethnicity fields in a custom filter or custom dimensions may need to be updated to the new field names.
"Referrals History: Added Date” will now only be a date. Existing content displaying the date and time, will need to be updated to use the field “Added Time”.
HMIS Performance Model:
The following dimensions in the Clients view have been refactored to avoid using Persistent Derived Tables. The field names will change as shown below.
- "Gender",
- "client_demographics_gender.gender_text" will be replaced by "static_demographics.gender_text"
- "Woman (Girl if child)",
- "client_demographics_gender.gender_0_text" will be replaced by "static_demographics.gender_0_text"
- "Man (Boy if Child)",
- "client_demographics_gender.gender_1_text" will be replaced by "static_demographics.gender_1_text"
- "Culturally Specific Identity",
- "client_demographics_gender.gender_2_text" will be replaced by "static_demographics.gender_2_text"
- "Different Identity",
- "client_demographics_gender.gender_3_text" will be replaced by "static_demographics.gender_3_text"
- "Non-Binary",
- "client_demographics_gender.gender_4_text" will be replaced by "static_demographics.gender_4_text"
- "Transgender",
- "client_demographics_gender.gender_5_text" will be replaced by "static_demographics.gender_5_text"
- "Questioning",
- "client_demographics_gender.gender_6_text" will be replaced by "static_demographics.gender_6_text"
The hidden "gender_raw" dimension has been removed. It was aliased as "static_demographics.gender_raw" and "client_demographics_gender.gender_raw".
The following dimensions in the Clients view have been refactored to avoid using Persistent Derived Tables. The field names will change as shown below.
- "Race and Ethnicity",
- "client_demographics_race_ethnicity.race_ethnicity_text" will be replaced by "static_demographics.race_ethnicity_text"
- "American Indian, Alaska Native, or Indigenous",
- "client_demographics_race_ethnicity.race_ethnicity_1_text" will be replaced by "static_demographics.race_ethnicity_1_text"
- "Asian or Asian American",
- "client_demographics_race_ethnicity.race_ethnicity_2_text" will be replaced by "static_demographics.race_ethnicity_2_text"
- "Black, African American, or African",
- "client_demographics_race_ethnicity.race_ethnicity_3_text" will be replaced by "static_demographics.race_ethnicity_3_text"
- "Native Hawaiian or Pacific Islander",
- "client_demographics_race_ethnicity.race_ethnicity_4_text"will be replaced by "static_demographics.race_ethnicity_4_text"
- "White",
- "client_demographics_race_ethnicity.race_ethnicity_5_text" will be replaced by "static_demographics.race_ethnicity_5_text"
- "Hispanic/Latina/e/o",
- "client_demographics_race_ethnicity.race_ethnicity_6_text" will be replaced by "static_demographics.race_ethnicity_6_text"
- "Middle Eastern or North African"
- "client_demographics_race_ethnicity.race_ethnicity_7_text" will be replaced by "static_demographics.race_ethnicity_7_text"
A new field has been added to the Program Sites view .
- "Start Date" -
- sites.start_date
- sites.start_month
- sites.start_quarter
- sites.start_week
- sites.start_year
Required Action:
The gender and race fields will be aliased so we do not expect existing content to break, but content using these the gender or race and ethnicity fields in a custom filter or custom dimensions may need to be updated to the new field names.
Inventory Model:
A new field has been added to the Sites, Inventory - Buildings, and Inventory - Building Unit Configurations views.
- "Start Date" -
- sites.start_date
- sites.start_month
- sites.start_quarter
- sites.start_week
- sites.start_year
- buildings.start_date
- buildings.start_month
- buildings.start_quarter
- buildings.start_week
- buildings.start_year
- unit_configurations.start_date
- unit_configurations.start_month
- unit_configurations.start_quarter
- unit_configurations.start_week
- unit_configurations.start_year
A new dimension group has been added in the Referrals view:
- "Created Date" -
- referrals.created_date
- referrals.created_month
- referrals.created_quarter
- referrals.created_week
- referrals.created_year
Outreach Model:
The Gender and Race and Ethnicity fields in the Clients view have been refactored to avoid using Persistent Derived Tables. The field names will change as shown below.
- "Gender", "client_demographics_gender.gender_text" will be replaced by "static_demographics.gender_text"
- "Race and Ethnicity",
- "client_demographics_race_ethnicity.race_ethnicity_text" will be replaced by "static_demographics.race_ethnicity_text"
Required Action:
The gender and race fields will be aliased so we do not expect existing content to break, but content using these the gender or race and ethnicity fields in a custom filter or custom dimensions may need to be updated to the new field names.
Population over Time Model:
The following dimensions in the Clients view have been refactored to avoid using Persistent Derived Tables. The field names will change as shown below.
- "Gender",
- "client_demographics_gender.gender_text" will be replaced by "static_demographics.gender_text"
The following dimensions in the Clients view have been refactored to avoid using Persistent Derived Tables. The field names will change as shown below.
- "Race and Ethnicity",
- "client_demographics_race_ethnicity.race_ethnicity_text" will be replaced by "static_demographics.race_ethnicity_text"
- "American Indian, Alaska Native, or Indigenous",
- "client_demographics_race_ethnicity.race_ethnicity_1_text" will be replaced by "static_demographics.race_ethnicity_1_text"
- "Asian or Asian American",
- "client_demographics_race_ethnicity.race_ethnicity_2_text" will be replaced by "static_demographics.race_ethnicity_2_text"
- "Black, African American, or African",
- "client_demographics_race_ethnicity.race_ethnicity_3_text" will be replaced by "static_demographics.race_ethnicity_3_text"
- "Native Hawaiian or Pacific Islander",
- "client_demographics_race_ethnicity.race_ethnicity_4_text" will be replaced by "static_demographics.race_ethnicity_4_text"
- "White",
- "client_demographics_race_ethnicity.race_ethnicity_5_text" will be replaced by "static_demographics.race_ethnicity_5_text"
- "Hispanic/Latina/e/o",
- "client_demographics_race_ethnicity.race_ethnicity_6_text" will be replaced by "static_demographics.race_ethnicity_6_text"
- "Middle Eastern or North African"
- "client_demographics_race_ethnicity.race_ethnicity_7_text" will be replaced by "static_demographics.race_ethnicity_7_text"
Required Action:
The gender and race fields will be aliased so we do not expect existing content to break, but content using these the gender or race and ethnicity fields in a custom filter or custom dimensions may need to be updated to the new field names.
Project Descriptor Model:
The "Start Date" field has been added to the Sites, Buildings and Unit Configurations views in the Project Descriptor and Inventory Models, and the Sites view in the HMIS Performance and Client models
A new field has been added to the Sites, Inventory - Buildings, and Inventory - Building Unit Configurations views.
- "Start Date" -
- sites.start_date
- sites.start_month
- sites.start_quarter
- sites.start_week
- sites.start_year
- buildings.start_date
- buildings.start_month
- buildings.start_quarter
- buildings.start_week
- buildings.start_year
- unit_configurations.start_date
- unit_configurations.start_month
- unit_configurations.start_quarter
- unit_configurations.start_week
- unit_configurations.start_year
The following field under the "Referral Settings" view has been updated from a “Yes/No” field to using a picklist with the options “Disabled”, “Optional”, and “Required”.
- "Bed and Unit Management", referral_settings.bed_unit_management
A new field "Default Bed and Unit Management Value" has been added to the "Referral Settings" view.
- "Default Bed and Unit Management Value", referral_settings.default_bed_unit_management
The following new fields "Bed and Unit Management" and "Direct Unit/Bed Referrals" have been added to the "Programs" view.
- "Bed and Unit Management", programs.enable_bed_unit_management
- "Direct Unit/Bed Referrals", programs.unit_bed_referrals
The field "Bed and Unit Management" is a "Yes/No" field based on the "Manage Units/Beds" toggle in the Program Setup screen in Clarity.
The field "Direct Unit/Bed Referrals" uses a picklist with the options "Disabled", "Optional" and "Required" based on the "Direct Unit/Bed Referrals" dropdown in the Program Setup screen in Clarity.
Required Action: None
Reservations Model:
The following dimensions in the Clients view have been refactored to avoid using Persistent Derived Tables. The field names will change as shown below.
- "Gender",
- "client_demographics_gender.gender_text" will be replaced by "static_demographics.gender_text"
The following dimensions in the Clients view have been refactored to avoid using Persistent Derived Tables. The field names will change as shown below.
- "Race and Ethnicity",
- "client_demographics_race_ethnicity.race_ethnicity_text" will be replaced by "static_demographics.race_ethnicity_text"
- "American Indian, Alaska Native, or Indigenous",
- "client_demographics_race_ethnicity.race_ethnicity_1_text" will be replaced by "static_demographics.race_ethnicity_1_text"
- "Asian or Asian American",
- "client_demographics_race_ethnicity.race_ethnicity_2_text" will be replaced by "static_demographics.race_ethnicity_2_text"
- "Black, African American, or African",
- "client_demographics_race_ethnicity.race_ethnicity_3_text" will be replaced by "static_demographics.race_ethnicity_3_text"
- "Native Hawaiian or Pacific Islander",
- "client_demographics_race_ethnicity.race_ethnicity_4_text" will be replaced by "static_demographics.race_ethnicity_4_text"
- "White",
- "client_demographics_race_ethnicity.race_ethnicity_5_text" will be replaced by "static_demographics.race_ethnicity_5_text"
- "Hispanic/Latina/e/o",
- "client_demographics_race_ethnicity.race_ethnicity_6_text" will be replaced by "static_demographics.race_ethnicity_6_text"
- "Middle Eastern or North African"
- "client_demographics_race_ethnicity.race_ethnicity_7_text" will be replaced by "static_demographics.race_ethnicity_7_text"
Required Action:
The gender and race fields will be aliased so we do not expect existing content to break, but content using these the gender or race and ethnicity fields in a custom filter or custom dimensions may need to be updated to the new field names.
Services Model:
The following dimensions in the Clients view have been refactored to avoid using Persistent Derived Tables. The field names will change as shown below.
- "Gender",
- "client_demographics_gender.gender_text" will be replaced by "static_demographics.gender_text"
The following dimensions in the Clients view have been refactored to avoid using Persistent Derived Tables. The field names will change as shown below.
- "Race and Ethnicity",
- "client_demographics_race_ethnicity.race_ethnicity_text" will be replaced by "static_demographics.race_ethnicity_text"
- "American Indian, Alaska Native, or Indigenous",
- "client_demographics_race_ethnicity.race_ethnicity_1_text" will be replaced by "static_demographics.race_ethnicity_1_text"
- "Asian or Asian American",
- "client_demographics_race_ethnicity.race_ethnicity_2_text" will be replaced by "static_demographics.race_ethnicity_2_text"
- "Black, African American, or African",
- "client_demographics_race_ethnicity.race_ethnicity_3_text" will be replaced by "static_demographics.race_ethnicity_3_text"
- "Native Hawaiian or Pacific Islander",
- "client_demographics_race_ethnicity.race_ethnicity_4_text" will be replaced by "static_demographics.race_ethnicity_4_text"
- "White",
- "client_demographics_race_ethnicity.race_ethnicity_5_text" will be replaced by "static_demographics.race_ethnicity_5_text"
- "Hispanic/Latina/e/o",
- "client_demographics_race_ethnicity.race_ethnicity_6_text" will be replaced by "static_demographics.race_ethnicity_6_text"
- "Middle Eastern or North African"
- "client_demographics_race_ethnicity.race_ethnicity_7_text" will be replaced by "static_demographics.race_ethnicity_7_text"
Required Action:
The gender and race fields will be aliased so we do not expect existing content to break, but content using these the gender or race and ethnicity fields in a custom filter or custom dimensions may need to be updated to the new field names.
Updated 12/13/23