Feedbacks for envelope AutomaticQA result for file designation_boundaries.xml: validation on CDDA 2015 - Designation Boundaries

Subject:
AutomaticQA result for file designation_boundaries.xml: validation on CDDA 2015 - Designation Boundaries
Posted automatically on:
11 Mar 2016 10:06
Task:
Automatic quality assessment
Referred file:
designation_boundaries.xml

The following 5 quality tests were made against this table - Common Database on Designated Areas (CDDA) 2015 - Designation boundaries

View detailed data definitions in Data Dictionary

1. Mandatory values

This test checked the presence of mandatory elements - PARENT_ISO, ISO3, DESIG_ABBR, CDDA_Availability_code, CDDA_Resolution_code, CDDA_Dissemination_code.

OK - the test was passed successfully.

2. Duplicates

This test checked the uniqueness of primary keys. ISO3 and DESIG_ABBR should be a a unique record in the table.

OK - the test was passed successfully.

3. Data types

This test checked that the format of reported elements matches the Data Dictionary specifications.

OK - the test was passed successfully.

4. Country codes

This test checked the correctness of country codes in PARENT_ISO, ISO3 and DESIG_ABBR fields.

OK - the test was passed successfully.

5. Valid codes

This test checked the correctness of values against code lists (fixed values) defined in Data Dictionary - PARENT_ISO, ISO3, CDDA_Availability_code, CDDA_Resolution_code, CDDA_Dissemination_code.

  • Placeholder value 00 of the CDDA_Dissemination_code must be changed to a proper code (01-03). If not changed, all remaining 00 codes will be converted to 01 by ETC-BD when the delivery is processed.

OK - the test was passed successfully.