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

      Data Analysis Release Notes 4/22/2024

      Release Notes Summary

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

      LookML Dashboards

      We are excited to announce the release of a new Inventory Module LookML dashboard.

      Updated Looks on the following LookML Dashboards

      • Data Quality Dashboard
      • HMIS Data Quality Supplemental Dashboard
      • Program Performance

      Data Quality Model

      Improvements made to the "Targeted Annual Assessment" View. 

      Outreach V2 Model

      We are excited to announce a new version of the outreach model. This has been created as a new model to incorporate the new data schema and functionality recently released in Clarity Human Services.

      Project Descriptor Model

      • Added a new field "Encampment System Agency" in the "Agencies" View.
      • Added a new "Encampment Categories" view.
      • Added new fields "Agency Name", "User Created", and "User Updated"  to the "Encampments" view.

      Detailed Changes

      LookML Dashboards

      We are excited to announce the release of a new Inventory Module LookML dashboard. It breaks down units and beds by status and availability. This dashboard is designed to analyze inventory configurations with programs linked through the unit configuration and can be used as a template for inventory-based data analytics.

      Updates to existing LookML Dashboards

      • Data Quality Dashboard

        • Annual Assessment Issues

          • Look updated to identify all annual assessment issues for enrollments active during the reporting period

        • Annual Assessment Status Overview

          • Look updated to identify all annual assessment statuses for enrollments active during the reporting period

      • HMIS Data Quality Supplemental Dashboard

        • Q4: Income and Housing Data Quality Issue Count

          • Look updated to identify enrollments active during the reporting period with any annual assessment completion issues.

          • Annual assessment completion issues include past due annual assessments, enrollments with no targeted annual assessment dates, annual assessments completed out of range, and enrollments where the client has a project start date before the head of household project start date.

        • Q4: Annual Assessment Completion Issue Client Details

          • Look updated to identify enrollments active during the reporting period with any annual assessment completion issues.

          • Annual assessment completion issues include past due annual assessments, enrollments with no targeted annual assessment dates, annual assessments completed out of range, and enrollments where the client has a project start date before the head of household project start date.

        • Q5: Chronic Homelessness 
          • Updated Client Universe

      • Program Performance

        • Annual Assessment Compliance

          • Look updated to identify the percentage of enrollments active during the reporting period without any annual assessment completion issues.

          • Annual assessment completion issues include past due annual assessments, enrollments with no targeted annual assessment dates, annual assessments completed out of range, and enrollments where the client has a project start date before the head of household project start date.

        • Annual Assessment Status Overview

          • Look updated to identify what sort of annual assessment completion issues enrollments active during the reporting period are experiencing.

      Action Required: None.

      Data Quality Model

      The field "Targeted Annual Assessment" in the "DQ Annual Assessments" view no longer filters out Targeted Annual Assessments that occurred prior to the start date selected in the Reporting Period Filter. All anniversary dates between the start date of a client's enrollment and either the end date of their enrollment or the current date will be displayed when this field is selected. 

      Action Required: None.

      Outreach v2 Model

      In the April release we are excited to announce a new version of the outreach model. This has been created as a new model to incorporate the new data schema and functionality recently released in Clarity Human Services. Newly refactored database tables have enabled us to remove non performant derived tables and add in the latest features. We were unable to update the original version due to the scope of the changes. The URL for the new model will be "outreach_v2"

      We understand that  creating a completely new model will cause  some additional required action on the part of customers to rebuild content and we therefore intend to keep both outreach models available for 2 months at which time we will remove the original version and rename the URL for the new model to “outreach”.

      Below is a list of new and updated views in the Outreach 2024 model with field names and descriptions, and some before and after Explores to help in mapping existing reports to the new model. Link to existing article.

      We anticipate further development of this new model later in the year as the Clarity functionality continues to develop.

      • New View - Client Housed Dates.
        • This View contains fields that relate to the Sheltered/Housed/Deceased icons in the map in Clarity. The  fields in this view enable users to see the date and information around the event which caused the icon to show. See this page for more information on these icons.
      DIMENSIONS
        • Added Date
          • The date the 'Client Housed Date' record was added.
          • Field name: "client_housed_dates.added_date"
        • Client Service ID
          • Unique identifier for Service transaction associated with the 'Client Housed Date' record.
          • Field name: "client_housed_dates.ref_client_service"
        • Enrollment ID
          • The ID of the Enrollment associated with the 'Client Housed Date' record.
          • Field name: "client_housed_dates.ref_client_program"
        • ID
          • Unique ID of the 'Client Housed Date' record.
          • Field name: "client_housed_dates.id"
        • Information Date
          • Date Client was housed.
          • Field name: "client_housed_dates.date_date"
        • Information Month
          • Field name: "client_housed_dates.date_month"
        • Information Quarter
          • Field name: "client_housed_dates.date_quarter"
        • Information Time
          • Field name: "client_housed_dates.date_time"
        • Information Week
          • Field name: "client_housed_dates.date_week"
        • Information Year
          • Field name: "client_housed_dates.date_year"
        • Program ID
          • ID of Program associated with the 'Client Housed Date' record.
          • Field name: "client_housed_dates.ref_program"
        • Program Name
          • Name of Program associated with the 'Client Housed Date' record.
          • Field name: "client_housed_dates.ref_program_text"
        • Screen Type
          • The type of Enrollment screen (Entry/Exit/Update/Followup) associated with the 'Client Housed Date' record.
          • Field name: "client_housed_dates.ref_client_program_demographics_screen_type"
        • Service ID
          • ID of the Service associated with the 'Client Housed Date' record.
          • Field name: "client_housed_dates.ref_service"
        • Service Item ID
          • ID of the Service Item associated with the 'Client Housed Date' record.
          • Field name: "client_housed_dates.ref_service_item"
        • Service Name
          • Name of the Service associated with the 'Client Housed Date' record.
          • Field name: "client_housed_dates.ref_service_name"
        • Type of Client Housed Date
          • The type of date identified as the Client Housed Date.
          • Field name: "client_housed_dates.type_text"Type of Client Housed Date"
      MEASURES
        • Count
          • Number of 'Client Housed Date' records.
          • Field name: "client_housed_dates.count"
      • New View - Encampment Categories 
        • This view contains fields relating  to the new encampment Categories functionality in Clarity.
      DIMENSIONS
        • Creating Agency Name
          • The name of the agency that created the Encampment Category.
          • Field name: “outreach_encampment_categories.ref_agency_text”
        • Creating User Name
          • The name of the user that created the Encampment Category.
          • Field name: “outreach_encampment_categories.ref_user_text”
        • Date Created Date
          • The date the Encampment Category was created.
          • Field name: "outreach_encampment_categories.added_date"
        • Date Created Month
          • Field name: "outreach_encampment_categories.added_month"
        • Date Created Quarter
          • Field name: "outreach_encampment_categories.added_quarter"
        • Date Created Time
          • Field name: "outreach_encampment_categories.added_time"
        • Date Created Week
          • Field name: "outreach_encampment_categories.added_week"
        • Date Created Year
          • Field name: "outreach_encampment_categories.added_year"
        • Date Updated  Date
          • The date the Encampment Category was Updated.
          • Field name: "outreach_encampment_categories.last_updated_date"
        • Date  Updated Month
          • Field name: "outreach_encampment_categories.last_updated__month"
        • Date  Updated Quarter
          • Field name: "outreach_encampment_categories.last_updated__quarter"
        • Date  Updated Time
          • Field name: "outreach_encampment_categories.last_updated__time"
        • Date  Updated Week
          • Field name: "outreach_encampment_categories.last_updated__week"
        • Date  Updated Year
          • Field name: "outreach_encampment_categories.last_updated_year"
        • ID
          • The unique ID of the Encampment Category.
          • Field name: "outreach_encampment_categories.id"
        • Name
          • The name of the Encampment Category.
          • Field name: "outreach_encampment_categories.name"
        • Status
          • Whether the Encampment Category is active or inactive.
          • Field name: "outreach_encampment_categories.status_text"
        • Updating Agency Name
          • The name of the agency that last updated the Encampment Category.
          • Field name: "outreach_encampment_categories.ref_agency_updated_text"
        • Updating User Name
          • The name of the user that last updated the Encampment Category.
          • Field name: "outreach_encampment_categories.ref_user_updated_text"
      • Updated - Encampment Stays View 
        • This view has been refactored to remove the derived tables and logic that were previously used to calculate the dates and information around encampment stays. It has been simplified as it now joins easily with the existing Clients and  Encampments views. The logic around encampment stays has changed. The end date of an encampment stay is now determined by the time threshold in the Outreach Settings or the date of a new encampment stay, whichever is earlier.  If a client has another interaction within the same Encampment within the time threshold, this will prolong the stay to the latest location date plus the time threshold.
      FILTER-ONLY FIELDS
        • Encampment Stay Date Filter
          • ("End Date" is greater than or equal to  "Encampment Stay Date Filter start date"
            OR "End Date" is null)
            AND "Start Date" is less than or equal to "Encampment Stay Date Filter end date".
            Requires two "dates" to set the filter. If an Absolute Date Filter is used (ie. "Is on or after") The date entered will be applied to the Encampment Stay Date Filter end date.
          • Field name: "geolocation_encampment_history.date_filter"
      DIMENSIONS
        • Client Active
          • Clients who are most likely still active in an encampment. The "Start Date" of a client's stay in an Encampment is the date an outreach worker records a client location within the respective encampment. The "End Date" of a client's encampment stay is set by the time threshold in the outreach settings. If a client has another interaction within the same Encampment within the time threshold, this will prolong the stay to the latest location date plus the time threshold. Thus, a client's stay duration is extended by each recorded encounter by an outreach worker. If a client has multiple interactions in different encampments on the same day, only the latest will be considered, as it is assumed this is where the client slept. Refer to "HMIS Reporting Glossary" section "Q7. Inactive Records: Street Outreach & Emergency Shelter."
          • Field name: "geolocation_encampment_history.active"
        • Days Client Active
          • The number of days between a client's "Start Date" and "End Date" in an Encampment. If "End Date" is null, the current date is used.
          • Field name: "geolocation_encampment_history.days_active"
        • Days Client Active During the Encampment Stay Reporting Period
          • The number of days between a client's "Start Date" and "End Date" in an Encampment for days within the Encampment Stay Reporting Period. If the reporting period is set to 'is before' the calculation will be based on days between 'Client Start Date' and 'Client End Date' or 'Encampment Stay Filter End Date', whichever comes first. If the reporting period is set to 'on or after' the calculation will be based on days between 'Client Start Date' or 'Encampment Stay Filter Start Date', which is later, and the 'Client End Date' or current date if 'Client End Date' is null. If reporting filter is not included or is set to 'is any time', the 'Estimated Days Client Active During the Reporting Period' will be equivalent to 'Estimated Total Days Client Active'.
          • Field name: "geolocation_encampment_history.days_active_during_reporting_period"
        • Encampment Stay Filter End Date
        • Encampment Stay Filter Start Date
          • The Start Date in the 'Encampent Stay Date Filter'
          • Field name: "geolocation_encampment_history.encampment_stay_filter_start_date"
        • End Date
          • The end date of the encampment stay
          • Field name: "geolocation_encampment_history.end_date"
        • End Month
          • Field name: "geolocation_encampment_history.end_month"
        • End Quarter
          • Field name: "geolocation_encampment_history.end_quarter"
        • End Time
          • Field name: "geolocation_encampment_history.end_time"
        • End Week
          • Field name: "geolocation_encampment_history.end_week"
        • End Year
          • Field name: "geolocation_encampment_history.end_year"
        • Is Current/Latest Encampment
          • Flags a client's stay as the most recent one in history. The "Start Date" of a client's stay in an Encampment is the date an outreach worker records a client location within the respective encampment. The "End Date" of a client's encampment stay is 90-days after the last recorded interaction within the respective Encampment. If a client has another interaction within the same Encampment within 90-days, this will prolong inactivity. Thus, a client's stay duration is extended by each recorded encounter by an outreach worker. If a client has multiple interactions in different encampments on the same day, only the latest will be considered, as it is assumed this is where the client slept. Refer to "HMIS Reporting Glossary" section "Q7. Inactive Records: Street Outreach & Emergency Shelter."
          • client_last_encampment_stay.is_latest_encampment_stay
        • Start Date
          • Start date of the encampment stay
          • Field name: "geolocation_encampment_history.start_date"
        • Start Month
          • Field name: "geolocation_encampment_history.start_month"
        • Start Quarter
          • Field name: "geolocation_encampment_history.start_quarter"
        • Start Time
          • Field name: "geolocation_encampment_history.start_time"
        • Start Week
          • Field name: "geolocation_encampment_history.start_week"
        • Start Year
          • Field name: "geolocation_encampment_history.start_year"
      • Updated - Enrollments
        • The join to this view has been updated to be a dynamic join. A different join was needed for Enrollments in Encampment Programs and Enrollments in Outreach Programs. The Enrollments Link Filter was created so the user can choose to include outreach programs (those with geolocations on a current living situation assessment screen), encampment programs or all programs in their explore. The default is set to encampment program enrollments. The filter is required and should remain set to the default if enrollments are not being included in the explore. When enrollment data is not included the filter will still be present but will not impact the data.
        • Enrollments Link Filter
          • This filter allows you to select which enrollments will be included. The options are "Current Living Situation", "Encampment Programs", and "Clients". If "Current Living Situation" is selected, only enrollments where geolocations have been recorded on current living situations will be included. If "Encampment Programs" is selected, only encampment program enrollments will be included. If "Clients" is selected, all enrollments will be included.
          • Field name: "outreach_client_programs.outreach_enrollments_join"
        • Enrollment ID
          • Field name change: "enrollments.id" -> "outreach_client_programs.id"
        • Project Exit Date
          • Field name change: "enrollments.end_date" -> "outreach_client_programs.end_date"
        • Project Exit Month
          • Field name change: "enrollments.end_month" -> "outreach_client_programs.end_month"
        • Project Exit Quarter
          • Field name change: "enrollments.end_quarter" -> "outreach_client_programs.end_quarter"
        • Project Exit Week
          • Field name change: "enrollments.end_week" -> "outreach_client_programs.end_week"
        • Project Exit Year
          • Field name change: "enrollments.end_year" -> "outreach_client_programs.end_year"
        • Project Start Date
          • Field name change "enrollments.start_date" -> "outreach_client_programs.start_date"
        •  Project Start Month
          • Field name change "enrollments.start_month" -> "outreach_client_programs.start_month"
      • New View - Geolocation History
        • This view contains fields which enable users to see the  geolocation history for a client including individual and encampment geolocations.
      DIMENSIONS
        • Added Date 
          • The date the history record was added.
          • Field name: "geolocation_history.added_date"
        • Added Month 
          • Field name: "geolocation_history.added_month"
        • Added Quarter 
          • Field name: "geolocation_history.added_quarter"
        • Added Time 
          • Field name: "geolocation_history.added_time"
        • Added Week 
          • Field name: "geolocation_history.added_week"
        • Added Date 
          • Field name: "geolocation_history.added_date"
        • End Date
          • The End of the geolocation period. If the geolocation is an encampment stay the end date is determined by the time threshold in the outreach settings.
          • Field name: "geolocation_history.end_date"
        • End Month
          • Field name: "geolocation_history.end_month"
        • End Quarter
          • Field name: "geolocation_history.end_quarter"
        • End Time
          • Field name: "geolocation_history.end_time"
        • End Week
          • Field name: "geolocation_history.end_week"
        • End Year
          • Field name: "geolocation_history.end_year"
        • ID
          • The Unique ID of the Geolocation History record.
          • Field name: "geolocation_history.id"
        • Start Date
          • The start date of the geolocation period.
          • Field name: "geolocation_history.start_date"
        • Start Month
          • Field name: "geolocation_history.start_month"
        • Start Quarter
          • Field name: "geolocation_history.start_quarter"
        • Start Time
          • Field name: "geolocation_history.start_time"
        • Start Week
          • Field name: "geolocation_history.start_week"
        • Start Year
          • Field name: "geolocation_history.start_year"
      MEASURES
        • Count
          • Count of Geolocation History records.
          • Field name: "geolocation_history.count"
      • Updated - Map Layers
        • Hid the following dimensions
          • User Created ID
            • Field name: "outreach_geo_fencings.ref_user"
          • User Updated ID
            • Field name: "outreach_geo_fencings.ref_user_updated"
        • Renamed the following dimensions
          • User Created Name changed to  User Created
            • Field name: "outreach_geo_fencings.ref_user_name"
          • User Updated Name changed to User Updated
            • Field name: "outreach_geo_fencings.ref_user_updated_name"
      • New  View - Outreach Settings
        • This View contains the fields in the outreach settings that are most relevant to analysis of clients in encampments. A full list of configuration fields will be included in the Project Descriptor Model.
      DIMENSIONS
      • Added Date
        • The date the Outreach Settings Record was Added.
        • Field name: "outreach_settings.added_date"
      • Added Month
        • Field name: "outreach_settings.added_month"
      • Added Quarter
        • Field name: "outreach_settings.added_quarter"
      • Added Time
        • Field name: "outreach_settings.added_time"
      • Added Week
        • Field name: "outreach_settings.added_time"
      • Added Year
        • Field name: "outreach_settings.added_year"
      • CoC
        • The CoC of the Outreach Settings. The agency the user is logged into determines the Outreach setting they are within. If a specific CoC does not have an unique Outreach setting configured, then they fall into the 'Default' Outreach Setting with those Outreach Filters. If a CoC has their own unique Outreach setting configured, they follow those Outreach filters. Encampments are visible and usable to all unless the Outreach setting has the 'Restrict to CoC' toggle enabled.
        • Field name: "outreach_settings.coc"
      • Encampment Program (Yes / No)
        • Are Encampment Programs Enabled in the Outreach Settings?
        • Field name: "outreach_settings.encampment_program"
      • Encampment Program Agency ID
        • ID of the Encampment Program Agency
        • Field name: "outreach_settings.encampment_program_ref_agency"
      • Encampment Program Agency Name
        • Name of the Encampment Program Agency
        • Field name: "outreach_settings.encampment_program_ref_agency_name"
      • ID
        • Unique ID of the Outreach Setting.
        • Field name: "outreach_settings.id"
      • Last Updated Date
        • The Date the Outreach Setting Record was last Updated.
        • Field name: "outreach_settings.last_updated_date"
      • Last Updated Month
        • Field name: "outreach_settings.last_updated_month"
      • Last Updated Quarter
        • Field name: "outreach_settings.last_updated_quarter"
      • Last Updated Time
        • Field name: "outreach_settings.last_updated_time"
      • Last Updated Week
        • Field name: "outreach_settings.last_updated_week"
      • Last Updated Year
        • Field name: "outreach_settings.last_updated_year"
      • Restrict by CoC (Yes / No)
        • Encampments are visible and usable to all unless the Outreach setting has the 'Restrict to CoC' toggle enabled.
        • Field name: "outreach_settings.restrict_by_coc"
      MEASURES
      • Count
        • A unique count of the number of outreach settings associated with an encampment.
        • Field name: "outreach_settings.count"
      • Update - Programs
        • The same fields are available in the programs model as in the prior version of the outreach model, but the LookML field names have changed. 

      DIMENSIONS

      • Name
        • Field name: "outreach_programs.name"
      • Program ID
        • Field name: "outreach_programs.id"
      • Project Type Code
        • Field name: "outreach_programs.project_type_code"
      • RRH Subtype
        • Field name: "outreach_programs.rrh_subtype"

      MEASURES

      • Count
        • Field name: "outreach_programs.count"

      Action Required:
      • All looks and dashboards created in the current version of the outreach model will need to be rebuilt in the new version. We plan to remove the original version in the June release 6/18/24 in order to keep excess code and duplication to a minimum.
      • In addition the new version will have the URL updated to "outreach" in the next release. This gives users the time to update reports but then ensures the latest version is kept current. 

      Project Descriptor Model


      • A new field "Encampment System Agency" is available in the "Agencies" View
        • The lookml fieldname for the field is "agencies.encampment_program". 
      • Added the Encampment Categories view. The new fields are 
        • Color
          • The code for the selected color of the Encampment Category.
          • Field name: "encampment_categories.color"
        • Creating Agency Name
          • The name of the agency that created the Encampment Category.
          • Field name: "encampment_categories.ref_agency_text"Creating Agency Name
        • Creating User Name
          • The name of the user that created the Encampment Category.
          • Field name: "encampment_categories.ref_user_text"
        • Date Created Date
          • The date the Encampment Category was created.
          • Field name: "encampment_categories.added_date"
        • Date Updated Date
          • The date the Encampment Category was last updated.
          • Field name: "encampment_categories.last_updated_date"
        • Deleted (Yes / No)
          • Has this Encampment Category been deleted?
          • Field name: "encampment_categories.deleted"
        • Deleting Agency Name
          • The name of the agency that deleted the Encampment Category.
          • Field name: "encampment_categories.ref_agency_deleted_text"
        • ID
          • The unique ID of the Encampment Category.
          • Field name: "encampment_categories.id"
        • Name
          • The name of the Encampment Category.
          • Field name: "encampment_categories.name"
        • Status
          • Whether the Encampment Category is active or inactive.
          • Field name: "encampment_categories.status_text"
        • Updating Agency Name
          • The name of the agency that last updated the Encampment Category.
          • Field name: "encampment_categories.ref_agency_updated_text"
        • Updating User Name
          • The name of the user that last updated the Encampment Category.
          • Field name: "encampment_categories.ref_user_updated_text"
             
      • Added  new fields to the Encampments view.
        • Agency Name
          • Name of the Agency that created the Encampment
          • Field name: "encampments.ref_agency_text"
        • User Created
          • Username of the User that created the Encampment
          • Field name: "encampments.ref_user_text"
        • User Updated
          • Username of the User that last updated the Encampment
          • Field name: "encampments.ref_user_updated_text"

      Action Required: None