Skip to content
  • There are no suggestions because the search field is empty.

[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 and 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 on which information can be accessed based on the user's access rights.

Report Location

This report can be found in the following locations in the Report Library:

  • Data Quality  → [DQXX-102] Program Data Review

Parameters 

The following parameters are required to run the report:

Program Choose a program for your report.
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  Format will be automatically changed to Excel.

Report Details

Information for this report is pulled 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. 

Missing data logic is calculated based on screen setup including constraints, live markers (like Project Type and Age), and Mandatory Field determination.

Logic for fields with age live marker constraints will calculate age based on the project exit date if the client has exited to determine missing/valid data. 

Fields are counted as an error when:

  • [Mandatory Field] is reported as "Client doesn't know," "Client prefers not to answer," "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 Entry Data and Missing Exit Data columns drill down with details of required fields from the applicable screen. Fields with missing answers are labeled as “need corrections.“ Clicking the Unique Identifier, "valid" or "need corrections" will display the information from the Enrollment or Exit screen.

102 drilldown

Note: The screenshot above is taken from a sample program. The actual information displayed in the Missing Entry Data drilldown will depend on the fields used in the program's Enrollment/Exit Screen.

   

Updated: 07/16/2024