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