0.0

TEMPLATE

Vorgegebener Schablonenname, schreibgeschützt

string (50)

Mandatory

1.1

LAND_CD

Der CountryStateCode wird in Anlehnung an die Regelungen der DIN EN ISO 3166-1 und DIN ISO 3166-2 aus zwei Alpha-2 Schlüsseln zusammen gesetzt. Der erste Teil des Schlüssels entspricht dem MemberStateCode, der zweite Schlüsselbestandteil steht für die Verwaltungseinheiten (Bundesland). Für Deutschland sind diese Verwaltungseinheiten vorgegeben. Für andere Länder ist der Alpha-2 Schlüssel (XX) frei wählbar.

string (4)

Mandatory, primary key

1.3

EU_CD_GB

Internationaler Schlüssel für den Grundwasserkörper. Der Schlüssel setzt sich zusammen aus dem MemberStateCode, dem FeatureClassCode und dem nationalen Schlüssel. Generell: <MemberStateCode><FeatureClassCode>_ <LAND_CD><ID>

string (42)

Mandatory, primary key

3.0

POLLCODE

Required . Select each pollutant and indicator for which one or more of the following circumstances occur in the relevant water body: -The pollutant or indicator is causing risk of failure of chemical status (element gwPollutantCausingRisk) -The pollutant or indicator is causing failure of chemical status due to exceedance of the relevant EQS or threshold value (element gwPollutantCausingFailure) -The pollutant or indicator is showing an upward trend (element gwPollutantUpwardTrend) -The pollutant or indicator is showing a trend reversal (element gwPollutantTrendReversal) -The pollutant or indicator is showing exceedance(s) of the EQS or threshold value but after an appropriate investigation according to Article 4(2)(c) and Annex III of the Groundwater Directive the Member States considers that this does not result in a failure of chemical status (element gwPollutantExcedancesNotCounted) -Background levels have been set for the pollutant or indicator (elements gwPollutantBackgroundLevelSet, gwPollutantBackgroundLevelValue and gwPollutantBackgroundLevelUnit)

string (5)

Mandatory, primary key

3.1

POLLOTHER

If 'GwPollutantCode' is 'EEA_00-00-0 Other chemical parameter' please indicate in this field the CAS number (if relevant) and the name of the pollutant or indicator. Quality check: Conditional check: report if 'GwPollutantCode' is 'Other'. Fehlwert: -9999

string (250)

Mandatory, primary key

5.0

INS_WHEN

Erstellungsdatum des Datensatzes

date (8)

Mandatory

YYYYMMDD

5.1

INS_BY

Ansprechpartner

string (15)

Mandatory

5.2

RBD_CD

Kennung für die Flussgebietseinheit. Der Code besteht aus einer vierstelligen Numerierung für die Flussgebietseinheit.

string (4)

Mandatory

5.3

METADATA

Der Name der Metadatendatei ist abhaengig vom hier erfassten Gebiet. Er kann auf vier verschiedene Arten gebildet werden. Er setzt sich zusammen aus der Kurzbezeichnung fuer die Schablone, dem CountryStateCode, dem WorkAreaCode oder dem RiverBasinDistrictCode und wird um die Dateinamenserweiterung XML ergaenzt. Alle Angaben sind in Grossbuchstaben auszufuehren.Schema: <TemplateShortName>_ <CountryStateCode>_ <WorkAreaCode>.XML or <TemplateShortName>_ <CountryStateCode>_ <RiverBasinDistrictCode>.XML or <TemplateShortName>_ <CountryStateCode>.XML or <TemplateShortName>_ <WorkAreaCode>.XML Beispiel: fuer Nordrhein-Westfalen fuer den Niederrhein: COMPATH_DENW_2800.XML fuer Nordrhein-Westfalen fuer den Rhein COMPATH_DENW_2000.XML fuer Nordrhein-Westfalen: COMPATH_DENW.XML fuer das Gesamtgebiet Niederrhein: COMPATH_2800.XML

string (255)

Mandatory

7.1

EX_CHE_TYP

Required. Report which type(s) of exemption(s) apply if good chemical status is not expected to be achieved by 2015 for that pollutant or indicator. Quality checks: Within-schema check: The option 'No exemption' is not compatible with any other. Therefore, if reported, no more instances of 'gwChemicalExemptionType' should be reported. The options 'Article4(7) - New modification' and 'Article4(7) - Sustainable human development' are not valid for groundwater chemical status and therefore cannot be reported. Die Feinbegründungen (z.B. Wert 8-1, etc.) sind auf Wasserkörperebene anzugeben und nicht Teil der elektronischen Berichterstattung an die KOM: sie werden hierfür auf die allgemeinere Begründung zurückgeführt (z.B. Wert 8, etc.)

string (254)

Mandatory

7.2

EX_CHE_PR

If any GWD Article 6(3) or WFD Article 4(4) or 4(5) exemptions apply to this groundwater body for chemical status, report the significant pressure(s) that are causing failure in order to justify the exemption(s). Quality checks: Conditional check: If gwChemicalExemptionType is not 'No exemption', at least one significant pressure type must be selected from the enumeration list. The options 'No significant pressure types' and 'Not relevant' are not valid. Cross-schema checks: All the significant pressures must also be reported in the schema WFD_MSRPROG (where WB_CAT = ‘GW’).

string (254)

Conditional, mandatory for GwChemical ExemptionType <> 'No exemption'

7.3

POLL_RISK

Required. Indicate if the pollutant or indicator is casing risk of failing to be of good chemical status in the relevant water body. Quality checks: If gwbAtRiskChemical is 'Yes' then at least one pollutant or indicator should be reported as 'Yes' in gwPollutantCausingRisk.

string (1)

Mandatory

7.4

POLL_FAIL

Required. Indicate if the pollutant or indicator is causing failure to achieve good chemical status. Quality checks: If 'gwChemicalStatusValue' is '3' at least 1 pollutant or indicator should be reported as 'Yes' in 'gwPollutantCausingFailure'.

string (1)

Mandatory

7.5

POLLUPWARD

Required. Indicate whether there is a significant and sustained upward trend in the concentration of pollutant(s) or indicator(s) of pollution.

string (1)

Mandatory

7.6

POLLTRENDR

Required. Indicate whether there is a trend reversal in the concentration of the pollutant(s) or indicator(s) of pollution. Quality checks: Within-schema check: the option 'Not applicable' is only valid if the element 'upwardTrend' is 'No'.

string (1)

Mandatory

7.7

POLLTRER_P

If there is a significant and sustained upward trend in the concentration of the pollutant or indicator of pollution, indicate whether there is a process in place that will lead to a trend reversal. Report ‘Not applicable’ if there is no significant and sustained upward trend in the concentration of the pollutant or indicator of pollution. Quality checks: Within-schema check: the option 'Not applicable' is only valid if gwPollutantUpwardTrend is 'No'.

string (1)

Mandatory

8.1

POLLEXNTC

Required. Indicate if there are exceedances of the pollutant or indicator which are not considered as failures to achieving good chemical status (cases in which Article 4(2)c of the GWD applies).

string (1)

Mandatory

8.2

LEVELSET

Required. Indicate whether a background level of natural substances has been set.

string (1)

Mandatory

8.3

LEVELVALUE

Conditional. If a background level is set, report the numeric value or range of the natural background level. Quality checks: Conditional check: report if and only if 'gwPollutantBackgroundLevelSet' is 'Yes'.

string (100)

Conditional, mandatory for 'GwPollutant​BackgroundLevelSet' = 'Yes'.

8.4

LEVELUNIT

Conditional. If a background level is set, select the relevant units for the natural background concentrations or levels (the reporting unit of Conductivity is milli Siemens per metre). Quality checks: Conditional check: report if and only if 'GwPollutantBackgroundLevelSet' is 'Yes'.

string (2)

Conditional, mandatory for 'GwPollutant​BackgroundLevelSet' = 'Yes'.