2024 Data Standards

2/28/2022 Release Notes

The following changes will be implemented in the data analysis tool, effective 2/28/2022. There may be changes to this article until the release date

Data Analysis Important Note

We will be making the following updates to embedded data analysis:

  1. Embedded users will no longer have the ability to schedule looks and dashboards.
  2. Embedded users without "Data Analysis Save" will lose the option to save.

General Changes

  • Added Prior State and Zipcode fields in the Client Assessments View in HMIS Performance, CE and Client Models.
  • The logic of ever_on_queue and referral_method dimensions has been updated to improve accuracy.

Services Model

  • Program CoC code added to the Programs View in the Services model.

CSV Export (BETA) Model

  • Refactored ID and UserID in Services in the HUD CSV Export model to match HUDX-111 Export.
  • Refactored LivingSituation, LOSUnderThreshold, and UserID in HUD CSV Export (BETA) model to match HUDX-111 Export.
  • Refactored Event > EventsID, ReferralCaseManageAfter, and ProbSolDivRRResult in the HUD CSV Export (BETA) model to match HUDX-111 Export.
  • Refactored Project CoC IDs, Geocode to match HUDX-111 Export.
  • Refactored csv_assessment view to accurately reflect values and HUDX-111 Export.

Backend SQL Updates

Added the following fields to customer's database schemas.

View Name Column Name Change Data Type
client_assessment_demographics health_dv added int
client_service_members id added int
client_service_members ref_client_service added int
client_service_members ref_service_item added int
client_service_members ref_member added int
users added_date added datetime