Feedbacks for envelope AutomaticQA result for file designations.xml: validation on CDDA 2013 - Designations

Subject:
AutomaticQA result for file designations.xml: validation on CDDA 2013 - Designations
Posted automatically on:
11 Mar 2013 17:28
Task:
Automatic quality assessment
Referred file:
designations.xml

The following 5 quality tests were made against this table - Common Database on Designated Areas (CDDA) 2013 - Designations

View detailed data definitions in Data Dictionary

1. Mandatory values

This test checked the presence of mandatory elements:

  • PARENT_ISO, ISO3, DESIG_ABBR, Category, ODESIGNATE, DESIGNATE, CDDA_sites, Law, Lawreference, Agency, To_be_deleted
  • Category, Law, Lawreference and Agency can be empty if DESIG_ABBR ends with "00" or "99".

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, Category, CDDA_sites, To_be_deleted.

OK - the test was passed successfully.