View table

There are 0 QA scripts and 4 conversion scripts registered for this table.
Link to the schema page on XMLCONV
Identifier DWD_NCI
Short name DWD_NCI (04_NonComplianceInformation)
Dataset WISE_DWD
Reference URL http://dd.eionet.europa.eu/datasets/latest/WISE_DWD/tables/DWD_NCI
Name 04_NonComplianceInformation
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 CountryCode, 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 ID (WSZ_ID) C  (PK) string Quantitative
* Parameter (Parameter) C  (PK) string Fixed values
* DerogationRef (NCI_DerogationRef) string Quantitative
* TotalAnalysis (NCI_TotalAnalysis) integer Quantitative
* TotalNoncompliances (NCI_TotalNoncompliances) integer Quantitative
* Maximum (NCI_Maximum) float Quantitative
* NCI_MedianTotalAnalysis (NCI_MedianTotalAnalysis) float Quantitative
* NCI_MedianNonCompl (NCI_MedianNonCompl) float Quantitative
* NCI_Row_ID (DWD_NCI_Row_ID) C integer Quantitative
* Year (DWD_Year) C  (PK) integer Quantitative
(an asterisk in front of element name indicates that the element is mandatory in this table)
(the C sign marks a common element)