internal numerical database code (identification of country, reported period and data delivery version).

internal numerical database code connecting data to proper reporter (link to the table T_Reporter).

Member State abbreviation.

Note: ISO 3166-alpha-2 code

Report ID.

Note: All data are linked to Report ID defined in form Country and Contact Details

Version of reported data.

Situation as at.

Note: reference date

Reported Year.

Note: reference year

internal numerical database code (identification of the country and culture).

Specification of the country (link to the field lovID in the codelist table T_LOV).

Note: 65 = Austria, 66 = Belgium, ..., 91 = Slovakia, 92 = United Kingdom, 132 = Croatia

Member State abbreviation.

Note: ISO 3166-alpha-2 code

Member State name.

Culture code.

internal numerical database code of Receiving area.

internal numerical database code connecting data to proper country, reported period and data delivery version (link to the table T_ReportPeriod).

Member State abbreviation.

Note: ISO 3166-alpha-2 code

Status of the Receiving area (link to the field lovID in the codelist table T_LOV).

Note: 105 = inactive, 106=active

ID of the Receiving area.

Name of the Receiving area.

Type of the Receiving area (link to the field lovID in the codelist table T_LOV).

Note: 96 = application of Article 5(4), 97 = application of Article 5(8), 98 = catchment of sensitive area, 99 = less sensitive area, 100 = normal area, 101 = sensitive area

Related Sensitive area.

Note: -999 = data not available

Starting date of application of Art. 5(8) of UWWTD.

Parameters subject to More Stringent Treatment: N.

Note: 0 = false, -1 = true

Parameters subject to More Stringent Treatment: P.

Note: 0 = false, -1 = true

Parameters subject to More Stringent Treatment: Other.

Note: 0 = false, -1 = true

Last date of designation or revision/ in case Art. 5(8) and 5(2-3) is applied: Starting date of application of Art. 5(2-3).

Designation Criteria (a, b, c): a - Nitrogen.

Note: 0 = false, -1 = true

Designation Criteria (a, b, c): a - Phosphorus.

Note: 0 = false, -1 = true

Designation Criteria (a, b, c): b.

Note: 0 = false, -1 = true

Designation Criteria (a, b, c): c.

Note: 0 = false, -1 = true

Designation criteria c - relevant EU-Directives and related parameters.

Less sensitive area - Designation criteria (Annex II B): Morphology.

Note: 0 = false, -1 = true

Less sensitive area - Designation criteria (Annex II B): Hydrology.

Note: 0 = false, -1 = true

Less sensitive area - Designation criteria (Annex II B): Specific hydraulic conditions.

Note: 0 = false, -1 = true

Less sensitive area - Designation criteria (Annex II B): Absence of risk of transfer of discharged load to adjacent areas.

Note: 0 = false, -1 = true

Starting date of application of Art. 5(4) of UWWTD.

Indication of application of Art. 5(4) of UWWTD.

Note: 0 = false, -1 = true

internal numerical database code of Agglomeration.

Status of the Agglomeration (link to the field lovID in the codelist table T_LOV).

Note: 105 = inactive, 106 = active

internal numerical database code connecting data to proper country, reported period and data delivery version (link to the table T_ReportPeriod).

Member State abbreviation.

Note: ISO 3166-alpha-2 code

ID of the Agglomeration.

Name of the Agglomeration.

internal numerical database code of Region (NUTS)) (link to the field nutID in the codelist table T_NUTS).

Latitude (ETRS89, decimal degrees).

Longitude (ETRS89, decimal degrees).

Generated load (p.e.).

internal numerical database code of the Big city / Big discharger (link to the field bigID in the codelist table T_BigCity).

Methods used for calculation of the generated load of the agglomeration.

Are there any significant changes of the generated load compared to the previous Report? (link to the field lovID in the codelist table T_LOV).

Note: 122 = No, 123 = Yes

Comments on significant changes of the generated load compared to the previous reported load.

Date of the relevant deadline of UWWTD or Transitional Period.

Rate of generated load of agglomeration collected through collecting system (% of p.e.).

Method used to obtain the %-value (calculated or estimated, for aggC1) (link to the field lovID in the codelist table T_LOV).

Note: 14 = calculated, 15 = estimated

Rate of generated load of agglomeration addressed through IAS (% of p.e.).

Method used to obtain the %-value (calculated or estimated, for aggC2) (link to the field lovID in the codelist table T_LOV).

Note: 14 = calculated, 15 = estimated

Rate of generated load of agglomeration not collected through collecting systems and not addressed through IAS (% of p.e.).

Method used to obtain the %-value (calculated or estimated, for aggPercWithoutTreatment) (link to the field lovID in the codelist table T_LOV).

Note: 0 = information not available, 14 = calculated, 15 = estimated

internal numerical database code of UWWTP / collecting system without treatment.

Status of the UWWTP (link to the field lovID in the codelist table T_LOV).

Note: 105 = inactive, 106 = active

internal numerical database code connecting data to proper country, reported period and data delivery version (link to the table T_ReportPeriod).

Member State abbreviation.

Note: All data are linked to rpMStateKey; ISO 3166-alpha-2 code

internal numerical database code of agglomeration (link to the table T_Agglomerations).

ID of UWWTP / collecting system without treatment.

Name of UWWTP / collecting system without treatment.

Identification whether it is the existing UWWTP (in operation) or a collecting system without UWWTPs (link to the field lovID in the codelist table T_LOV).

Note: 111 = collecting system connected to UWWTP, 112 = collecting system not connected to UWWTP

Date of closing of the UWWTP.

Note: year

Explanation for closing of the UWWTP / What happened with the wastewater since last reporting exercise.

Latitude (ETRS89, decimal degrees).

Longitude (ETRS89, decimal degrees).

internal numerical database code of Region (NUTS) (link to the field nutID in the codelist table T_NUTS).

Load entering UWWTP (p.e.).

Organic design capacity (p.e.).

Primary treatment.

Note: 0 = false, -1 = true

Secondary treatment.

Note: 0 = false, -1 = true

More stringent treatment.

Note: 0 = false, -1 = true

N-removal.

Note: 0 = false, -1 = true

P-removal.

Note: 0 = false, -1 = true

UV.

Note: 0 = false, -1 = true

Chlorination.

Note: 0 = false, -1 = true

Ozonation.

Note: 0 = false, -1 = true

Sand filtration.

Note: 0 = false, -1 = true

Micro filtration.

Note: 0 = false, -1 = true

Other type of more stringent treatment.

Note: 0 = false, -1 = true

Please specify other type of more stringent treatment.

Treatment performance: BOD5 (link to the field lovID in the codelist table T_LOV).

Note: 0 = data not available, 1 = fail, 2 = pass, 94 = not relevant

Treatment performance: COD (link to the field lovID in the codelist table T_LOV).

Note: 0 = data not available, 93 = fail, 95 = pass, 94 = not relevant

Treatment performance: TSS (link to the field lovID in the codelist table T_LOV).

Note: 93 = fail, 95 = pass, 94 = not relevant

Treatment performance: N (link to the field lovID in the codelist table T_LOV).

Note: 93 = fail, 95 = pass, 94 = not relevant

Treatment performance: P (link to the field lovID in the codelist table T_LOV).

Note: 93 = fail, 95 = pass, 94 = not relevant

Treatment performance: Other (link to the field lovID in the codelist table T_LOV).

Note: 93 = fail, 95 = pass, 94 = not relevant

internal numerical database code of joint entry of agglomeration and UWWTP / collecting system without treatment.

internal numerical database code connecting data to proper country, reported period and data delivery version (link to the table T_ReportPeriod).

Member State abbreviation.

Note: ISO 3166-alpha-2 code

internal numerical database code of UWWTP / collecting system without treatment (link to the table T_UWWTPs).

ID of UWWTP / collecting system without treatment (link to the field uwwCode in the table T_UWWTPs).

Name of the UWWTP (link to the field uwwName in the table T_UWWTPs).

internal numerical database code of agglomeration entering that treatment plant (link to the tableT_Agglomerations).

ID of the agglomeration entering that treatment plant (link to the field aggCode in the table T_Agglomerations).

Name of the agglomeration entering that treatment plant (link to the field aggName in the table T_Agglomerations).

% of load of agglomeration collected in collecting system and entering that treatment plant.

Method used to obtain the % value (link to the field lovID in the codelist table T_LOV).

Note: 14 = calculated, 15 = estimated

Rate of generated load of agglomeration transported to this UWWTP by trucks (%).

internal numerical database code of Discharge point.

Status of the Discharge point (link to the field lovID in the codelist table T_LOV).

Note: 105 = inactive, 106 = active

internal numerical database code connecting data to proper country, reported period and data delivery version (link to the table T_ReportPeriod).

Member State abbreviation.

Note: ISO 3166-alpha-2 code

internal numerical database code of UWWTP / collecting system without treatment (link to the table T_UWWTPs).

ID of the Discharge point.

Name of the Discharge point.

internal numerical database code of Region (NUTS) (link to the field nutID in the codelist table T_NUTS).

Latitude (ETRS89, decimal degrees).

Longitude (ETRS89, decimal degrees).

Water body type (link to the field lovID in the codelist table T_LOV).

Note: 113 and 118 = discharge in coastal water, 114 and 119 = discharge to estuary, 115 = discharge in freshwater, 116 and 120 = discharge on land catchment of fresh water, 117 and 121 = discharge on land catchment of coastal water

Purpose of discharge on land.

Type of Receiving area (link to the field lovID in the codelist table T_LOV).

Note: 96 = application of Article 5(4), 97 = application of Article 5(8), 98 = catchment of sensitive area, 99 = less sensitive area, 100 = normal area, 101 = sensitive area

internal numerical database code of Receiving area (link to the table T_ReceivingAreas).

Note: Relevant in case SA, CSA or LSA was chosen for parameter dcpTypeOfReceivingArea

Availability of surface waters (link to the field lovID in the codelist table T_LOV).

Note: 122 = no, 123 = yes

ID of WFD waterbody.

Comprehensive studies indicate that the discharge does not adversely affect the environment (link to the field lovID in the codelist table T_LOV).

Note: 122 = no, 123 = yes

Member State provided these studies to the Commission (link to the field lovID in the codelist table T_LOV).

Note: 122 = no, 123 = yes

Commission formally accept that the conditions under Art. 6(2) are met (link to the field lovID in the codelist table T_LOV).

Note: 122 = no, 123 = yes

ID of WFD groundwater body.

ID of receiving water.

ID of WFD sub-unit.

ID of WFD river basin district.

Remarks.

Reference date of the WFD river basin district.

Reference date of the WFD waterbody.

Reference date of the WFD groundwater body.

Reference date of the receiving water.

Reference date of the WFD sub-unit.

internal numerical database code.

Specification of the country (link to the field lovID in the codelist table T_LOV).

Note: 65 = Austria, 66 = Belgium, ..., 91 = Slovakia, 92 = United Kingdom, 132 = Croatia

internal numerical database code connecting data to proper country, reported period and data delivery version (link to the table T_ReportPeriod).

Member State abbreviation.

Note: ISO 3166-alpha-2 code

Yearly production of sludge (t DS/y).

Sludge discharged into surface waters: Pipelines (t DS/y).

Sludge discharged into surface waters: Ships (t DS/y).

Sludge discharged into surface waters: Others (t DS/y).

Sludge re-used: Soil and agriculture (t DS/y).

Sludge re-used: Others (t DS/y).

Sludge disposed: Landfill (t DS/y).

Sludge disposed: Incineration (t DS/y).

Sludge disposed: Others (t DS/y).

Remarks.

Rate of treated waste water re-used (% of total volume treated).

Re-use of treated waste water in: Agriculture.

Note: 0 = false, -1 = true

Re-use of treated wastewater in: Industry.

Note: 0 = false, -1 = true

Re-use of treated waste water in: Others.

Note: 0 = false, -1 = true

Re-use of treated waste water: Explanation of others.

Status of the UWWTP (link to the field lovID in the codelist table T_LOV).

Note: 105 = inactive, 106 = active

Member State abbreviation.

Note: ISO 3166-alpha-2 code

internal numerical database code of UWWTP / collecting system without treatment (link to the table T_UWWTPs).

ID of UWWTP / collecting system without treatment (link to the field uwwCode in the table T_UWWTPs).

Name of the UWWTP (link to the field uwwName in the table T_UWWTPs).

Incoming loads (t/y): BOD.

Incoming loads (t/y): COD.

Incoming loads (t/y): Ntot.

Incoming loads (t/y): Ptot.

Discharged loads (t/y): BOD.

Discharged loads (t/y): COD.

Discharged loads (t/y): Ntot.

Discharged loads (t/y): Ptot.

information on the data flagging.

Note: Y = record flagged

reference to the detailed information on the QA of the emission load data.

internal numerical database code of Agglomeration (can't be used as link to the table T_Agglomerations).

Status of the Agglomeration (link to the field lovID in the codelist table T_LOV).

Note: 105 = inactive, 106 = active

internal numerical database code connecting data to proper country, reported period and data delivery version (link to the table T_ReportPeriod).

ID of the Agglomeration (link to the table T_Agglomerations).

Name of the Agglomeration (link to the table T_Agglomerations).

number of inhabitants connected to Individual Appropriate Systems of waste water treatment.

number of inhabitants not to collecting systems nor to Individual Appropriate Systems of waste water treatment.

Memo.

internal numerical database code of UWWTP / collecting system without treatment (can't be used as link to the table T_UWWTPs).

Status of the UWWTP (link to the field lovID in the codelist table T_LOV).

Note: 105 = inactive, 106 = active

internal numerical database code connecting data to proper country, reported period and data delivery version (link to the table T_ReportPeriod).

ID of UWWTP / collecting system without treatment (link to the table T_UWWTPs).

Name of UWWTP / collecting system without treatment (link to the table T_UWWTPs).

Identification whether it is the existing UWWTP (in operation) or a collecting system without UWWTPs (link to the field lovID in the codelist table T_LOV).

Note: 111 = collecting system connected to UWWTP, 112 = collecting system not connected to UWWTP

E-PRTR code of waste water treatment plant under which it is reported in E-PRTR database.

number of inhabitants connected to waste water treatment plant.

Indication of application of more stringent effluent standards as compared to UWWTD.

Indication of application of more stringent effluent standards for N total as compared to UWWTD.

Indication of application of more stringent effluent standards for Ptotal as compared to UWWTD.

Indication of application of more stringent effluent standards for BOD as compared to UWWTD.

Indication of application of more stringent effluent standards for other parameters as compared to UWWTD.

Specification of effluent treatment.

Note: 1-fully treated effluent- dry and wet weather, partially treated storm water; 2-fully treated effluent- dry and wet weather; 3-fully treated effluent- dry weather;

Remarks on the CSO.

Memo.

internal numerical database code connecting data to proper country, reported period and data delivery version (link to the table T_ReportPeriod).

Number of inhabitants connected to IAS.

Number of inhabitants not connected to collecting system nor served by IAS.

Number of inhabitants connected to collecting system or treatment plant.

Number of inhabitants connected to collecting system or treatment plant serving agglomeration smaller than 2 000 p.e..

Number of inhabitants connected to collecting system or treatment plant serving agglomeration smaller than 2 000 p.e..

Number of inhabitants in agglomeration smaller than 2 000 p.e..

brief text information on the fate of generated wastewater.

internal numerical database code of the Big city.

ID of the Big city.

Member State abbreviation.

Note: ISO 3166-alpha-2 code

Name of the BigCity.

internal numerical database code of the NUTS.

ID of the NUTS.

Member State abbreviation.

Note: ISO 3166-alpha-2 code

Name of the NUTS.

internal numerical database code of the LOV.

Name of the LOV.

Key of the LOV.

Value of the LOV.