View table

There are 0 QA scripts and 0 conversion scripts registered for this table.
Identifier DWD_NCI
Short name NonComplicanceInformation
Dataset WISE_DWD
Reference URL http://dd-test.01dev.eea.europa.eu/datasets/latest/WISE_DWD/tables/DWD_NCI
Name 09. Non Complicance Information
Short Description Information on non-compliance of drinking water in water supply zones
Definition Information on non-compliance of drinking water in water supply zones
Methodology for obtaining data Information on non-compliance of drinking water in water supply zones. The combination of the elements MemberState, Year, WaterSupplyZone, Parameter must create a unique record in the table. No duplicate records should exist with this table.
This data should be reported to the European Commision every three years with a annual return.

Elements

Element name Datatype Element type
* Country Code (CountryCode) C string Fixed values
* Water Supply Zone code (WSZ_ID) C string Fixed values
* Parameter (Parameter) C string Fixed values
* Remedial (Remedial) C string Fixed values
* Year (NCI_Year) integer Quantitative
* DerogationRef (NCI_DerogationRef) string Quantitative
* TotalAnalysis (NCI_TotalAnalysis) integer Quantitative
* TotalNoncompliances (NCI_TotalNoncompliances) integer Quantitative
* Minimal (NCI_Minimal) decimal Quantitative
* Medium (NCI_Medium) decimal Quantitative
* Maximum (NCI_Maximum) decimal Quantitative
* Cause (Cause) string Fixed values
* Timetable (Timetable) string Fixed values
(an asterisk in front of element name indicates that the element is mandatory in this table)
(the C sign marks a common element)