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:
|
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 |
|
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), |
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, |
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, |
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, |
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, |
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, |
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