2024 Data Standards

02-06-2023 Release Notes

Release Notes Summary:

Client Model: 

  • Improved performance for Assessing Programs
  • Programs COC locations fields updated to show only primary site information
  • 3 New “Is First Assessment fields”

Coordinated Entry Model:

  • Improved performance for Assessing Programs
  • Programs COC locations fields updated to show only primary site information
  • 3 New “Is First Assessment fields”

Data Quality Model

  • Programs COC locations fields updated to show only primary site information

HMIS Performance:

  • Improved performance for Assessing Programs
  • Programs COC locations fields updated to show only primary site information
  • 3 New “Is First Assessment fields”

Inventory Model:

  • Added location fields to the Sites View

Outreach Model:

  • Added Geolocation Mapping Type
  • Removed Geolocations:Type (Yes/No)

Population Over Time Model:

  • Programs COC locations fields updated to show only primary site information

Project Descriptor Model:

  • Programs COC locations fields updated to show only primary site information

Services Model

  • Programs COC locations fields updated to show only primary site information
  • 3 New “Is First Assessment fields”


Client Model


A fix was made to back-end tables to improve performance for queries using the fields "Assessing Programs Enrollment ID" and "Assessing Program" in the Client Assessments View. 


The location fields in "CoC Information" under the Programs view have been limited to the primary site address assigned to the program in accordance with the HUD Data Dictionary Element 2.03.  All other sites associated with the program can be found in the Program Sites view. In this section field names have changed as below: 

  • programs_geolocations.address -> primary_programs_geolocations.address
  • programs_geolocations.city -> primary_programs_geolocations.city

Three new fields for 'Is First Assessment...' have been added. - 'Is First Assessment by Processor', 'Is First Assessment per Client’, 'Is First Assessment of Kind'. ‘Is First Assessment by Processor’ returns the first assessment for a client that used a particular Assessment Processor. ‘Is First Assessment per Client’ returns a client’s first assessment for all time regardless of the filters applied in the explore. `Is First Assessment of Kind’ returns the first assessment for a client that used that type of assessment.  - These fields will be persisted for 30 mins after they are run to improve efficiency.

Action Required: 

  • Any looks filtering on the Programs: CoC Information fields or using these fields in custom fields will need to be updated
  • The Support Team can help identify content that needs to be updated

 

Coordinated Entry Model

A fix was made to back-end tables to improve performance for queries using the fields "Assessing Programs Enrollment ID" and "Assessing Program" in the Client Assessments View. 

The location fields in the "CoC Information" under the Programs view have been limited to the primary site address assigned to the program in accordance with the HUD Data Dictionary element 2.03.  All other sites associated with the program can be found in the Program Sites view. In this section field names have changed as below: 

  • programs_geolocations.address -> primary_programs_geolocations.address
  • programs_geolocations.city -> primary_programs_geolocations.city

Three new fields for 'Is First Assessment...' have been added. - 'Is First Assessment by Processor', 'Is First Assessment per Client’, 'Is First Assessment of Kind'.  ‘Is First Assessment by Processor’ returns the first assessment for a client that used a particular Assessment Processor. ‘Is First Assessment per Client’ returns a client’s first assessment for all time regardless of the filters applied in the explore. `Is First Assessment of Kind’ returns the first assessment for a client that used that type of assessment. - These fields will be persisted for 30 mins after they are run to improve efficiency.

Action Required: 

  • Any looks filtering on the Programs: CoC Information fields or using these fields in custom fields will need to be updated
  • The Support Team can help identify content that needs to be updated

 

Data Quality Model

The location fields in the "CoC Information" under the Programs view have been limited to the primary site address assigned to the program in accordance with the HUD Data Dictionary element 2.03.  All other sites associated with the program can be found in the Program Sites view. In this section field names have changed as below: 

  • programs_geolocations.address -> primary_programs_geolocations.address
  • programs_geolocations.city -> primary_programs_geolocations.city

Action Required: 

  • Any looks filtering on the Programs: CoC Information fields or using these fields in custom fields will need to be updated
  • The Support Team can help identify content that needs to be updated

 

HMIS Performance Model

A fix was made to back-end tables to improve performance for queries using the fields "Assessing Programs Enrollment ID" and "Assessing Program" in the Client Assessments View. 

The location fields in the "CoC Information" under the Programs view have been limited to the primary site address assigned to the program in accordance with the HUD Data Dictionary element 2.03.  All other sites associated with the program can be found in the Program Sites view. In this section field names have changed as below: 

  • programs_geolocations.address -> primary_programs_geolocations.address
  • programs_geolocations.city -> primary_programs_geolocations.city

Three new fields for 'Is First Assessment...' have been added. - 'Is First Assessment by Processor', 'Is First Assessment per Client’, 'Is First Assessment of Kind'.  ‘Is First Assessment by Processor’ returns the first assessment for a client that used a particular Assessment Processor. ‘Is First Assessment per Client’ returns a client’s first assessment for all time regardless of the filters applied in the explore. `Is First Assessment of Kind’ returns the first assessment for a client that used that type of assessment. - These fields will be persisted for 30 mins after they are run to improve efficiency.

Action Required: 

  • Any looks filtering on the Programs: CoC Information fields or using these fields in custom fields will need to be updated
  • The Support Team can help identify content that needs to be updated

 

Inventory Model

The Inventory Model has been updated to include location fields under the "Sites" view, in a sub-group called "Location".  The added fields include "Address", "Address 2", "City", "Full Geolocation", "Geocode", "State", and "Zip Code".  customer.

Action Required: 

None

 

Outreach Model (Beta)

The dimension 'Geolocation Mapping Type' has been added to the Outreach Model, under the 'Geolocations' view label.  This dimension lists the data collection point for the geolocation data. The Geolocations: Type(yes/no) field - outreach_geolocations.type has been removed. This field was confusing and did not give any additional data.

Action Required: 

Any looks using the Geolocations:Type (yes/no) field should be updated.

  • The Support Team can help identify content that needs to be updated

 

Population over Time Model

The location fields in the "CoC Information" under the Programs view have been limited to the primary site address assigned to the program in accordance with the HUD Data Dictionary element 2.03.  All other sites associated with the program can be found in the Program Sites view. In this section field names have changed as below: 

  • programs_geolocations.address -> primary_programs_geolocations.address
  • programs_geolocations.city -> primary_programs_geolocations.city

Action Required: 

  • Any looks filtering on the Programs: CoC Information fields or using these fields in custom fields will need to be updated
  • The Support Team can help identify content that needs to be updated

 

Project Descriptor Model

The location fields in the "CoC Information" under the Programs view have been limited to the primary site address assigned to the program in accordance with the HUD Data Dictionary element 2.03.  All other sites associated with the program can be found in the Program Sites view. In this section field names have changed as below: 

  • programs_geolocations.address -> primary_programs_geolocations.address
  • programs_geolocations.city -> primary_programs_geolocations.city

Action Required: 

  • Any looks filtering on the Programs: CoC Information fields or using these fields in custom fields will need to be updated
  • The Support Team can help identify content that needs to be updated

 

Services Model

The location fields in the "CoC Information" under the Programs view have been limited to the primary site address assigned to the program in accordance with the HUD Data Dictionary element 2.03.  All other sites associated with the program can be found in the Program Sites view. In this section field names have changed as below: 

  • programs_geolocations.address -> primary_programs_geolocations.address
  • programs_geolocations.city -> primary_programs_geolocations.city

Three new fields for 'Is First Assessment...' have been added. - 'Is First Assessment by Processor', 'Is First Assessment per Client’, 'Is First Assessment of Kind'.  ‘Is First Assessment by Processor’ returns the first assessment for a client that used a particular Assessment Processor. ‘Is First Assessment per Client’ returns a client’s first assessment for all time regardless of the filters applied in the explore. `Is First Assessment of Kind’ returns the first assessment for a client that used that type of assessment. - These fields will be persisted for 30 mins after they are run to improve efficiency.

Action Required: 

  • Any looks filtering on the Programs: CoC Information fields or using these fields in custom fields will need to be updated
  • The Support Team can help identify content that needs to be updated

Updated: 1/31/2023