Services
Account Services
Subscribe to receive notifications if you want to stay updated about events in this site.
The Eionet password expires two years after it was last changed.
Feedback: AutomaticQA result for file Lakes_2009_HazSubstLakes_Disagg.xml: WISE-SOE: Lakes - Hazardous Substances - Disagg 2010
| Subject: | AutomaticQA result for file Lakes_2009_HazSubstLakes_Disagg.xml: WISE-SOE: Lakes - Hazardous Substances - Disagg 2010 |
|---|---|
| Posted automatically on: | 29 Oct 2010 09:12 |
| Task: | Automatic quality assessment |
| Referred file: | Lakes_2009_HazSubstLakes_Disagg.xml |
| Feedback status: | |
| Feedback message: |
The following 5 quality tests were made against this table - WISE-SOE 2010: Lakes Hazardous Substances - Disaggregated Data
1. Mandatory values
This test checked the presence of mandatory elements - CountryCode, NationalStationID, Year, Month, Day, DeterminandHazSubsName, Unit_HazSubs, CASNumber, LimitOfQuantification, Concentration. CASNumber is mandatory field if reported determinand is marked as "Preferred SoE Hazardous Substances"
2. Country codes
This test checked the correctness of country code. All CountryCodes has to match the one of the reporting Country.
3. Duplicates
This test checked the uniqueness of primary keys. The combination of the elements CountryCode, NationalStationID, Year, Month, Day, DeterminandHazSubsName, CASNumber and SampleDepth must create a unique record in the table. No duplicate records should exist with this combination.
4. Data types
This test checked that the format of reported elements matches the Data Dictionary specifications.
5. Valid codes
This test checked the correctness of values against code lists (fixed values) - Unit_HazSubs, LimitFlag.