Release Notes
      Back to home
      1. Clarity Human Services Help Center
      2. Data Analysis
      3. Release Notes

      Data Analysis Release Notes 3/25/2024

      Release Notes Summary

      The changes outlined here will be released to Looker training instances on 03/11/2024 and production instances on 03/25/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.

      There may be changes to this article until the release date. 

      Client Model

      • A new view “Upcoming Referral Statuses” has been added. This view shows the scheduled statuses of referrals and the added and scheduled dates of the statuses.
      • New fields "Scheduled" and "Canceled" have been added in the Referrals view and "Scheduled" has been added in the Referral History View.

      Coordinated Entry Model

      • A new view “Upcoming Referral Statuses” has been added. This view shows the scheduled statuses of referrals and the added and scheduled dates of the statuses.
      • New fields "Scheduled" and "Canceled" have been added in the Referrals view and "Scheduled" has been added in the Referral History View.

      Data Quality Model

      • The field "Head of Household Project Start Date" in the "DQ Annual Assessments" view has been changed to a dimension group. The field has also been refactored so that the "Head of Household Project Start Date" is not null when clients do not have an upcoming Annual Assessment due. 

      Detailed Changes

      Client Model

      • A new view “Upcoming Referral Statuses” has been added.
        The following new fields have been added in this view
        • "Agency ID": Agency ID of User Creating Home Agency
          • Field Name - "upcoming_referral_statuses.ref_user_home_agency" 
        • "Canceled": Was the Scheduled Referral Status Canceled?
          • Field Name - "upcoming_referral_statuses.canceled"
        • "Denied By Type": The Party who Scheduled the Referral to be Denied. Either the Client or the Provider.
          • Field Name - "upcoming_referral_statuses.denied_by_type"
        • "Denied Message": Notes Added to the Referral Scheduled to be Denied.
          • Field Name - "upcoming_referral_statuses.denied_message"
        • "Denied Reason": The Reason a Referral is Scheduled to be Denied.
          • Field Name - "upcoming_referral_statuses.denied_reason"
        • "Opening ID": The ID of the Scheduled, Referred to Program Opening.
          • Field Name - "upcoming_referral_statuses.ref_opening"
        • "Program ID": ID of the Scheduled Refer to Program
          • Field Name - "upcoming_referral_statuses.ref_program"
        • "Queue": Is the Scheduled Denied Referral Scheduled to be Returned to a Community Queue? 
          • Field Name - "upcoming_referral_statuses.queue"
        • "Queue ID": The ID of the Queue the Referral is Connected to.
          • Field Name - "upcoming_referral_statuses.ref_queue"
        • "Reassigned": Is the Referral Scheduled to be Reassigned to a Program?
          • Field Name - "upcoming_referral_statuses.reassigned"
        • "Status": The Upcoming Status of a Referral.
          • Field Name - "upcoming_referral_statuses.status"
        • "User Creating": The Name of the Staff who Created the Upcoming Referral Status.
          • Field Name - "upcoming_referral_statuses.ref_user_text"
        • "Count": Count of Upcoming Referral Statuses
          • Field Name: "upcoming_referral_statuses.count"
      • The following new fields have been added in the "Referrals View"
        • "Canceled" - Was the referral scheduled and canceled?
          • Field Name - "referrals.canceled"
        • "Scheduled" - Is the referral scheduled?
          • Field Name - "referrals.is_upcoming"
      • The following new fields have been added in the "Referral History View"
        • "Scheduled": Was the Referral Scheduled
          • Field Name - "referral_history.is_upcoming"

      Coordinated Entry Model

      • A new view “Upcoming Referral Statuses” has been added.
        The following new fields have been added in this view
        • "Agency ID": Agency ID of User Creating Home Agency
          • Field Name - "upcoming_referral_statuses.ref_user_home_agency" 
        • "Canceled": Was the Scheduled Referral Status Canceled?
          • Field Name - "upcoming_referral_statuses.canceled"
        • "Denied By Type": The Party who Scheduled the Referral to be Denied. Either the Client or the Provider.
          • Field Name - "upcoming_referral_statuses.denied_by_type"
        • "Denied Message": Notes Added to the Referral Scheduled to be Denied.
          • Field Name - "upcoming_referral_statuses.denied_message"
        • "Denied Reason": The Reason a Referral is Scheduled to be Denied.
          • Field Name - "upcoming_referral_statuses.denied_reason"
        • "Opening ID": The ID of the Scheduled, Referred to Program Opening.
          • Field Name - "upcoming_referral_statuses.ref_opening"
        • "Program ID": ID of the Scheduled Refer to Program
          • Field Name - "upcoming_referral_statuses.ref_program"
        • "Queue": Is the Scheduled Denied Referral Scheduled to be Returned to a Community Queue? 
          • Field Name - "upcoming_referral_statuses.queue"
        • "Queue ID": The ID of the Queue the Referral is Connected to.
          • Field Name - "upcoming_referral_statuses.ref_queue"
        • "Reassigned": Is the Referral Scheduled to be Reassigned to a Program?
          • Field Name - "upcoming_referral_statuses.reassigned"
        • "Status": The Upcoming Status of a Referral.
          • Field Name - "upcoming_referral_statuses.status"
        • "User Creating": The Name of the Staff who Created the Upcoming Referral Status.
          • Field Name - "upcoming_referral_statuses.ref_user_text"
        • "Count": Count of Upcoming Referral Statuses
          • Field Name: "upcoming_referral_statuses.count"
      • The following new fields have been added in the "Referrals View"
        • "Canceled" - Was the referral scheduled and canceled?
          • Field Name - "referrals.canceled"
        • "Scheduled" - Is the referral scheduled?
          • Field Name - "referrals.is_upcoming"
      • The following new fields have been added in the "Referral History View"
        • "Scheduled": Was the Referral Scheduled
          • Field Name - "referral_history.is_upcoming"

      Data Quality Model

      • The following fields' Looker field name has been updated in the "DQ Annual Assessments" View
        • "Head of Household Start Date": Start date of the head of household associated with the enrollment 
          • Field name: "dq_annual_assessments.head_of_household_project_start_date" has changed to "dq_annual_assessments_hoh_start_date.head_of_household_project_start_date"
      • The following new fields have been added in the "DQ Annual Assessments" View
        • "Head of Household Start Week": Start week of the head of household associated with the enrollment
          • Field name: "dq_annual_assessments_hoh_start_date.head_of_household_project_start_week"
        • "Head of Household Start Month": Start month of the head of household associated with the enrollment
          • Field name: "dq_annual_assessments_hoh_start_date.head_of_household_project_start_month"
        • "Head of Household Start Quarter": Start quarter of the head of household associated with the enrollment
          • Field name: "dq_annual_assessments_hoh_start_date.head_of_household_project_start_quarter"
        • "Head of Household Start Year": Start year of the head of household associated with the enrollment
          • Field name: "dq_annual_assessments_hoh_start_date.head_of_household_project_start_year"

      Required Action:  

      Check any content using "dq_annual_assessments.head_of_household_project_start_date". If needed, update to use "dq_annual_assessments_hoh_start_date.head_of_household_project_start_date".