Release Notes

Data Analysis Release Notes 12/3/2024

Release Notes Summary

The changes outlined here will be released to Looker training instances on 11/19/2024 and production instances on 12/3/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, Coordinated Entry Model, Inventory Model


Seven new fields related to Referral Date and Referral Status Date have been added.  


The formatting of eight assessment score and assessment subscore fields have been updated so that they display results no longer than 2 decimal places. 


Action Required: None


Client Model, HMIS Performance Model, Outreach Model


"Template Name" and "Template Status" are now available in the "Template Details" group of the Program View.

Action Required: None

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, Coordinated Entry Model, Inventory Model

 

Seven new fields related to Referral Date and Referral Status Date have been added.  

 

The formatting of eight Assessment score and assessment subscore fields have been updated so that they display results no longer than 2 decimal places. 

 

Action Required: None

 

Client Model, HMIS Performance Model, Outreach Model

 

"Template Name" and "Template Status" are now available in the "Template Details" group of the Program View.

 

HMIS Performance Model

 

The formatting of eight Assessment score and assessment subscore fields have been updated so that they display results no longer than 2 decimal places. 

 

Outreach Model

 

A new field  "Is Last Boundary per Encampment" has been added to the 'Encampment Boundaries' View. 

 

Project Descriptor

 

A new field "Customer Portal Enabled" has been added to the "Agencies" view.

 

A new, “Map Layers” view has been added with six new fields.  Three new fields related to Encampment Boundaries have been added in the "Encampments" View. 

 

Twelve new date dimensions related to "New Clarity Interface Last Switch" and "Clarity 2.0 Interface Last Switch" have been added to the "Staff" view.

 

Detailed Release Notes


Client Model, Coordinated Entry Model, Inventory Model


The field "Created Date" under the "Referrals" and "Referral History" views have been updated to include ‘time’ as a timeframe option.  A new field has been added for "Status Date" under the "Referrals" view.  These updates will impact the Client, Coordinated Entry, and Inventory models.  


The following Assessment Score fields in the “Client Assessments” view have been updated to display up to two decimal places: 

Field Name (LookML Field Name):

  • Assessment Score (client_assessment_scores.score)
  • Sub Score (client_assessment_scores.sub_score) 
  • Sub Score Family Unit (client_assessment_scores.sub_score_family_unit)
  • Sub Score General (client_assessment_scores.sub_score_general)
  • Sub Score Housing (client_assessment_scores.sub_score_housing)
  • Sub Score Risks (client_assessment_scores.sub_score_risks)
  • Sub Score Socialization (client_assessment_scores.sub_score_socialization)
  • Sub Score Wellness (client_assessment_scores.sub_score_wellness)
  • Highest Assessment Score (client_assessment_scores.assessment_score_max)

New Fields: 

  • “Created Time” 
    • Description: “The date and time the Referral was created. May differ from Date and Added Date if the referral was scheduled.”
    • LookML Field Name: “referrals.created_time”
  • “Status Date” 
    • Description: “The date associated with the Referral acceptance status.”
    • LookML Field Name: “referrals.status_date”
  • “Status Month” 
    • Description: “The date associated with the Referral acceptance status.”
    • LookML Field Name: “referrals.status_month”
  • “Status Quarter” 
    • Description: “The date associated with the Referral acceptance status.”
    • LookML Field Name: “referrals.status_quarter”
  • “Status Time” 
    • Description: “The date associated with the Referral acceptance status.”
    • LookML Field Name: “referrals.status_time”
  • “Status Week” 
    • Description: “The date associated with the Referral acceptance status.”
    • LookML Field Name: “referrals.status_week”
  • “Status Year” 
    • Description: “The date associated with the Referral acceptance status.”
    • LookML Field Name: “referrals.status_year”

Action Required: None


Client Model, HMIS Performance Model, Outreach Model


"Template Name" and "Template Status" are now available in the "Template Details" drop-down and added to the Program View.


New Fields: 

  • “Template Name”
    • Description: ”The name of the template. Corresponds to 'Program Name' in Clarity”
    • LookML Field Name: “program_templates.name”
  • “Template Status”
    • Description: “The status of the template screen”
    • LookML Field Name: “program_templates.status” 

HMIS Performance Model


The following Assessment Score fields in the “Client Assessments” view have been updated to display up to two decimal places: 

Field Name (LookML Field Name):

  • Assessment Score (client_assessment_scores.score)
  • Sub Score (client_assessment_scores.sub_score) 
  • Sub Score Family Unit (client_assessment_scores.sub_score_family_unit)
  • Sub Score General (client_assessment_scores.sub_score_general)
  • Sub Score Housing (client_assessment_scores.sub_score_housing)
  • Sub Score Risks (client_assessment_scores.sub_score_risks)
  • Sub Score Socialization (client_assessment_scores.sub_score_socialization)
  • Sub Score Wellness (client_assessment_scores.sub_score_wellness)
  • Highest Assessment Score (client_assessment_scores.assessment_score_max)

Outreach Model


The field "Is Last Boundary per Encampment" has been added to the 'Encampment Boundaries' View. The field will return "Yes" if an encampment boundary is the encampment's most recent recorded boundary in the system, "No" if not, and null if otherwise. 


New Fields: 

  • “Is Last Boundary per Encampment”
    • Description: “This is the latest Boundary per Encampment (based on date or ID if matching dates)”
    • LookML Field Name: “latest_encampment_boundary.is_latest_encampment_boundary”

Project Descriptor Model


A new field "Customer Portal Enabled" has been added to the "Agencies" view in the Project Descriptor Model. 


One New View has been added to the Project Descriptor Model with six new fields.  Three new fields have been added to the Project Descriptor model in the "Encampments" View. 


Dimensions "New Clarity Interface Last Switch" and "Clarity 2.0 Interface Last Switch" have been added to the "Staff" view for the Project Descriptor model. These "time" dimensions collect the last time the user switched to the Clarity 2.0 Interface or to the New Clarity Interface.



New Fields:

  • Customer Portal Enabled
    • Description: " Is the Customer Portal enabled for this agency? Toggle is located on the Customer Portal page in the agency's Sharing Settings. Agency settings inherit from System Settings for the Customer Portal by default. Customer portal may be enabled for all agencies on the Customer Portal page in System Settings."
    • LookML Field Name: “agencies.customer_portal_enabled”
  • Encampment Boundaries View
    • As Of Date
      • Description: "The Date and Time Input by the User that the Boundary was Reflected."
      • LookML Field Name: "encampment_boundaries_pdm.as_of_date"
    • Center Of Encampment
      • Description: "Geographic center of the encampment polygon. Shown as latitude, longitude"
      • LookML Field Name: "encampment_boundaries_pdm.polygon_center"
    • ID
      • Description: "Unique ID of the encampment boundary record."
      • LookML Field Name: "encampment_boundaries_pdm.id"
  • Map Layers View 
    • Description:
      • Description: "Description of the Map Layer."
      • LookML Field Name: "geo_fencings.description"
    • ID
      • Description: "Unique ID of the Map Layer"
      • LookML Field Name: "geo_fencings.id"
    • Group ID
      • Description: "ID of the Map Layer Group"
      • LookML Field Name: geo_fencing_groups_pdm.id 
    • Group Name
      • Description: "Name of the Map Layer Group"
      • LookML Field Name: "geo_fencing_groups_pdm.name"
    • Name
      • Description: "Name of the Map Layer"
      • LookML Field Name: geo_fencings.name
    • Status Text
      • Description: "Status of the Map Layer group (Active/Inactive)"
      • LookML Field Name: "geo_fencing_groups_pdm.status_text"
  • Staff View
    • New Clarity Interface Last Switch Date
      • Description: “Last time the user switched to the New Clarity Interface”
      • LookML Field Name: members.new_clarity_last_switch_date
    • New Clarity Interface Last Switch Month
      • Description: “Last time the user switched to the New Clarity Interface”
      • LookML Field Name: “members.new_clarity_last_switch_month”
    • New Clarity Interface Last Switch Quarter
      • Description: “Last time the user switched to the New Clarity Interface”
      • LookML Field Name: “members.new_clarity_last_switch_quarter”
    • New Clarity Interface Last Switch Time
      • Description: “Last time the user switched to the New Clarity Interface”
      • LookML Field Name: members.new_clarity_last_switch_time
    • New Clarity Interface Last Switch Week
      • Description: “Last time the user switched to the New Clarity Interface”
      • LookML Field Name: members.new_clarity_last_switch_week
    • New Clarity Interface Last Switch Year
      • Description: “Last time the user switched to the New Clarity Interface”
      • LookML Field Name: members.new_clarity_last_switch_year
    • Clarity 2.0 Interface Last Switch Date
      • Description: “Last time the user switched to the Clarity 2.0 Interface”
      • LookML Field Name: “members.clarity_20_last_switch_date”
    • Clarity 2.0 Interface Last Switch Month
      • Description: “Last time the user switched to the Clarity 2.0 Interface”
      • LookML Field Name: “members.clarity_20_last_switch_month”
    • Clarity 2.0 Interface Last Switch Quarter
      • Description: “Last time the user switched to the Clarity 2.0 Interface”
      • LookML Field Name: “members.clarity_20_last_switch_quarter”
    • Clarity 2.0 Interface Last Switch Time
      • Description: “Last time the user switched to the Clarity 2.0 Interface”
      • LookML Field Name: “members.clarity_20_last_switch_time”
    • Clarity 2.0 Interface Last Switch Week
      • Description: “Last time the user switched to the Clarity 2.0 Interface”
      • LookML Field Name: “members.clarity_20_last_switch_year”
    • Clarity 2.0 Interface Last Switch Year
      • Description: “Last time the user switched to the Clarity 2.0 Interface”
      • LookML Field Name: “members.clarity_20_last_switch_year”