03. How to Run a HUD Data Quality Report

Overview

The HUD Data Quality Report provides a scored overview of data quality completeness, which can be used as a resource to locate and correct data quality errors within a particular program or project.

• More About This — Further important information is found in this section.
• Details — Specific details and/or step-by-step workflows will be described in this section.
• Video — Under construction, coming soon!

More About This

This report should be utilized by users wanting to monitor the data quality of a project(s) within their organization(s), and can be used advance of submitting reports to funders or for maintenance data quality monitoring.

Back to top

Details

Running the Report

Before running a HUD Data Quality Report,  make sure you have selected the correct organization in your settings.

1. Navigate to the Reports Workspace, located on the blue Main Menu

2. From the Reports Workspace menu options expand the HMIS Reports folder. From the list that appears, click on the report titled HUD Data Quality Report as shown:

3. After choosing the HUD Data Quality Report you will see a series of prompt options
   1. Saved Settings [optional].

   2. Date Range [required]: Select the date range for your report. Only records that fall within the date range you select will be included.

      

   3. CoC filter [optional]: these prompts do not work as intended and should not be used.

   4. Organization [required]: From the list, select your organization(s), depending on which program you need to check data quality for.

      

   5. Grants: Skip this prompt. It is not currently configured and will not work as intended.

   6. Program [required]: Click filter by program to select the project(s) you want included. Important note: If you don't see them listed you made need to check which organization you selected, and select more as needed (depending on the programs you're looking for.

      

   7. Detail Export [optional]: This prompt gives you various options to mask SSNs.

      

      
      
4. Once you've filled out all necessary report prompts, click Report and the report will start running.

5. After, you'll see a message in the top right corner of your screen to inform you the report is running.

   

   
   
6. Once the report is finished, the report will automatically appear in a pop-up window

7. To save your report, click on the Excel Data option, as shown:

   

   
   

Correcting Data Quality Errors

1.  To see specifically which clients' records are causing the errors listed on the report, you will need to run the report as an export with the same prompts you used.

Click Run Export, just underneath the SSN Masking section:

1. From the Reports Workspace, when the report is finished navigate to the Files on Server menu group option and select the recently run file named HUD Data Quality.... .zip

2. 

   When opening the report's zip file in a file folder, you will see many small .csv files

1. Next, compare the the two reports

   1. For example, notice 4 client records are missing information for Q4, as shown:

      

   2. Return to the previously downloaded files in the HUD Data Quality.... .zip, and open the Detail (Validation Only) file for that same question, as shown:

      

   3. From there, the client record needing correction can be isolated for that data element

      

Back to top

Video

Under construction, coming soon!

Back to top

Related Articles & References

Under construction, coming soon!

Core HMIS Workflow How-to Guides:

HMIS Fundamentals

ClientTrack Basics

Client Intake

Program Enrollment

Questions? Email the Helpdesk: MNHMIS@icalliances.org