The following 12 quality tests were made against this delivery:
- OK 1. Validate mandatory values: This test checked the presence of mandatory values. When the test fails the following warning is shown "Mandatory value not provided".
- OK 2. Validate mandatory boolean values: This test checked the presence of mandatory Y/N values. When the test fails the following warning is shown "Value should be 'Y'".
- OK 3. Validate data types: This test checked the correctness of data types. When the test fails the following warning is shown "Invalid data type".
- OK 4. Validate codelists: This test checked the correctness of code and decription values against code lists (lookup tables). When the test fails the following warning is shown "Code not in relevant look up table".
- OK 5. Validate date and period field format: This test checked the correct format of date and period values. When the test fails the following warning is shown "Date (or period) field in the wrong format".
- OK 6. Validate period field min max values: This test checked if starting year of the range is smaller or equalt to the end year. When the test fails the following warning is shown "Period range is incorrect".
- OK 7. Validate date and period field range: This test checked the year range of date and period values. When the test fails the following warning is shown "Date (or period) field is not in allowed range".
- OK 8. Validate min max values: This test checked the logical consistency of minimum and maximum values. When the test fails the following warning is shown "Maximum value is larger than minimum".
- OK 9. Validate record counts: This test checked if record counts meet the rules. When the test fails the following warning is shown "Invalid record count ".
- OK 10. Validate data quality: This test checked if data in certain fields meets the bussiness rules. When the test fails the following warning is shown "Invalid field content".
- OK 11. Validate mandatory tables: This test checked the presence of mandatory table. When the test fails the following warning is shown "At least one record should be provided".
- OK 12. Validate duplicate entries: This test checked if there are duplicate entries in the delivery. When the test fails the following warning is shown "Duplicate entry".