# CODE_LIST_DO_NOT_MODIFY

lu_Definition:
Macedonia, the Former Yugoslav Republic of


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


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


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


lu_Definition:
D1 Replacement, disconnection or repair of defective components


lu_Definition:
D2 Cleaning, scouring and/or disinfecting contaminated components


lu_Definition:
E Emergency actions for the consumers' health and safety


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


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


lu_Definition:
P1 Replacement, disconnection or repair of defective components


lu_Definition:
P2 Cleaning, scouring and/or disinfecting contaminated components


lu_Definition:
S1 Security measures to prevent unauthorised access


lu_Definition:
T Establishing, upgrading or improving treatment


lu_Value:
C1 Documented, lasting pollution either industrial, communal or agricultural


lu_Value:
D3 Migration from construction materials


lu_Value:
P1 Intrusions related to breaks and defects of the distribution system (including service reservoirs)  caused by human, animal or plant access.


lu_Value:
P3 Migration from construction materials


lu_Value:
T1 Persistent insufficiency of the treatment


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


lu_Definition:
S Short-term, i.e. not more than 30 days


# DEFINITIONS_DATASET_DO_NOT_MODIFY

ds_Definition:
Data on Memberstates 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 waterspplyzone as well as information on derogations, drinkingwater 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. Submit information on Derogations accordance with Article 9 of the DWD directive.
5. 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.
6. Supply data on WSZ in XML, Excel or tab-separated ASCII text format.
Ensure commas are not used as decimal separators.
7. Upload your data files to your nominated repository: the Central Data Repository at
http://cdr.eionet.europa.eu/


# DEFINITIONS_ELEMENTS_DO_NOT_MODIFY

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


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:
Indicate "true" if the information is avaliable the location is obligated, "false" if not.


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.


e_Methodology:
Select a code for the remedial of non-compliance as defined in the fixed values list (see Annex B)


e_Methodology:
Reference of second derogation if applicable


e_Methodology:
Reference of third derogation if applicable


e_Methodology:
Select a code for the DerogationType as defined in the fixed values list


e_Definition:
Resident population of water supply zones

e_Methodology:
Resident population of water supply zones


e_Methodology:
Number of population concerned by derogation


e_Definition:
Are any relevant food-production undertakings affected?

e_Methodology:
Indicate "true" relevant food-production undertakings are affected, "false" if not.


e_Definition:
Value fixed for derogation  (including unit)

e_Methodology:
Value fixed for derogation  (including unit)


e_Methodology:
Number of analyses of previous relevant monitoring


e_Methodology:
Startdate of derogation period in format YYYY-MM-DD.


e_Methodology:
Enddate of derogation period in format YYYY-MM-DD.


e_Methodology:
Reviewdate of previous derogation period in format YYYY-MM-DD.


e_Methodology:
Conclusion previous derogation, only required if second or thirt derogation


e_Methodology:
Contactperson of the responsible Authority


e_Methodology:
The address of the responsible authority


e_Methodology:
The telephonenumber of the responsible authority


e_Methodology:
The faxnumber of the responsible authority


e_Methodology:
The emailaddress of the responsible authority


e_Methodology:
Select a code for the causes of non-compliance as defined in the fixed values list (see Annex A)


e_Methodology:
Select a code for the timetable of non-compliance as defined in the fixed values list (see Annex C)


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:
ParameterType as defined in the fixed values list. This is a mandatory element.


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_Methodology:
Number of required analyses. This also applies to the requirement to monitor the nitrite parameter ex water treatment works (Annex I note 5)


e_Methodology:
name of ISO of the used analysis method. If multiple then seporated by a semicolon (;)


e_Definition:
Foreign key to the Exemption Information table

e_Methodology:
The name of the expemted water as provided in the table Exemption Information. This is a mandatory element.


e_Methodology:
ExemptionType as defined in the fixed values list. This is a mandatory element.


e_Definition:
Comments on the parameter in the water exempted

e_Methodology:
Comments on the parameter in the water exempted


e_Definition:
Description of the water exempted of the DWD on article 3.2


e_Methodology:
Name of the water supply zone. This is a mandatory element.


e_Definition:
Will be specified later in agreement with the WISE working group

e_Methodology:
The NUTS code of the water supply zone. Will be specified later in agreement with the WISE working group.


# DEFINITIONS_TABLES_DO_NOT_MODIFY

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:
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:
Information on derogations of B-parameters under article 9 of drinking water in water supply zones. A Member State shall send this form to the Commission within two months of any derogation concerning an individual supply of water exceeding 1000 m3 per day as an average or serving more than 5000 persons

tbl_Methodology:
Information on derogations of B-parameters of drinking water in water supply zones. 
In case of a first derogation only the element FirstDerogationReference is required, in case of a second derogation the element FirstDerogationReference and SecondDerogationReference are required. In Case of a thirt derogation the elements FirstDerogationReference, SecondDerogationReference and ThirtDerogationReference are required
The combination of the elements WaterSupplyZone, FirstDerogationReference, SecondDerogationReference, ThirtDerogationReference, 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 annual within two months of being granted.

tbl_ShortDescription:
Information on derogations of B-parameters under article 9 of drinking water in water supply zones. A Member State shall send this form to the Commission within two months of any derogation concerning an individual supply of water 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:
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:
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. The combination of the elements MemberState, Year, Parameter, ParameterType 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:
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 the number of analysis, not compliant with the monitoring frequency, carried out compared with the number of analyses required by the DWD

tbl_Methodology:
Information on the number of analysis, not compliant with the monitoring frequency.The combination of the elements MemberState, Year, 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 the number of analysis, not compliant with the monitoring frequency, carried out compared with the number of analyses required by the DWD


tbl_Definition:
Information on the analysis methods for the microbiological parameters under article 7.5b of the DWD. Article 7.5.b states that methods other than those specified in Annex III, Part 1, may be used, providing it can be demonstrated that the results obtained are at least as reliable as those produced by the methods specified. MS which have recourse to alternative methods shall provide the Commission with all relevant information concerning such methods and their equivalence.

tbl_Methodology:
Information on the analysis methods for the microbiological parameters. The combination of the elements MemberState, Parameter must create a unique record in the table. No duplicate records should exist with this table.
The element Method can represent more then one method. The methods can be seporated by a semicolon (;) The element Method can not be empty.
This data should be reported to the European Commision every three years.

tbl_ShortDescription:
Information on the analysis methods for the microbiological parameters under article 7.5b of the DWD. Article 7.5.b states that methods other than those specified in Annex III, Part 1, may be used, providing it can be demonstrated that the results obtained are at least as reliable as those produced by the methods specified. MS which have recourse to alternative methods shall provide the Commission with all relevant information concerning such methods and their equivalence.


tbl_Definition:
Information on exemption parameters with there national parametric values which are stricter or additional than those in the DWD.
Depending on the selected Parameter Type the quality control changes. If the type Microbiological is chosen then Fixed Value must be the Microbliologial Code.

tbl_Methodology:
Information on exemption parameters of the expemted water. The combination of the elements WaterExempted, ExemptionType, Parameter, ParameterType must create a unique record in the table. No duplicate records should exist with this table.
Units used should be the same as in the DWD, values can be reported without units.

tbl_ShortDescription:
Information on exemption parameters (for the exempted water in the table Exemption information) with there national parametric values which are stricter or additional than those in the DWD.
Depending on the selected Parameter Type the quality control changes. If the type Microbiological is chosen then Fixed Value must be the Microbliologial Code.


tbl_Definition:
Information on exempted water from the requirements of the DWD. Water can be exempted because of size of the water supply zone (e.g. < 10 m3/day or serving less than 50 people) or because of the purpose it is intended for.

tbl_Methodology:
This table describes the water excempted from the requiremensts of the DWD (see Article 3.2 DWD). 
One table should be used for the Memberstate. The element WaterExempted 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:
Information on exempted water from the requirements of the DWD. Water can be exempted because of size of the water supply zone (e.g. < 10 m3/day or serving less than 50 people) or because of the purpose it is intended for.
See "Guidance document on reporting under the Drinking Water Directive 98/83/EC" Table 2.


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


