Data Quality Reports

[DQXX-102] Program Data Review

Description

Type of Report

This is a program enrollment-based report utilizing information from both the enrollment screen and, if applicable, the exit screen.

Purpose

The report provides a list of client enrollments, their time in the program and highlights data quality problems.

Running the Report

Who Can Run the Report

All users can run the report. There are restrictions for which information can be accessed based on the rights of the user.

Report Location

The report can be found in the Data Quality section of the Report Library.

Parameters 

The following parameters are required to run the report:

Program Choose the program for your report, only one
Status
  • Active clients
  • Exited clients from periods within 3 months to 2 years
  • All Exited
Report Format
  • Web Page
  • PDF
  • Excel

Note: If the report contains more than 10,000 rows, the Report Output Format will be automatically changed to Excel.

Report Details

Information for this report pulls from the Program Enrollment screen and the Program Exit screen based on the parameters responses.

In the event a client enrollment includes a data entry error, the client will be displayed in red. The count in the Missing Entry Data and Missing Exit Data columns indicate the number of errors on the screens.

Fields are counted as an error when:

  • [Mandatory Field] is reported as "Don't Know", "Refused", "Data Not Collected" or is NULL
    • If the field is mandatory, but not asked because of specific answers to other questions (constraints), the field is not reported as missing

Drilldown Functionality

The Missing Data columns drill down with details of required fields from Enroll / Exit screens respectively. Fields with missing answers are labeled as “need corrections“. Clicking the Unique Identifier, "valid" or "need corrections" will display client’s Enroll / Exit screen respectively.

   

Updated 11/09/2021