2024 Data Standards

November 2021 Change Log

  • 11/29/2021 - The client_demographics.gender_json field was retired from the Customer SQL Model. It has been replaced by client_demographics.gender field.
  • 11/29/2021 - Exposed new field  "Community Queue Status" in the project descriptor model in line with Clarity update.
  • 11/23/2021 - Made updates to "Latest release of information"  to improve performance, updated Program Sites in HMIS Performance to improve accuracy, and corrected Community Queue reporting under Programs in the Project Descriptor model.
  •  11/22/2021 - New System Performance measures have been released. 
  • 11/19/2021 - Looker updated from version 21.12 to 21.16.  See Release Notes on Looker's website. Completed.
  • 11/16/2021 - Updated incorrect field type for RHY fields "Number sessions planned" and "Number sessions "Received". Primary keys added to correct issue in Entry Screen Total Adults Measure.
  • 11/12/2021 - Planned release.  See Release notes
  • 11/11/2021 - Update to "Is Latest Service Based on Enrollment" and updated join in HMIS performance to remove deleted data.
  • 11/10/2021 - Updates to "Is Latest ROI Systemwide?" and "Active ROI?" dimensions.
  • 11/8/2021 - Some Looker items scheduled for release on 2021-11-12 were mistakenly released on 2021-11-05.
  • 11/8/2021 9:30 PM PT - Short (10m) Looker outage to increase resources
  • 11/5/2021 - Updated Lookml dashboards:LSA Data Cleanup: Funding Source and Configuration and LSA Data Cleanup: Project Descriptor and Utilization to improve functionality.
  • 11/4/2021 5:00 AM PDT - Increased Looker network capacity from 10gbps to 25gbps.
  • 11/3/2021 - Outbound recidivism dimensions have been updated to take the HoH's move in date into consideration instead of the individual client's move in date.
  • 11/1/2021 - Updated Data Models to support Clarity Human Services update.
    • Replaced references to `gender_json` with `gender` in  all views using gender.  Will not affect any existing content except for possibly API connections.
    • CSV Export Model: A join has been updated to improve performance to service expenses.