Eionet
Central Data Repository
This service is part of Reportnet
Services
Account Services
I have
Note
Subscribe to receive notifications if you want to stay updated about events in this site.
Feedback: AutomaticQA result for: DWD cross table checks
| Subject: | AutomaticQA result for: DWD cross table checks |
|---|---|
| Posted automatically on: | 23 Feb 2021 13:32 |
| Task: | Automatic quality assessment |
| Feedback status: | UNKNOWN |
| Feedback message: | empty |
The following cross table checks were made in DWD envelope
1. Cross table ID relations check
The test checked the presence of different IDs in related tables. The rules are:
- DWD_WSZ.WSZ_ID --> DWD_NCI.WSZ_ID
- DWD_WSZ_1.WSZ_ID --> DWD_WSZ.WSZ_ID
- NCI_Cause.DWD_NCI_Row_ID <-> DWD_NCI.DWD_NCI_Row_ID
- NCI_NCI_1.DWD_NCI_Row_ID --> DWD_NCI.DWD_NCI_Row_ID
- NCI_Remedial.DWD_NCI_RemedialID <-> NCI_Cause.DWD_NCI_RemedialID
--> means that all values in the left hand field must be also present in the right hand field
<-> means that all values in the left hand field must be also present in the right hand field and vice versa
OK - the test was passed successfully.
2. Cross table Country Code relations check
The test checked the presence of different country codes in related tables. The rules are:
- DWD_WSZ.CountryCode <-> DWD_MS.CountryCode
- DWD_S_WSZ_2.CountryCode --> DWD_MS.CountryCode
- DWD_NS.CountryCode <-> DWD_MS.CountryCode
- DWD_AM.CountryCode <-> DWD_AM.CountryCode
- DWD_PI.CountryCode <-> DWD_MS.CountryCode
- DWD_QI.CountryCode <-> DWD_MS.CountryCode
- DWD_PSP.CountryCode <-> DWD_MS.CountryCode
- DWD_S_WSZ.CountryCode --> DWD_MS.CountryCode
- DWD_S_WSZ_3.CountryCode -> DWD_MS.CountryCode
--> means that all values in the left hand field must be also present in the right hand field
<-> means that all values in the left hand field must be also present in the right hand field and vice versa
OK - the test was passed successfully.