[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 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: 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. 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/26/2023