The following 5 quality tests were made against this table - Common Database on Designated Areas (CDDA) 2014 - 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.