HMIS Data Quality Tool - greenriver/hmis-warehouse GitHub Wiki

Description

A tool to track data quality across HMIS data used in HUD reports.

Universe

The HMIS Data Quality Tool uses the Additive Universe Selection.

Data Quality Checks for Assessments

  • Anniversary date is calculated from the Head of Household's entry date
  • Clients who are required to have annual assessments collected, are checked against the HoH anniversary date
  • Assessments are flagged as missing 31 days after the anniversary date

Revision History

  • 10/2023
    • Filter - Added filters for prior report runs to filter by who ran the report and date range.
  • 7/2023
    • Download - Added Excel download option for By Client tab.
  • 6/2023
    • Universe Selection - Fixed limited visibility of CoC selection on picker.
    • Results - Removed closed projects from the report that have no open enrollments and no open inventory.
    • Download - Added PDF and XLSX download option

Calculation Notes