[DQXX-102] Program Data Review

Report Purpose and Summary

This report provides agencies with an overview of client data for a specified program. It provides a list of client enrollments, their time in the program, and highlights data quality problems for the selected program. This report can only be run for one program at a time. The report will give you the drill down into client program enrollment errors by client, and can be used for data clean-up.


Make sure you are operating in Clarity under the agency you are running the report for. You can check and change this under your name in the top right corner.

Step 1: Click on the Launchpad, then click on the Reports icon. 

Step 2: In the Report Library, click the down arrow next to the “Data Quality Reports” folder to expand the section.

Step 3: Click the Run button to the right of [DQXX-102] Program Data Review

Reporting Parameters

Step 4: Enter the following parameters

Program Choose the program for your report (can only select one program at a time)
Status Select the Status of program participants to include in the report between:
  • Active Clients
  • Clients exited within a certain time period
  • All exited clients
Report Output Format The User can choose to format the report output as a *Web Page, PDF, or Excel

*Drilldown Functionality is available when run in Web Page Format

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

Step 5: Click submit

The file will be sent to the Report Queue. Once the report is processed, you will receive a notification that the report is ready.

To open the report, either select Open on the popup or click the Queue icon and then click Open.

Reporting Details

This report provides an outlook of clients enrolled within the selected program. It provides data for the following fields of information:

  • Client name
  • Unique Identifier
  • The client's Entry and Exit Dates for the program
  • Number of days the client was active in the program
  • Missing Entry Data from the program enrollment
  • Missing Exit Data from the program exit

Data is considered “missing” when a mandatory field is reported as "Don't Know", "Refused", "Data Not Collected," or is NULL. Data that appears in red indicates an error. 

Drilldown Functionality

The Missing Datacolumns drilldown 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.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.