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. These problems may result in trouble generating other reports such as APR and ESG-CAPER.

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.

The Admin version of the report can be run across agencies by System Administrators and others with the appropriate access roles.

Report Location

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

  • Data Quality Reports  → [GNRL-242] Client Project Stay Issues
  • Administrator Reports → [GNRL-242-AD]  Client Project Stay Issues

Parameters

The following parameters are required to run the report.

CoC Filter Category

Choose an option for applying the CoC filter:

  • Agency CoC: Data will pull from Agencies with the selected CoC(s)
  • Program CoC: Data will only pull from Programs/Projects with the selected CoC(s)
  • Site CoC: Data will only pull from Sites with the selected CoC(s) 
  • Inventory CoC: Data will only pull from Bed Inventories with the selected CoC(s). Note: Choosing this option will limit to only those projects with Bed Inventories.
CoC

Choose the Continuum of Care code:

Single Select or Multi-Select (Hold Control/Command or Hold Shift to select multiple options sequentially.)

Project Type(s)

Choose which project type(s) to include in the report:

All, Single Select, or Multi-Select (Hold Control/Command or Hold Shift to select multiple options sequentially.)

Program Status
  • All Programs
  • Active Programs
  • Inactive Programs
Program(s)

Choose which program(s) to include:

All, Single Select, or Multi-Select (Hold Control/Command or Hold Shift to select multiple options sequentially.)

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. Enrollment CoC Issues

Have no record with the enrollment CoC for the head

0 record in "client_program_demographics" table by [ref_program] = client_programs.id AND [enrollment_coc] as of project start date is not null

Migration/DIT,
origin data problem

Correct on the project entry screen.

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 01/08/2024