ANNEX
SECTION 1
Automated data quality control mechanism for data to be entered
Data entered into the EU information systems and interoperability components will be subject to automated data quality control mechanisms based on blocking and soft rules as defined in Article 2. These are the rules established in the EU information systems and interoperability components which determine whether the entry and storage of input data shall be allowed or rejected. The blocking and soft rules are established based on the following parameters: length, format, type, conformity to quality standards, semantics, repetition and syntax.
SECTION 2
General considerations on the common data quality indicators and minimum quality standards for data to be entered
The input data subject to the quality verification process shall be assessed against the data quality rules defined in each EU information system and interoperability component, as set out in Section 1. If the rules applying to the input data do not prevent entry and storage, the data quality control mechanisms shall measure the quality of the input data by using the data quality indicators applying to them.
The data quality control mechanisms shall measure the quality of input data according to each relevant indicator. The data quality control mechanisms shall take into account a weighing coefficient to calculate the relative weight of each indicator on the overall quality of the input data.
To that effect, the data quality control mechanisms shall be adapted to apply to a single collection of data within a record, or to a database.
After applying the weighing coefficient to the input data, the data quality control mechanisms shall produce an input data profile containing the results of the application of the indicator standards, for example numerical values evaluating the quality of the input data under each indicator.
Table 1 lists the minimum set of data quality indicators, for example indicators that shall always apply to input data, in accordance with the rules applied by each EU information system and interoperability component. Such indicators are the following: completeness, accuracy, consistency, timeliness, uniqueness.
Table 1
List of minimum data quality indicators
Indicator
Description
Main scope of applicability
Unit of measurement
Completeness
Means the degree to which the input data has values for all the expected attributes and related requirements in a specific context of use. Measures whether all the mandatory data is provided and the database (or sectoral) listings meet the set demands.
Mandatory data fields (alphanumeric and biometric)
Data completeness rate: ratio of the number of data cells provided to the number of data cells required
Accuracy
Means the degree to which the input data represents closeness of estimates to the unknown true values. It can be either or both among data regarding one entity and across similar data for comparable entities
Alphanumeric and biometric data
Sampling error rates, unit non-response rate, item non-response rate, data capture error rates, etc.
Consistency
Means the degree to which the input data has attributes that are free from contradiction and are coherent with other data in a specific context of use. Measures the degree to which a set of data satisfies defined business rules applying to those data across them, means the absence of a conflict of data content. It can be either or both among data regarding one entity and across similar data for comparable entities.
Alphanumeric data
Percentage
Timeliness
Means the degree to which the input data is provided within a predefined date or time that condition the validity of the data or its context of use. Measures how up-to-date the data is, and whether the data required can be provided by the required time.
Alphanumeric and biometric data
Time lag -final: number of days from the last day of the reference to the day the input data is provided
Uniqueness
Means the degree to which the input data is not duplicated in the same EU information system or interoperability component.
Mandatory data fields (alphanumeric and biometric)
Percentage of data units which are not duplicated
The accuracy indicator for biometric data also includes resolution. Resolution measures the degree to which the input data contains the required amount of points or pixels by unit of length. Unit to display on screen pixel: pi unit for printing; dot pi for output systems. Pixel one or several bits (range of colours ex: 16 colours 4b, 256 8b, 16b 65k, 24b 16.5mio)
SECTION 3
Data Quality Classification
After the development of the input data profile, referred to in Section 2, the input data shall be assigned with a data quality classification. The following data quality classifications shall apply:
(a)
‘good quality’ means the input data profile demonstrates the required compliance with the applicable data quality indicator;
(b)
‘low quality’ means the input data profile does not demonstrate the required compliance with the applicable data quality indicators, in the case of a soft rule;
(c)
‘rejected’ means the input data profile does not demonstrate the required compliance with the applicable data quality indicators in case of a blocking rule.
Where the input data is assigned with a ‘good quality’ classification, the data shall be stored into the system or component without any data quality alert.
Where the input data is assigned with a ‘low quality’ classification, the data shall be stored into the system or component and with a data quality alert. An alert shall indicate that the input data shall be rectified and the reason why the input data does not demonstrate the required compliance with the applicable data quality indicators. Where possible, the alert shall identify the data field(s) or the data content(s) or both affected by data quality issues and suggest the changes necessary for the input data to meet the ‘good quality’ classification.
SECTION 4
Data Quality Monitoring
Two types of mechanisms shall be used for the purposes of Article 3(8):
(a)
Data cleaning mechanisms. Such mechanisms shall carry out checks to identify data for which the remaining retention period is less than the time defined in the legislation governing the relevant EU information system or interoperability component. Data cleaning mechanisms shall inform the Member State of the scheduled erasure of the data and allow them to adopt, if necessary, the appropriate measures.
(b)
Issue detection mechanisms. Such mechanisms shall carry out checks to identify the data that no longer meet one or more data quality rules or standards related to data quality indicators. Such checks may return an alert or notification to the responsible authority of the Member State indicating the reason why the data no longer meets one or more data quality rules or standards. Where possible, the alert shall suggest the changes necessary for the input data to meet the new rules or standards. In no case the application of such checks shall lead to automated deletion of data stored in the EU information systems or interoperability components. When new data is being entered into an EU information system or interoperability component while the issue detection mechanisms are running, the issue detection mechanisms shall not apply to those data.
eu-LISA may decide that ad hoc issue detection mechanisms shall be carried out in the EU information system and in the interoperability components upon the revision of the data quality rules or standards.
eu-LISA may consult the Advisory Group for one of the EU information systems or the interoperability components on whether to carry out an ad hoc issue detection mechanisms in its corresponding EU information system or interoperability component to the extent necessary for the purposes of that EU information system or interoperability component.