Data Quality Reports
      Back to home
      1. Clarity Human Services Help Center
      2. Report Library
      3. Data Quality Reports

      [GNRL-242] Client Project Stay Issues

      Report Purpose & Summary

      This report was primarily designed to identify problems created during Data Integration. These problems are likely to occur if more than one person is performing the data integration for a community. If these problems occur, it may result in trouble generating other reports such as APR and ESG-CAPER.

      Running the Report

      Report Location

      This report is found in the Data Quality section of the Report Library.

      Who Can Run the Report

      Anyone can run the report but the returned information will be limited based on the access rights of the user.

      An Administrator version of the report is also available [GNRL-242-AD]. System administrators and users with additional access can run the report across multiple agencies.

      Parameters

      The following parameters are required to run the report.

      CoC Filter Category

      Choose how the CoC filter should be applied:

      • Agencies in the CoC
      • Agencies with Programs in the CoC
      • Agencies with Sites in the CoC
      • Agencies with Beds in the CoC
      CoC Choose the Continuum of Care code
      Program Type(s) Choose which program types to include in the report
      Program Status Choose whether to include active &/or inactive programs
      Program(s) Choose which programs to include
      Report Date Range Choose the range to report on
      Report Output Format
      • Web Page - includes a count of enrollments with issues and drill downs
      • PDF - printable version of the web page, no drill downs
      • CSV - Details - will include details about the enrollments with issues

      Report Details

      Question

      How issue is identified

      How Issue was created, possibly

      Possible Resolution

      Q1. Program Entry Issues

      		  

       

      		  
      Have no entry screen 0 record in "client_program_demographics" table by
      [ref_program] = client_programs.id and [screen_type] = 2

      Migration/DIT (Data Integration Tool),
      origin data problem

      		 Submit help desk request for Bitfocus to repair in the unlikely event this is a problem
      More than one entry screen 2+ records in "client_program_demographics" table by
      [ref_program] = client_programs.id and [screen_type] = 2      		 Migration/DIT,
      origin data problem or duplicate running of DIT       		 Submit help desk request for Bitfocus to repair in the unlikely event this is a problem
      Date issue between start date and date on entry screen enroll screen ("client_program_demographics" table) has [program_date] != client_programs.start_date Old migrated data problem Submit help desk request for Bitfocus to repair in the unlikely event this is a problem

      Q2. Program Exit Issues

      		      
      Exit Date with no exit screen 0 record in "client_program_demographics" table by
      [ref_program] = client_programs.id and [screen_type] = 4      		 Migration/DIT,
      origin data problem      		 Submit help desk request for Bitfocus to repair in the unlikely event this is a problem
      More than one exit screen 2+ records in "client_program_demographics" table by
      [ref_program] = client_programs.id and [screen_type] = 4      		 Migration/DIT,
      origin data problem      		 Submit help desk request for Bitfocus to repair in the unlikely event this is a problem 
      Date issue between exit date and date on exit screen exit screen ("client_program_demographics" table) has [program_date] != client_programs.end_date Old migrated data problem Submit help desk request for Bitfocus to repair in the unlikely event this is a problem

      Q3. Custom Program Demographic Record Issues

      		      

      Have no custom data record

      		 0 record in "client_program_data" table by ref_client_program_demographics Old migrated data problem Submit help desk request for Bitfocus to repair in the unlikely event this is a problem

      More than one custom data record

      		 2+ records in "client_program_data" table by ref_client_program_demographics Migration/DIT,
      origin data problem      		 Submit help desk request for Bitfocus to repair in the unlikely event this is a problem

      Q4. Client Program Assessment Income Cash Issues

      		      

      Income from any source as OFF with at least one specific income as ON

      		 [Income from Any Source] = [null, 0, 8, 9 ,99] AND at least one income source = Yes User error/Migration/DIT  Correct on the appropriate screen (entry, exit, etc.)

      Income from any source as ON with all specific income as OFF

      		 [Income from Any Source] = yes AND all income sources = No or NULL User error/Migration/DIT Correct on the appropriate screen (entry, exit, etc.)

      Income from some specific source as ON with non-positive respective amount

      		 Example [earned income] = Yes AND
      [earned income amount] = 0, or NULL, or <0      		 User error/Migration/DIT Correct on the appropriate screen (entry, exit, etc.)

      Income from some specific source as OFF with a positive respective amount

      		 Example [earned income] = [No, null] AND [earned income amount] > 0 User error/Migration/DIT Correct on the appropriate screen (entry, exit, etc.)

      Individual income doesn't match up to the addition of all the specific amounts

      		 [income_individual] != sum of [ income amount (where income = yes) ] Migration/DIT,
      origin data problem      		 Re-save the affected screen

      Q5. Enrolled Client Issues

      		      

      Have no client demographic record

      0 record in "client_demographics" table by [ref_client]

      Migration/DIT,
      origin data problem

      Submit help desk request for Bitfocus to repair in the unlikely event this is a problem

      More than one client demographic record

      2+ records in "client_demographics" table by [ref_client]

      Migration/DIT,
      origin data problem

      Submit help desk request for Bitfocus to repair in the unlikely event this is a problem

      Child or unknown age set as a veteran

      [veteran] = [Yes] AND ( [age] = [Null] OR [age] < 18 )

      User error/Migration/DIT

      Correct on the appropriate screen (entry, exit, etc.)

      Q6. Enrolled Client Demographic Issues

      		      

      Have no client demographic custom record

      0 record in "client_data" table by [ref_client_demographics]

      Migration/DIT,
      origin data problem

      Submit help desk request for Bitfocus to repair in the unlikely event this is a problem

      More than one client demographic custom record

      2+ records in "client_data" table by [ref_client_demographics]

      Migration/DIT,
      origin data problem

      Submit help desk request for Bitfocus to repair in the unlikely event this is a problem

      Q7. Enrolled Client Assessment Issues

      		      

      Have no client assessment custom record

      		 0 record in "client_assessment_data" table by [ref_client_assessment_demographics] Old migrated data problem Submit help desk request for Bitfocus to repair in the unlikely event this is a problem

      More than one client assessment custom record

      		 2+ records in "client_assessment_data" table by [ref_client_assessment_demographics] Old migrated data problem Submit help desk request for Bitfocus to repair in the unlikely event this is a problem

      Q8. Client Location Issue

      		      

      Have no record with the client location for the head

      0 record in "client_program_demographics" table by [ref_program] = client_programs.id AND [client_location] is not null

      Migration/DIT,
      origin data problem

      Correct on the appropriate screen (entry, exit, etc.)

      Drilldown Functionality

      Drilldown functionality is available for this report in CSV format. For each section, there will be listed:

      • Agency Name
      • Program Name
      • Unique Identifier
      • All fields checked to define the data quality issue

      Updated 4/8/2021