0.0

TEMPLATE

Vorgegebener Schablonenname, schreibgeschützt

string (50)

Mandatory

Kat.I

1.0

WB_CAT

Wasserkörperkategorie

string (2)

Mandatory

Kat.I

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

Kat.I

1.3

EU_CD_WB

Fremdschlüssel zu gemeldeten Wasserkörpern. Dies ist der internationaler Code des WaterBody. Der Code setzt sich zusammen aus dem MemberStateCode, dem Alpha-2 Schlüssel des FeatureClassCodes (z.B. RW für RiverWaterBody), dem Country State Code und einer landesweit eindeutigen Nummer. Generell: <MemberStateCode>_ <FeatureClassCode>_ <CountryStateCode>_<ID>

string (42)

Mandatory, primary key

Kat.I

3.0

PSCODE

Select each priority substance for which one or more of the following circumstances occur in the relevant water body: - The substance is causing failure of chemical status due to exceedance of the relevant EQS (element SwPrioritySubstanceCausingFailure and swPrioritySubstanceExceedanceType) - The priority substance has improved from poor to good chemical status since the first RBMP (element SwPrioritySubstanceImprovingChemicalStatus) - The more stringent EQSs adopted in Directive 2013/39/EU caused the status of the surface water body to appear to deteriorate (element SwPrioritySubstanceEffectStatusNewThresholds). Fehlwert: -9999

string (14)

Mandatory, primary key

Kat.I

3.1

FAILRBSP

Conditional. If the status or potential of QE 3-3 River Basin Specific Pollutants is less than good, indicate the CAS Number and name of the RBSP(s). The RBSPs selected from the enumeration list must be included in the methodology schema (SWMET/SWRBSP/RBSP) where details of all RBSPs’ good-moderate EQS are reported, i.e. the RBSPs reported in this element are those that are failing their associated good-moderate EQS in this surface water body. Quality checks: Element check: A valid option must be selected from the enumeration list. More than one option can be selected. Conditional check: Report if QE33RiverBasinSpecificPollutantsValue = ‘3’. Cross-schema check: The selected RBSPs must be consistent with the values reported in SWMET/SWRBSP/RBSP. Fehlwert: -9999

string (15)

Mandatory for QE33RiverBasin​SpecificPollutants = '3', primary key

Kat.I

3.2

FAILRBS_OT

Report CAS number and name of the RBSP failing if not on the enumeration list under SwFailingRBSP. Quality checks: Conditional check: report at least 1 if 'Other chemical parameter' is chosen under 'SwFailingRBSP'. Fehlwert: -9999

string (100)

Mandatory, primary key

Kat.I

5.0

INS_WHEN

Erstellungsdatum des Datensatzes

date (8)

Mandatory

YYYYMMDD

Kat.I

5.1

INS_BY

Ansprechpartner

string (15)

Mandatory

Kat.I

5.2

RBD_CD

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

string (4)

Mandatory

Kat.I

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

Kat.I

6.3

CHEMEXTYPE

Required. Report which type(s) of exemption(s) apply if good chemical status is not expected to be achieved by 2015 for that priority substance. If there are exceedances of the EQSs made more stringent in 2013 (for substances Anthracene, Brominated diphenylethers, Fluoranthene, Lead and its compounds, Naphthalene, Nickel and its compounds and Polyaromatic hydrocarbons (PAH)), report which type(s) of exemption(s) apply if good chemical status is not expected to be achieved by 2021. More than one exemption may apply to a surface water body. Article 4(6) exemptions can also be reported if relevant for chemical status (e.g. accidents). Article 4(7) exemptions are not relevant for good chemical status and therefore cannot be reported. Quality checks: Within-schema check: The option 'No exemption' is not compatible with any other. Therefore, if reported, no more instances of 'swChemicalExemptionType' should be reported. The options 'Article4(7) - New modification' and 'Article4(7) - Sustainable human development' are not valid for chemical status and therefore cannot be reported.

string (254)

Conditional, mandatory for PSCODE not like '-9999'

Kat.I

6.4

CHEMEXPRE

Conditional. If any Article 4(4) or 4(5) exemptions apply to this surface water body for chemical status, report the significant pressure(s) that are causing failure in order to justify the exemption(s). Article 4(6) exemptions can also be chosen if relevant for chemical status (e.g. accidents). Article 4(7) exemptions are not relevant for good chemical status and therefore cannot be selected. Quality checks: Element check: A valid option must be selected from the enumeration list. More than one option can be selected. Conditional check: If SWChemicalExemptionType is not ‘No exemption’, at least one significant pressure type must be selected from the enumeration list. Within-schema check: 'Article 4(7)…' options are not valid.

string (254)

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

Kat.I

7.2

PS_FAIL

Required. Indicate if the priority substance is causing failure to achieve good chemical status. Information on exceedances from ubiquitous substances should be reported. For substances for which EQS were made more stringent in the 2013 amendment of the EQS Directive (Anthracene, Brominated diphenylethers, Fluoranthene, Lead and its compounds, Naphthalene, Nickel and its compounds and Polyaromatic hydrocarbons (PAH)), exceedances of either the 2008 EQS or the 2013 EQS, or both, should be reported here. Exceedances of the latter should be reported even when swChemicalStatusValue is good on the basis of the less stringent 2008 standards, in order to enable the reporting of swChemicalExceedancesType and, if appropriate, of swChemicalExemptionType and swChemicalExemptionPressure. The substances causing exceedances to the 2013 EQSs but not to the 2008 EQSs should also be reported under schema element swEffectStatusNewThresholds. See table at the end of this section of the guidance on different scenarios for these substances and the corresponding reporting values. Quality checks: If swChemicalStatusValue is '3', at least 1 substance should be reported as 'Yes' in swPrioritySubstanceCausingFailure. The substances reported under swEffectStatusNewThresholds must be reported here as exceedances.

string (1)

Conditional, mandatory for PSCODE not like '-9999'

Kat.I

7.3

PS_EXCTYPE

Conditional. For each Priority Substance exceeding EQS, indicate which EQS is exceeded. 'AA EQS' = Annual Average of the EQS. 'MAC EQS' = Maximum Allowable Concentration of the EQS. 'Both' = Both.Quality checks: Conditional check: report if 'swPrioritySubstanceCausingFailure' is 'Yes'

string (1)

Conditional, mandatory for 'swPriority​SubstanceCausing​Failure' = 'Yes'

Kat.I

7.4

PS_IMPSTAT

Required. Report if the Priority Substance improved from poor to good chemical status since the first RBMP. For the Priority Substances for which the EQSs have changed in the 2013 amendment of the EQS Directive (2013/39/EU), the improvement should refer to the 2008 EQS.

string (1)

Conditional, mandatory for PSCODE not like '-9999'

Kat.I

7.5

PS_NEWTHR

Required. If the priority substance is one of the seven for which more stringent EQSs were adopted in Directive 2013/39/EU, indicate if the new standard caused the status of the surface water body to appear to deteriorate. If not one of the seven report 'Not applicable'. The assessment of failure according to the new, more stringent standards is relevant for the purpose of meeting the 2021 good chemical status objective as set in Article 3 paragraph 1a(i) of EQS Directive 2008/105/EC as amended by Directive 2013/39/EU. Quality checks: The options 'Yes' and 'No' are only valid for the following seven priority substances: Anthracene, Brominated diphenylethers, Fluoranthene, Lead and its compounds, Naphthalene, Nickel and its compounds, Polyaromatic hydrocarbons (PAH). For all other priority substances the option 'Not applicable' must be reported.

string (1)

Conditional, mandatory for PSCODE not like '-9999'

Kat.I