# CODE_LIST_DO_NOT_MODIFY

lu_ShortDescription:
In the accompanying Guidance Notes an explanation is given on the parameters colour, odour, taste, Colony, Count 22°C, TOC, and turbidity


lu_Definition:
Nitrite in distribution at the tap (mg/l)


lu_ShortDescription:
Only individual pesticides which have been detected above the detection limit should be reported


lu_Definition:
Medium-term, i.e. more than 30 days but not more than a year


lu_Definition:
Very short-term i.e. not more than one week


lu_Definition:
Action(s) to terminate or mitigate the cause


lu_Definition:
Replacement, disconnection or repair of defective components


lu_Definition:
Cleaning, scouring and/or disinfecting contaminated components


lu_Definition:
Notification of and instructions to consumers for example, prohibition of use, boil water order, temporary limitations on consumption).


lu_Definition:
Provision of a temporary alternative drinking water supply
(for example, bottled water, water in containers, tankers)


lu_Definition:
Security measures to prevent unauthorised access


lu_Definition:
Establishing, upgrading or improving treatment


lu_Definition:
No longer necessary i.e. restructure or enlarge of other WSZ


lu_Definition:
Other reasons i.e. the supply has changed to somewhere else


lu_Definition:
Water quality reason i.e. high values (non-compliance) of one or more parameters and derogation or remedial action are not possible


# DEFINITIONS_DATASET_DO_NOT_MODIFY

ds_Definition:
Data on Member states are collected for each reporting period (3 year period). General arrangements of the data requested on drinkingwater supply are presented in this specification by tables and
include characteristics on the watersupplyzones, values for the concentrations of chemical, biological and indicator each Water Supply Zone as well as information on derogations, drinking water quality and information for the public.

ds_Methodology:
The data requested for Drinking Water Directive should be derived from existing Water Supply Zones (WSZ) within each Member State. The combination of the elements MemberState and WaterSupplyZone must be a unique record in the table. No duplicate records should exist with this combination.
Please consider the following when compiling your data delivery:
1. Provide information on the Water Supply Zone. 
2. Submit annual summary information on drinking water quality in the WSZ exceeding 1000m3 per day as an average or serving more than 5000 persons
3. Submit data for non-compliance of drinking water in WSZ.
4. Use the templates (XML schemas or Excel) and these specifications to guide you in
formatting and collating your data delivery. All are available for download from the data
dictionary.
5. Supply data on WSZ in XML, Excel or tab-separated ASCII text format.
Ensure commas are not used as decimal separators.
6. Upload your data files to your nominated repository: the Central Data Repository at
http://cdr.eionet.europa.eu/

All questions and request for help regarding the DWD reporting should be sent to dwd.helpdesk@eionet.europa.eu.


# DEFINITIONS_ELEMENTS_DO_NOT_MODIFY

e_Definition:
Abbreviation of EEA Member or Collaborating Country, as defined in the codelist.

e_Methodology:
This is a required, not null field.
ISO 3166-alpha-2 code elements.


e_Definition:
Primary Key / Unique identifier (ID) of the Water Supply Zone

e_Methodology:
Code (ID) of the Water Supply Zone. This is a mandatory element.


e_Methodology:
Parameter as defined in the fixed values list. This is a mandatory element. A chemical or indicator parameter (at least the chemical parameter ‘pesticides – individual’) is described exactly with its CAS-No.


e_Methodology:
Total of Water Supply Zones in the memberstate, must be bigger then 1


e_Definition:
Total resident population supplied in the water supply zones

e_Methodology:
Total of resident population in the water supply zones, supplied in whole numbers. Must be bigger then 1


e_Definition:
Total volume of water supplied in the water supply zones in m3/year

e_Methodology:
Total volume of water in the water supply zones in m3/year, must be bgger then 1.


e_Methodology:
Percentage of total volume. Must be between 0 and 100. Groundwater means all water which is below the surface of the ground in the saturation zone and in direct
contact with the ground or subsoil.


e_Methodology:
Percentage of total volume. Must be between 0 and 100. Surface water means inland waters, except groundwater; transitional waters and coastal waters (Water
Framework Directive 2000/60/CE Art 2.1).


e_Methodology:
Percentage of total volume. Must be between 0 and 100


e_Methodology:
Website address for public access with information of the memberstate.


e_Methodology:
The contactperson of the resposible authority


e_Methodology:
The telephonenumber of the contact information


e_Methodology:
The faxnumber of the contact information


e_Methodology:
The emailaddress of the contact information


e_Definition:
Optional comment related to the parameters in the National Summary Information

e_Methodology:
Optional comment related to the parameters in the National Summary Information


e_Methodology:
The number of water supply zones monitored.


e_Methodology:
The number of water supply zones with non compliances


e_Definition:
The number of analysis with noncompliance

e_Methodology:
The number of analysis with noncompliance.


e_Definition:
Sampling location, use ‘W’ for waterworks.

e_Methodology:
Sampling location, use ‘W’ for waterworks.


e_Definition:
Sampling location, use ‘L’ for legal point of delivery.

e_Methodology:
Sampling location, use ‘L’ for legal point of delivery.


e_Definition:
Sampling location, use ‘T’ for tap in domestic installations.

e_Methodology:
Sampling location, use ‘T’ for tap in domestic installations.


e_Definition:
Unique identifier for linking tables 04 and 05.

e_Methodology:
Unique identifier for linking tables 04 and 05.


e_Definition:
Text explaining why restriction or prohibition in use, i.e. e.g. high values (non-compliance) of one or more parameters and use of water for kindergarten, school, hospital

e_Methodology:
Text explaining why restriction or prohibition in use, i.e. e.g. high values (non-compliance) of one or more parameters and use of water for kindergarten, school, hospital


e_Definition:
Explanation how the drinking water directive provision is fulfilled

e_Methodology:
Explanation how the drinking water directive provision is fulfilled for Acrylamide


e_Methodology:
Explanation how the drinking water directive provision is fulfilled for Epichlorohydrin


e_Methodology:
Explanation how the drinking water directive provision is fulfilled for Vinylchloriride


e_Methodology:
Indicate "true" if the information is avaliable the location is obligated, "false" if not.


e_Definition:
Latitude of Small Water Supply Zone (WGS-84).

e_Methodology:
Latitude of Small Water Supply Zone (WGS-84).


e_Definition:
Longitude of the Small Water Supply Zone (WGS-84).

e_Methodology:
Longitude of the Small Water Supply Zone (WGS-84).


e_Definition:
Number of residents living in the Small Water Supply Zone.

e_Methodology:
Number of residents living in the Small Water Supply Zone.


e_Definition:
Used for linking between 12_2 and 12_3 tables


e_Definition:
Number of Small Water Supply Zones Monitored

e_Methodology:
Number of Small Water Supply Zones Monitored


e_Definition:
Number of Small Water Supply Zones non complied

e_Methodology:
Number of Small Water Supply Zones non complied


# DEFINITIONS_TABLES_DO_NOT_MODIFY

tbl_Definition:
Information on the WSZ, year and monitored parameters in each of the WSZ

tbl_Methodology:
Combination of CountryCode, WSZ_ID, Year and Parameter columns has to create a unique record

tbl_ShortDescription:
Information on the WSZ, year and monitored parameters in each of the WSZ


tbl_Definition:
General information on member states drinking water supply arrangements

tbl_Methodology:
The data requested for DWD should be derived from the Memberstate. One table should be used for the memberstate. The element MemberState 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.

tbl_ShortDescription:
General information on Member States drinking water supply arrangements.
See "Guidance document on reporting under the Drinking Water Directive 98/83/EC" Table 1.


tbl_Definition:
National summary information on drinking water quality in water supply zones exceeding 1000 m3 per day as an average or serving more than 5000 persons

tbl_Methodology:
National summary information on drinking water quality in water supply zones. Combination of CountryCode, Year and Parameter columns gives a unique record.
This data should be reported to the European Commision every three years with a annual return.

tbl_ShortDescription:
National summary information on drinking water quality in water supply zones exceeding 1000 m3 per day as an average or serving more than 5000 persons


tbl_Definition:
Information on non-compliance of drinking water in water supply zones

tbl_Methodology:
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.

tbl_ShortDescription:
Information on non-compliance of drinking water in water supply zones


tbl_Definition:
Non compliance information - additional attributes

tbl_ShortDescription:
Non compliance information - additional attributes


tbl_Definition:
Information on product specified parameters (acrylamide, epichlorohydrin and vynylchloride) explaining how the drinking water directive provision is fulfilled

tbl_Methodology:
Information on product specified parameters in water supply zones. The element MemberState, Year 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.

tbl_ShortDescription:
Information on product specified parameters (acrylamide, epichlorohydrin and vynylchloride) explaining how the drinking water directive provision is fulfilled


tbl_Definition:
General information avialable to the public

tbl_Methodology:
General information avialable to the public. Only one record can exist in this table.

tbl_ShortDescription:
General information avialable to the public


tbl_Definition:
General information on drinking water quality.

tbl_Methodology:
General information on drinking water quality. Only one record can exist in this table.

tbl_ShortDescription:
General information on drinking water quality.


tbl_Definition:
General information on individual water supply zones witch exceed  1000 m3 a day as average or serving more than 5000 persons

tbl_Methodology:
The data requested for DWD should be derived from existing Water Supply Zones within each Member State. One table should be used for all Water Supply Zones. The combination of the elements MemberState an WaterSupply Zone 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.

tbl_ShortDescription:
General information on Water Supply Zones drinking water supply arrangements
(With the exception of question 1.2 only information on individual supplies of water exceeding 1000 m3 a day as an average or serving more than 5000 persons should be reported)
See "Guidance document on reporting under the Drinking Water Directive 98/83/EC" Table 1.4.


tbl_Definition:
Water Supply Zone - additional information

tbl_ShortDescription:
Water Supply Zone - additional information


