Data Quality Reports
      Back to home
      1. Clarity Human Services Help Center
      2. Report Library
      3. 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 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