EEA

Services

Account Services

Note

Subscribe to receive notifications if you want to stay updated about events in this site.

Your password

The Eionet password expires two years after it was last changed.

Feedback: AutomaticQA result for file Rivers_2009_HazSubstRivers_Agg.xml: WISE-SOE: Rivers- Hazardous Substances - Agg 2010

Subject: AutomaticQA result for file Rivers_2009_HazSubstRivers_Agg.xml: WISE-SOE: Rivers- Hazardous Substances - Agg 2010
Posted automatically on: 21 Oct 2010 17:00
Task: Automatic quality assessment
Referred file: Rivers_2009_HazSubstRivers_Agg.xml
Feedback status:
Feedback message:

The following 6 quality tests were made against this table - WISE-SOE 2010: Rivers Hazardous Substances - Aggregated Data

1. Mandatory values

This test checked the presence of mandatory elements - CountryCode, NationalStationID, Year, DeterminandHazSubsName, CASNumber, NumberOfSamples, LimitOfQuantification, Mean, StandardDeviation. CASNumber is mandatory field if reported determinand is marked as "Preferred SoE Hazardous Substances"

OK - the test was passed successfully.

2. Country codes

This test checked the correctness of country code. All CountryCodes has to match the one of the reporting Country.

OK - the test was passed successfully.

3. Duplicates

This test checked the uniqueness of primary keys. The combination of the elements CountryCode, NationalStationID, Year, DeterminandHazSubsName and SampleDepth must create a unique record in the table. No duplicate records should exist with this combination.

OK - the test was passed successfully.

4. Data types

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

OK - the test was passed successfully.

5. Valid codes

This test checked the correctness of values against code lists (fixed values) - Unit_HazSubs.

OK - the test was passed successfully.

6. Logical checks

This test checked the logical consistency of the NoOfSamples, Minimum, Mean, Maximum, Median and StandardDeviation values.

OK - the test was passed successfully.