7.5.1 Data Quality Errors
For each Data Quality (DQ) error, a severity code is assigned, and it corresponds to the likely impact the issue will have on screening efficiency. The error codes and the associated messages that are displayed are based on the data analysis are shown in the following table:
Table 7-1 Severity Codes Assigned to Data Quality Errors
Severity Code | DataQuality Error |
---|---|
1 | Severedata error which prevents screening. |
2 | Invaliddata which will limit the effectiveness of screening. |
3 | Missingdata which will limit the effectiveness of screening. |
4 | Invalid data which does not affect screening. Errors in this categorywill not affect the output of the match processor but can cause issues when manually evaluating any potential matches that are raised. |
The data quality check analyzes each row of data. If the analysis of any row results in a severity code of 1, it is rejected by the screening process. This is because there is a lack of data in the core attributes used by the screening process, and so screening cannot be performed.
The screening processes load data that cannot be screened into the
CUST_Individuals_Invalid staged data
or the
CUST_Entities_Invalid staged data
tables for the individual and
external entity records, respectively. The error codes associated with each row are also
stored in the database.