0.0

TEMPLATE

Vorgegebener Schablonenname, schreibgeschützt

string (24)

Mandatory

1.1

EU_CD_WB

Internationaler Schluessel des WaterBody.

string (42)

Mandatory, primary key

1.2

WB_CAT

Wasserkörperkategorie

string (2)

Mandatory, primary key

2.1

ECOEXTYPE

Report which type(s) of exemption apply if good ecological status or potential is not expected to be achieved by 2021. In case surfaceWaterBodyCategory is 'TeW', 'No exemption' should be reported and interpreted as 'Not applicable'. Quality checks: Within-schema check: 'No exemption' is not compatible with any other option. Within-schema check: If swEcologicalStatusOrPotentialExpectedAchievementDate is not '2021 or earlier' then the option 'No exemption' is not possible. One or more of the other options must be selected. Within-schema check: if surfaceWaterBodyCategory is 'TeW' then 'No exemption' must be selected. Prüfung: Ist ECO_POT oder ECO_STAT des referenzierten WK nicht gut, so ist der Wert 'No exemption' nicht zulässig. Eine oder mehrere andere Optionen müssen gewählt werden. Mehrfachnennungen sind möglich kommasepariert ohne Leerstellen.

string (254)

Conditional, mandatory for WB_CAT = "RW" or WB_CAT = "LW" or WB_CAT = "TW" or WB_CAT = "CW"

2.2

ECOEXPRESS

Conditional. If any Article 4(4), Article 4(5) and/or Article 4(7) exemptions apply to this surface water body for ecological status, report the significant pressure(s) that are causing failure in order to justify the exemption(s). Quality checks: Conditional check: If SwEcologicalExemptionType 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). Mehrfachnennungen sind möglich kommasepariert ohne Leerstellen.

string (254)

Conditional, mandatory for SwEcological​ExemptionType <> 'No exemption'

2.3

QUAEXTYPE

Report which type(s) of exemption apply if good quantitative status is not expected to be achieved by 2021. More than one exemption may apply to a groundwater body. Quality checks: Within-schema check: 'No exemption' is not compatible with any other option. Within-schema check: if gwQuantitativeStatusExpectedAchievementDate is not ‘2021 or earlier’ then the option 'No exemption' is not possible. One or more of the other options must be selected. Prüfung: Ist QUANT_STAT des referenzierten WK nicht gut, so ist der Wert 'No exemption' nicht zulässig. Eine oder mehrere andere Optionen müssen gewählt werden.

string (254)

Conditional, mandatory for WB_CAT = "GW"

2.4

QUAEXPRESS

If any Article 4(4), Article 4(5), Article 4(6) and/or Article 4(7) exemptions apply to this groundwater body for quantitative status, report the significant pressure(s) that are causing failure in order to justify the exemption(s). Quality checks: Conditional check: If GwQuantitativeExemptionType 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.

string (254)

Conditional, mandatory for GwQuantitative​ExemptionType <> 'No exemption'

4.0

QE11TYP

Required. Report which type(s) of exemption(s) apply to this surface water body and QE. More than one exemption may apply. If SurfaceWaterCategory is 'TeW' then 'No exemption' must be selected, which should be interpreted as 'Not relevant'. Quality check: Element check: QEXEcologicalExemptionType must be reported. A valid option must be selected from the enumeration list. More than one option can be selected. Within-schema check: the option 'No exemption' is not compatible with any other. If SurfaceWaterCategory is 'TeW' then 'No exemption' must be selected.

string (254)

Conditional, mandatory for WB_CAT = "RW" or WB_CAT = "LW" or WB_CAT = "TW" or WB_CAT = "CW"

4.01

QE12TYP

Required. Report which type(s) of exemption(s) apply to this surface water body and QE. More than one exemption may apply. If SurfaceWaterCategory is 'TeW' then 'No exemption' must be selected, which should be interpreted as 'Not relevant'. Quality check: Element check: QEXEcologicalExemptionType must be reported. A valid option must be selected from the enumeration list. More than one option can be selected. Within-schema check: the option 'No exemption' is not compatible with any other. If SurfaceWaterCategory is 'TeW' then 'No exemption' must be selected.

string (254)

Conditional, mandatory for WB_CAT = "RW" or WB_CAT = "LW" or WB_CAT = "TW" or WB_CAT = "CW"

4.02

QE121TYP

Required. Report which type(s) of exemption(s) apply to this surface water body and QE. More than one exemption may apply. If SurfaceWaterCategory is 'TeW' then 'No exemption' must be selected, which should be interpreted as 'Not relevant'. Quality check: Element check: QEXEcologicalExemptionType must be reported. A valid option must be selected from the enumeration list. More than one option can be selected. Within-schema check: the option 'No exemption' is not compatible with any other. If SurfaceWaterCategory is 'TeW' then 'No exemption' must be selected.

string (254)

Conditional, mandatory for WB_CAT = "LW" or WB_CAT = "TW" or WB_CAT = "CW"

4.03

QE122TYP

Required. Report which type(s) of exemption(s) apply to this surface water body and QE. More than one exemption may apply. If SurfaceWaterCategory is 'TeW' then 'No exemption' must be selected, which should be interpreted as 'Not relevant'. Quality check: Element check: QEXEcologicalExemptionType must be reported. A valid option must be selected from the enumeration list. More than one option can be selected. Within-schema check: the option 'No exemption' is not compatible with any other. If SurfaceWaterCategory is 'TeW' then 'No exemption' must be selected.

string (254)

Conditional, mandatory for WB_CAT = "RW" or WB_CAT = "LW" or WB_CAT = "TW" or WB_CAT = "CW"

4.04

QE123TYP

Required. Report which type(s) of exemption(s) apply to this surface water body and QE. More than one exemption may apply. If SurfaceWaterCategory is 'TeW' then 'No exemption' must be selected, which should be interpreted as 'Not relevant'. Quality check: Element check: QEXEcologicalExemptionType must be reported. A valid option must be selected from the enumeration list. More than one option can be selected. Within-schema check: the option 'No exemption' is not compatible with any other. If SurfaceWaterCategory is 'TeW' then 'No exemption' must be selected.

string (254)

Conditional, mandatory for WB_CAT = "RW" or WB_CAT = "LW"

4.05

QE124TYP

Required. Report which type(s) of exemption(s) apply to this surface water body and QE. More than one exemption may apply. If SurfaceWaterCategory is 'TeW' then 'No exemption' must be selected, which should be interpreted as 'Not relevant'. Quality check: Element check: QEXEcologicalExemptionType must be reported. A valid option must be selected from the enumeration list. More than one option can be selected. Within-schema check: the option 'No exemption' is not compatible with any other. If SurfaceWaterCategory is 'TeW' then 'No exemption' must be selected.

string (254)

Conditional, mandatory for WB_CAT = "RW" or WB_CAT = "LW" or WB_CAT = "TW" or WB_CAT = "CW"

4.06

QE13TYP

Required. Report which type(s) of exemption(s) apply to this surface water body and QE. More than one exemption may apply. If SurfaceWaterCategory is 'TeW' then 'No exemption' must be selected, which should be interpreted as 'Not relevant'. Quality check: Element check: QEXEcologicalExemptionType must be reported. A valid option must be selected from the enumeration list. More than one option can be selected. Within-schema check: the option 'No exemption' is not compatible with any other. If SurfaceWaterCategory is 'TeW' then 'No exemption' must be selected.

string (254)

Conditional, mandatory for WB_CAT = "RW" or WB_CAT = "LW" or WB_CAT = "TW" or WB_CAT = "CW"

4.07

QE14TYP

Required. Report which type(s) of exemption(s) apply to this surface water body and QE. More than one exemption may apply. If SurfaceWaterCategory is 'TeW' then 'No exemption' must be selected, which should be interpreted as 'Not relevant'. Quality check: Element check: QEXEcologicalExemptionType must be reported. A valid option must be selected from the enumeration list. More than one option can be selected. Within-schema check: the option 'No exemption' is not compatible with any other. If SurfaceWaterCategory is 'TeW' then 'No exemption' must be selected.

string (254)

Conditional, mandatory for WB_CAT = "RW" or WB_CAT = "LW" or WB_CAT = "TW" or WB_CAT = "CW"

4.08

QE21TYP

Required. Report which type(s) of exemption(s) apply to this surface water body and QE. More than one exemption may apply. If SurfaceWaterCategory is 'TeW' then 'No exemption' must be selected, which should be interpreted as 'Not relevant'. Quality check: Element check: QEXEcologicalExemptionType must be reported. A valid option must be selected from the enumeration list. More than one option can be selected. Within-schema check: the option 'No exemption' is not compatible with any other. If SurfaceWaterCategory is 'TeW' then 'No exemption' must be selected.

string (254)

Conditional, mandatory for WB_CAT = "RW" or WB_CAT = "LW" or WB_CAT = "TW" or WB_CAT = "CW"

4.09

QE22TYP

Required. Report which type(s) of exemption(s) apply to this surface water body and QE. More than one exemption may apply. If SurfaceWaterCategory is 'TeW' then 'No exemption' must be selected, which should be interpreted as 'Not relevant'. Quality check: Element check: QEXEcologicalExemptionType must be reported. A valid option must be selected from the enumeration list. More than one option can be selected. Within-schema check: the option 'No exemption' is not compatible with any other. If SurfaceWaterCategory is 'TeW' then 'No exemption' must be selected.

string (254)

Conditional, mandatory for WB_CAT = "RW" or WB_CAT = "LW" or WB_CAT = "TW" or WB_CAT = "CW"

4.10

QE23TYP

Required. Report which type(s) of exemption(s) apply to this surface water body and QE. More than one exemption may apply. If SurfaceWaterCategory is 'TeW' then 'No exemption' must be selected, which should be interpreted as 'Not relevant'. Quality check: Element check: QEXEcologicalExemptionType must be reported. A valid option must be selected from the enumeration list. More than one option can be selected. Within-schema check: the option 'No exemption' is not compatible with any other. If SurfaceWaterCategory is 'TeW' then 'No exemption' must be selected.

string (254)

Conditional, mandatory for WB_CAT = "RW" or WB_CAT = "LW" or WB_CAT = "TW" or WB_CAT = "CW"

4.11

QE311TYP

Required. Report which type(s) of exemption(s) apply to this surface water body and QE. More than one exemption may apply. If SurfaceWaterCategory is 'TeW' then 'No exemption' must be selected, which should be interpreted as 'Not relevant'. Quality check: Element check: QEXEcologicalExemptionType must be reported. A valid option must be selected from the enumeration list. More than one option can be selected. Within-schema check: the option 'No exemption' is not compatible with any other. If SurfaceWaterCategory is 'TeW' then 'No exemption' must be selected.

string (254)

Conditional, mandatory for WB_CAT = "RW" or WB_CAT = "LW" or WB_CAT = "TW" or WB_CAT = "CW"

4.12

QE312TYP

Required. Report which type(s) of exemption(s) apply to this surface water body and QE. More than one exemption may apply. If SurfaceWaterCategory is 'TeW' then 'No exemption' must be selected, which should be interpreted as 'Not relevant'. Quality check: Element check: QEXEcologicalExemptionType must be reported. A valid option must be selected from the enumeration list. More than one option can be selected. Within-schema check: the option 'No exemption' is not compatible with any other. If SurfaceWaterCategory is 'TeW' then 'No exemption' must be selected.

string (254)

Conditional, mandatory for WB_CAT = "RW" or WB_CAT = "LW" or WB_CAT = "TW" or WB_CAT = "CW"

4.13

QE313TYP

Required. Report which type(s) of exemption(s) apply to this surface water body and QE. More than one exemption may apply. If SurfaceWaterCategory is 'TeW' then 'No exemption' must be selected, which should be interpreted as 'Not relevant'. Quality check: Element check: QEXEcologicalExemptionType must be reported. A valid option must be selected from the enumeration list. More than one option can be selected. Within-schema check: the option 'No exemption' is not compatible with any other. If SurfaceWaterCategory is 'TeW' then 'No exemption' must be selected.

string (254)

Conditional, mandatory for WB_CAT = "RW" or WB_CAT = "LW" or WB_CAT = "TW" or WB_CAT = "CW"

4.14

QE314TYP

Required. Report which type(s) of exemption(s) apply to this surface water body and QE. More than one exemption may apply. If SurfaceWaterCategory is 'TeW' then 'No exemption' must be selected, which should be interpreted as 'Not relevant'. Quality check: Element check: QEXEcologicalExemptionType must be reported. A valid option must be selected from the enumeration list. More than one option can be selected. Within-schema check: the option 'No exemption' is not compatible with any other. If SurfaceWaterCategory is 'TeW' then 'No exemption' must be selected.

string (254)

Conditional, mandatory for WB_CAT = "RW" or WB_CAT = "LW" or WB_CAT = "TW" or WB_CAT = "CW"

4.15

QE315TYP

Required. Report which type(s) of exemption(s) apply to this surface water body and QE. More than one exemption may apply. If SurfaceWaterCategory is 'TeW' then 'No exemption' must be selected, which should be interpreted as 'Not relevant'. Quality check: Element check: QEXEcologicalExemptionType must be reported. A valid option must be selected from the enumeration list. More than one option can be selected. Within-schema check: the option 'No exemption' is not compatible with any other. If SurfaceWaterCategory is 'TeW' then 'No exemption' must be selected.

string (254)

Conditional, mandatory for WB_CAT = "RW" or WB_CAT = "LW" or WB_CAT = "TW" or WB_CAT = "CW"

4.16

QE3161TYP

Required. Report which type(s) of exemption(s) apply to this surface water body and QE. More than one exemption may apply. If SurfaceWaterCategory is 'TeW' then 'No exemption' must be selected, which should be interpreted as 'Not relevant'. Quality check: Element check: QEXEcologicalExemptionType must be reported. A valid option must be selected from the enumeration list. More than one option can be selected. Within-schema check: the option 'No exemption' is not compatible with any other. If SurfaceWaterCategory is 'TeW' then 'No exemption' must be selected.

string (254)

Conditional, mandatory for WB_CAT = "RW" or WB_CAT = "LW" or WB_CAT = "TW" or WB_CAT = "CW"

4.17

QE3162TYP

Required. Report which type(s) of exemption(s) apply to this surface water body and QE. More than one exemption may apply. If SurfaceWaterCategory is 'TeW' then 'No exemption' must be selected, which should be interpreted as 'Not relevant'. Quality check: Element check: QEXEcologicalExemptionType must be reported. A valid option must be selected from the enumeration list. More than one option can be selected. Within-schema check: the option 'No exemption' is not compatible with any other. If SurfaceWaterCategory is 'TeW' then 'No exemption' must be selected.

string (254)

Conditional, mandatory for WB_CAT = "RW" or WB_CAT = "LW" or WB_CAT = "TW" or WB_CAT = "CW"

4.18

QE33TYP

Required. Report which type(s) of exemption(s) apply to this surface water body and QE. More than one exemption may apply. If SurfaceWaterCategory is 'TeW' then 'No exemption' must be selected, which should be interpreted as 'Not relevant'. Quality check: Element check: QEXEcologicalExemptionType must be reported. A valid option must be selected from the enumeration list. More than one option can be selected. Within-schema check: the option 'No exemption' is not compatible with any other. If SurfaceWaterCategory is 'TeW' then 'No exemption' must be selected. Mehrfachnennungen sind möglich kommasepariert ohne Leerstellen.

string (254)

Conditional, mandatory for WB_CAT = "RW" or WB_CAT = "LW" or WB_CAT = "TW" or WB_CAT = "CW"

5.0

ENOBJDT

Wird der ökologische bzw. quantitative Zustand bis 2021 nicht erreicht, so ist hier das geplante Datum der Zielerreichung anzugeben. Die Werte 6-9 sind nicht Teil der elektronischen Berichterstattung an die KOM und werden hierfür auf den Wert 5 zurückgeführt.

string (2)

Conditional, mandatory for Land_cd = "DE%" and ​ECO/POT/QUANT​_STAT > 2

SW, GW

5.1

ENOBJDT_CH

Wird der chemische Zustand bis 2021 nicht erreicht, so ist hier das geplante Datum der Zielerreichung anzugeben. Die Werte 6-9 sind nicht Teil der elektronischen Berichterstattung an die KOM und werden hierfür auf den Wert 5 zurückgeführt.

string (2)

Conditional, mandatory for Land_cd = "DE%" and CHEM_STAT > 2

SW, GW

7.1

WA_CD

Kennung fuer das Bearbeitunsgebiet bzw. den Koordinierungsraum. Der Code besteht aus einer vierstelligen Numerierung fuer das Bearbeitungsgebiet bzw. den Koordinierungsraum.

string (10)

Mandatory

7.2

RBD_CD

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

string (4)

Mandatory

7.3

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

7.4

DELIVERY

Datum der Datenbereitstellung

date (8)

Mandatory

YYYYMMDD

7.5

METADATA

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

string (255)

Mandatory

7.6

URL

URL einer optionalen Web-Seite zur objektbezogenen Einbindung eigener internetbasierter Informationsquellen. Der URL sollte stets in der Form “http://“-prefix aufgebaut werden.

string (255)

Optional