Waterbase-UWWTD (12 data tables, 3 codelists)

Data Table

18 min read

This is an old version, kept for reference only.

Go to latest version

This page was archived on 20 Nov 2020 with reason: Other (New version data-and-maps/data/waterbase-uwwtd-urban-waste-water-treatment-directive-7/waterbase-uwwtd was published)

The dataset contains data selected from the reporting of Member States as part of the UWWTD implementation. The dataset is divided into tables on: reported period, receiving areas, agglomerations, urban waste water treatment plants (UWWTPs), links agglomerations – UWWTPs, discharge points, and (at Member State level) sludge handling and treated waste water re-use. 3 codelist tables (big cities, NUTS, common list of values) and 3 add-on tables (for agglomerations, UWWTPs and MSLevel) are included as well.

Data and maps

Menu

Data tables

T_ReportPeriod (30 records)
Table specifies country, version of the reported data and reference year for reporting. Field repID is used in nearly all other tables for interlinking of these tables with table T_ReportPeriod. Field rptID is related to the table T_Reporter.

Field Name	Field definition	Note	Data Type
repID	internal numerical database code (identification of country, reported period and data delivery version)		Long integer
rptID	internal numerical database code connecting data to proper reporter (link to the table T_Reporter)		Long integer
rptMStateKey	Member State abbreviation	ISO 3166-alpha-2 code	Text(2)
repCode	Report ID	All data are linked to Report ID defined in form Country and Contact Details	Text(16)
repVersion	Version of reported data		Date(10)
repSituationAt	Situation as at	reference date	Date(10)
repReportedPeriod	Reported Year	reference year	Text(4)

T_Reporter (30 records)
Table provides information on reporting state.

Field Name	Field definition	Note	Data Type
rptID	internal numerical database code (identification of the country and culture)		Long integer
rptMState	Specification of the country (link to the field lovID in the codelist table T_LOV)	65 = Austria, 66 = Belgium, ..., 91 = Slovakia, 92 = United Kingdom, 132 = Croatia	Integer
rptMStateKey	Member State abbreviation	ISO 3166-alpha-2 code	Text(2)
rptMStateValue	Member State name		Text(64)
rptCulture	Culture code		Text(5)

T_ReceivingAreas (2766 records)
Table summarises information on designated sensitive areas, date of designation, the purpose of the designation, type of sensitive areas. Moreover, the table specifies which particular article of the UWWTD is applied in regards to designation of sensitive areas. Field repID is related to the table T_ReportPeriod. Fields rcaState and rcaType are related to the field lovID in the codelist table T_LOV.

Field Name	Field definition	Note	Data Type
rcaID	internal numerical database code of Receiving area		Long integer
repID	internal numerical database code connecting data to proper country, reported period and data delivery version (link to the table T_ReportPeriod)		Long integer
rptMStateKey	Member State abbreviation	ISO 3166-alpha-2 code	Text(2)
rcaState	Status of the Receiving area (link to the field lovID in the codelist table T_LOV)	105 = inactive, 106=active	Integer
rcaCode	ID of the Receiving area		Text(32)
rcaName	Name of the Receiving area		Text(255)
rcaType	Type of the Receiving area (link to the field lovID in the codelist table T_LOV)	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	Integer
rcaSensitiveArea	Related Sensitive area	-999 = data not available	Long integer
rcaDateArt58	Starting date of application of Art. 5(8) of UWWTD		Date
rcaParameterN	Parameters subject to More Stringent Treatment: N	0 = false, -1 = true	Boolean
rcaParameterP	Parameters subject to More Stringent Treatment: P	0 = false, -1 = true	Boolean
rcaParameterOther	Parameters subject to More Stringent Treatment: Other	0 = false, -1 = true	Boolean
rcaDateDesignation	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)		Date
rcaANitro	Designation Criteria (a, b, c): a - Nitrogen	0 = false, -1 = true	Boolean
rcaAPhos	Designation Criteria (a, b, c): a - Phosphorus	0 = false, -1 = true	Boolean
rcaB	Designation Criteria (a, b, c): b	0 = false, -1 = true	Boolean
rcaC	Designation Criteria (a, b, c): c	0 = false, -1 = true	Boolean
rcaCRelevantDirective	Designation criteria c - relevant EU-Directives and related parameters		Memo
rcaMorphology	Less sensitive area - Designation criteria (Annex II B): Morphology	0 = false, -1 = true	Boolean
rcaHydrologie	Less sensitive area - Designation criteria (Annex II B): Hydrology	0 = false, -1 = true	Boolean
rcaHydraulic	Less sensitive area - Designation criteria (Annex II B): Specific hydraulic conditions	0 = false, -1 = true	Boolean
rcaAbsenceRisk	Less sensitive area - Designation criteria (Annex II B): Absence of risk of transfer of discharged load to adjacent areas	0 = false, -1 = true	Boolean
rcaDateArt54	Starting date of application of Art. 5(4) of UWWTD		Date
rcaArt54Applied	Indication of application of Art. 5(4) of UWWTD	0 = false, -1 = true	Boolean

T_Agglomerations (27695 records)
Table contains information on agglomerations with generated load ≥ 2000 P.E., including names, coordinates, generated load and information whether the load generated is collected through collecting system or addressed via Individual Appropriate Systems (IAS) or not collected not addressed via IAS. Field repID is related to the table T_ReportPeriod. Field aggNUTS is related to the field nutID in the codelist table T_NUTS. Field bigID is related to the codelist table T_BigCity. Fields aggState, aggChanges, aggMethodC1, aggMethodC2 and aggMethodWithoutTreatment are related to the field lovID in the codelist table T_LOV.

Field Name	Field definition	Note	Data Type
aggID	internal numerical database code of Agglomeration		Long integer
aggState	Status of the Agglomeration (link to the field lovID in the codelist table T_LOV)	105 = inactive, 106 = active	Integer
repID	internal numerical database code connecting data to proper country, reported period and data delivery version (link to the table T_ReportPeriod)		Long integer
rptMStateKey	Member State abbreviation	ISO 3166-alpha-2 code	Text(2)
aggCode	ID of the Agglomeration		Text(32)
aggName	Name of the Agglomeration		Text(255)
aggNUTS	internal numerical database code of Region (NUTS)) (link to the field nutID in the codelist table T_NUTS)		Integer
aggLatitude	Latitude (ETRS89, decimal degrees)		Decimal
aggLongitude	Longitude (ETRS89, decimal degrees)		Decimal
aggGenerated	Generated load (p.e.)		Long integer
bigID	internal numerical database code of the Big city / Big discharger (link to the field bigID in the codelist table T_BigCity)		Long integer
aggCalculation	Methods used for calculation of the generated load of the agglomeration		Memo
aggChanges	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)	122 = No, 123 = Yes	Long integer
aggChangesComment	Comments on significant changes of the generated load compared to the previous reported load		Memo
aggPeriodOver	Date of the relevant deadline of UWWTD or Transitional Period		Date
aggC1	Rate of generated load of agglomeration collected through collecting system (% of p.e.)		Decimal
aggMethodC1	Method used to obtain the %-value (calculated or estimated, for aggC1) (link to the field lovID in the codelist table T_LOV)	14 = calculated, 15 = estimated	Integer
aggC2	Rate of generated load of agglomeration addressed through IAS (% of p.e.)		Decimal
aggMethodC2	Method used to obtain the %-value (calculated or estimated, for aggC2) (link to the field lovID in the codelist table T_LOV)	14 = calculated, 15 = estimated	Integer
aggPercWithoutTreatment	Rate of generated load of agglomeration not collected through collecting systems and not addressed through IAS (% of p.e.)		Decimal
aggMethodWithoutTreatment	Method used to obtain the %-value (calculated or estimated, for aggPercWithoutTreatment) (link to the field lovID in the codelist table T_LOV)	0 = information not available, 14 = calculated, 15 = estimated	Integer

T_UWWTPs (30043 records)
Table includes data on individual waste water treatment plants and collecting systems without UWWTP, their localisation, capacity and actual load treated, type of treatment, aggregated data on the performance of plants. Field repID is related to the table T_ReportPeriod. Field aggID is related to the table T_Agglomerations. Field uwwNUTS is related to the field nutID in the codelist table T_NUTS. Fields uwwState, uwwCollectingSystem, uwwBOD5Perf, uwwCODPerf, uwwTSSPerf, uwwNTotPerf, uwwPTotPerf and uwwOtherPerf are related to the field lovID in the codelist table T_LOV.

Field Name	Field definition	Note	Data Type
uwwID	internal numerical database code of UWWTP / collecting system without treatment		Long integer
uwwState	Status of the UWWTP (link to the field lovID in the codelist table T_LOV)	105 = inactive, 106 = active	Integer
repID	internal numerical database code connecting data to proper country, reported period and data delivery version (link to the table T_ReportPeriod)		Long integer
rptMStateKey	Member State abbreviation	All data are linked to rpMStateKey; ISO 3166-alpha-2 code	Text(2)
aggID	internal numerical database code of agglomeration (link to the table T_Agglomerations)		Long integer
uwwCode	ID of UWWTP / collecting system without treatment		Text(32)
uwwName	Name of UWWTP / collecting system without treatment		Text(255)
uwwCollectingSystem	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)	111 = collecting system connected to UWWTP, 112 = collecting system not connected to UWWTP	Integer
uwwDateClosing	Date of closing of the UWWTP	year	Integer
uwwHistorie	Explanation for closing of the UWWTP / What happened with the wastewater since last reporting exercise		Memo
uwwLatitude	Latitude (ETRS89, decimal degrees)		Decimal
uwwLongitude	Longitude (ETRS89, decimal degrees)		Decimal
uwwNUTS	internal numerical database code of Region (NUTS) (link to the field nutID in the codelist table T_NUTS)		Integer
uwwLoadEnteringUWWTP	Load entering UWWTP (p.e.)		Long integer
uwwCapacity	Organic design capacity (p.e.)		Long integer
uwwPrimaryTreatment	Primary treatment	0 = false, -1 = true	Boolean
uwwSecondaryTreatment	Secondary treatment	0 = false, -1 = true	Boolean
uwwOtherTreatment	More stringent treatment	0 = false, -1 = true	Boolean
uwwNRemoval	N-removal	0 = false, -1 = true	Boolean
uwwPRemoval	P-removal	0 = false, -1 = true	Boolean
uwwUV	UV	0 = false, -1 = true	Boolean
uwwChlorination	Chlorination	0 = false, -1 = true	Boolean
uwwOzonation	Ozonation	0 = false, -1 = true	Boolean
uwwSandFiltration	Sand filtration	0 = false, -1 = true	Boolean
uwwMicroFiltration	Micro filtration	0 = false, -1 = true	Boolean
uwwOther	Other type of more stringent treatment	0 = false, -1 = true	Boolean
uwwSpecification	Please specify other type of more stringent treatment		Text(255)
uwwBOD5Perf	Treatment performance: BOD5 (link to the field lovID in the codelist table T_LOV)	0 = data not available, 1 = fail, 2 = pass, 94 = not relevant	Integer
uwwCODPerf	Treatment performance: COD (link to the field lovID in the codelist table T_LOV)	0 = data not available, 93 = fail, 95 = pass, 94 = not relevant	Integer
uwwTSSPerf	Treatment performance: TSS (link to the field lovID in the codelist table T_LOV)	93 = fail, 95 = pass, 94 = not relevant	Integer
uwwNTotPerf	Treatment performance: N (link to the field lovID in the codelist table T_LOV)	93 = fail, 95 = pass, 94 = not relevant	Integer
uwwPTotPerf	Treatment performance: P (link to the field lovID in the codelist table T_LOV)	93 = fail, 95 = pass, 94 = not relevant	Integer
uwwOtherPerf	Treatment performance: Other (link to the field lovID in the codelist table T_LOV)	93 = fail, 95 = pass, 94 = not relevant	Integer

T_UWWTP_Agglo (28685 records)
Table is a connection table combining data on agglomeration and urban waste water treatment plants allowing repoting of situations where the ratio agglomeration:UWWTP is 1:n or m:1. Field repID is related to the table T_ReportPeriod. Field uwwID is related to the table T_UWWTPs. Fields aucUwwCode and aucUwwName are related to the fields uwwCode and uwwName in the table T_UWWTPs. Field aggID is related to the table T_Agglomerations. Fields aucAggCode and aucAggName are related to the fields aggCode and aggName in the table T_Agglomerations. Field aucMethodPercEnteringUWWTP is related to the field lovID in the codelist table T_LOV.

Field Name	Field definition	Note	Data Type
aucID	internal numerical database code of joint entry of agglomeration and UWWTP / collecting system without treatment		Long integer
repID	internal numerical database code connecting data to proper country, reported period and data delivery version (link to the table T_ReportPeriod)		Long integer
rptMStateKey	Member State abbreviation	ISO 3166-alpha-2 code	Text(2)
uwwID	internal numerical database code of UWWTP / collecting system without treatment (link to the table T_UWWTPs)		Long integer
aucUwwCode	ID of UWWTP / collecting system without treatment (link to the field uwwCode in the table T_UWWTPs)		Text(32)
aucUwwName	Name of the UWWTP (link to the field uwwName in the table T_UWWTPs)		Text(255)
aggID	internal numerical database code of agglomeration entering that treatment plant (link to the tableT_Agglomerations)		Long integer
aucAggCode	ID of the agglomeration entering that treatment plant (link to the field aggCode in the table T_Agglomerations)		Text(32)
aucAggName	Name of the agglomeration entering that treatment plant (link to the field aggName in the table T_Agglomerations)		Text(255)
aucPercEnteringUWWTP	% of load of agglomeration collected in collecting system and entering that treatment plant		Decimal
aucMethodPercEnteringUWWTP	Method used to obtain the % value (link to the field lovID in the codelist table T_LOV)	14 = calculated, 15 = estimated	Integer
aucPercC2T	Rate of generated load of agglomeration transported to this UWWTP by trucks (%)		Decimal

T_DischargePoints (28215 records)
Table contains information on individual points of discharge from treatment plants or collecting systems, localisation of discharge, link to specific treatment plant, type of receiving area into which the effluent/wastewater is discharged, related waterbody (or river basin), information on the discharge on land. Field repID is related to the table T_ReportPeriod. Field uwwID is related to the table T_UWWTPs, to ensure the link between Discharge point and UWWTP. Field rcaID is related to the table T_ReceivingArea, to ensure the link between Discharge point and Receiving area, into which the treated waste water is discharged. Field dcpNUTS is related to the field nutID in the codelist table T_NUTS. Fields dcpState, dcpWaterBodyType, dcpTypeOfReceivingArea, dcpSurfaceWaters, dcpNotAffect, dcpMSProvide and dcpCOMAccept are related to the field lovID in the codelist table T_LOV.

Field Name	Field definition	Note	Data Type
dcpID	internal numerical database code of Discharge point		Long integer
dcpState	Status of the Discharge point (link to the field lovID in the codelist table T_LOV)	105 = inactive, 106 = active	Integer
repID	internal numerical database code connecting data to proper country, reported period and data delivery version (link to the table T_ReportPeriod)		Long integer
rptMStateKey	Member State abbreviation	ISO 3166-alpha-2 code	Text(2)
uwwID	internal numerical database code of UWWTP / collecting system without treatment (link to the table T_UWWTPs)		Long integer
dcpCode	ID of the Discharge point		Text(32)
dcpName	Name of the Discharge point		Text(255)
dcpNUTS	internal numerical database code of Region (NUTS) (link to the field nutID in the codelist table T_NUTS)		Long integer
dcpLatitude	Latitude (ETRS89, decimal degrees)		Decimal
dcpLongitude	Longitude (ETRS89, decimal degrees)		Decimal
dcpWaterBodyType	Water body type (link to the field lovID in the codelist table T_LOV)	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	Integer
dcpIrrigation	Purpose of discharge on land		Integer
dcpTypeOfReceivingArea	Type of Receiving area (link to the field lovID in the codelist table T_LOV)	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	Integer
rcaID	internal numerical database code of Receiving area (link to the table T_ReceivingAreas)	Relevant in case SA, CSA or LSA was chosen for parameter dcpTypeOfReceivingArea	Long integer
dcpSurfaceWaters	Availability of surface waters (link to the field lovID in the codelist table T_LOV)	122 = no, 123 = yes	Integer
dcpWaterbodyID	ID of WFD waterbody		Text(64)
dcpNotAffect	Comprehensive studies indicate that the discharge does not adversely affect the environment (link to the field lovID in the codelist table T_LOV)	122 = no, 123 = yes	Integer
dcpMSProvide	Member State provided these studies to the Commission (link to the field lovID in the codelist table T_LOV)	122 = no, 123 = yes	Integer
dcpCOMAccept	Commission formally accept that the conditions under Art. 6(2) are met (link to the field lovID in the codelist table T_LOV)	122 = no, 123 = yes	Integer
dcpGroundWater	ID of WFD groundwater body		Text(64)
dcpReceivingWater	ID of receiving water		Text(64)
dcpWFDSubUnit	ID of WFD sub-unit		Text(64)
dcpWFDRBD	ID of WFD river basin district		Text(64)
dcpRemarks	Remarks		Memo
dcpWFDRBDReferenceDate	Reference date of the WFD river basin district		Date
dcpWaterBodyReferenceDate	Reference date of the WFD waterbody		Date
dcpGroundWaterReferenceDate	Reference date of the WFD groundwater body		Date
dcpReceivingWaterReferenceDate	Reference date of the receiving water		Date
dcpWFDSubUnitReferenceDate	Reference date of the WFD sub-unit		Date

T_MSLevel (29 records)
Table summarises aggregated (on MS level) information on the sludge handling, its discharge and/or disposal and re-use of treated water. Field mslMS is related to the field lovID in the codelist table T_LOV.

Field Name	Field definition	Note	Data Type
mslID	internal numerical database code		Long integer
mslMS	Specification of the country (link to the field lovID in the codelist table T_LOV)	65 = Austria, 66 = Belgium, ..., 91 = Slovakia, 92 = United Kingdom, 132 = Croatia	Integer
repID	internal numerical database code connecting data to proper country, reported period and data delivery version (link to the table T_ReportPeriod)		Long integer
rptMStateKey	Member State abbreviation	ISO 3166-alpha-2 code	Text(2)
mslSludgeProduction	Yearly production of sludge (t DS/y)		Long integer
mslDischargePipelines	Sludge discharged into surface waters: Pipelines (t DS/y)		Decimal
mslDischargeShips	Sludge discharged into surface waters: Ships (t DS/y)		Decimal
mslDischargeOthers	Sludge discharged into surface waters: Others (t DS/y)		Decimal
mslReuseSoilAgriculture	Sludge re-used: Soil and agriculture (t DS/y)		Decimal
mslReuseOthers	Sludge re-used: Others (t DS/y)		Decimal
mslDisposalLandfill	Sludge disposed: Landfill (t DS/y)		Decimal
mslDisposalIncineration	Sludge disposed: Incineration (t DS/y)		Decimal (18)
mslDisposalOthers	Sludge disposed: Others (t DS/y)		Decimal
mslRemarks	Remarks		Text(255)
mslWWReusePerc	Rate of treated waste water re-used (% of total volume treated)		Integer
mslWWReuseAgri	Re-use of treated waste water in: Agriculture	0 = false, -1 = true	Boolean
mslWWReuseInd	Re-use of treated wastewater in: Industry	0 = false, -1 = true	Boolean
mslWWReuseOther	Re-use of treated waste water in: Others	0 = false, -1 = true	Boolean
mslWWReuseExplain	Re-use of treated waste water: Explanation of others		Text(64)

T_UWWTPs_emission_load (30043 records)
Table contains additional data on incoming and discharged loads of organic matter and nutrients, provided by some Member States beyond the scope of UWWTD compliance. The data can be linked with the T_UWWTPs for further characteristics for the specific plants. A QA flag for some records relates to certain criteria and should be considered by the user for specific purposes. Field uwwState is related to the field lovID in the codelist table T_LOV. Fields uwwID, uwwCode and uwwName are related to the table T_UWWTPs.

Field Name	Field definition	Note	Data Type
uwwState	Status of the UWWTP (link to the field lovID in the codelist table T_LOV)	105 = inactive, 106 = active	Integer
rptMStateKey	Member State abbreviation	ISO 3166-alpha-2 code	Text(2)
uwwID	internal numerical database code of UWWTP / collecting system without treatment (link to the table T_UWWTPs)		Long integer
uwwCode	ID of UWWTP / collecting system without treatment (link to the field uwwCode in the table T_UWWTPs)		Text(32)
uwwName	Name of the UWWTP (link to the field uwwName in the table T_UWWTPs)		Text(255)
BODIncoming	Incoming loads (t/y): BOD		Decimal
CODIncoming	Incoming loads (t/y): COD		Decimal
NIncoming	Incoming loads (t/y): Ntot		Decimal
PIncoming	Incoming loads (t/y): Ptot		Decimal
BODDischarge	Discharged loads (t/y): BOD		Decimal
CODDischarge	Discharged loads (t/y): COD		Decimal
NDischarge	Discharged loads (t/y): Ntot		Decimal
PDischarge	Discharged loads (t/y): Ptot		Decimal
QA flag	information on the data flagging	Y = record flagged	Text(1)
Remark	reference to the detailed information on the QA of the emission load data		Text(255)

T_Add_on_Agglomerations (6462 records)
Table provides additional information on population connected to Individual Appropriate System (IAS) and population not connected to any type of treatment nor collecting system without treatment. The data is provided at agglomeration level and is supplementary to data reported in Table Agglomerations.

Field Name	Field definition	Note	Data Type
aggID	internal numerical database code of Agglomeration (can't be used as link to the table T_Agglomerations)		Long integer
aggState	Status of the Agglomeration (link to the field lovID in the codelist table T_LOV)	105 = inactive, 106 = active	Integer
repID	internal numerical database code connecting data to proper country, reported period and data delivery version (link to the table T_ReportPeriod)		Long integer
aggCode	ID of the Agglomeration (link to the table T_Agglomerations)		Text(32)
aggName	Name of the Agglomeration (link to the table T_Agglomerations)		Text(255)
aggInhabitantsConnectedIAS	number of inhabitants connected to Individual Appropriate Systems of waste water treatment		Long integer
aggInhabitantsWithoutTreatment	number of inhabitants not to collecting systems nor to Individual Appropriate Systems of waste water treatment		Long integer
aggRemarks	Memo		Text(255)

T_Add_on_UWWTPs (834 records)
The data provided in this table is supplementary to information reported in Table UWWTPS. The table contains Information on population connected to individual waste water treatment plant or collecting system, EPRTR code of facility (waste water treatment plants) if relevant, information whether more stringent effluent standards apply to the individual waste water treatment plant. Moreover, Member States can provide information on the type of effluent flow.

Field Name	Field definition	Note	Data Type
uwwID	internal numerical database code of UWWTP / collecting system without treatment (can't be used as link to the table T_UWWTPs)		Long integer
uwwState	Status of the UWWTP (link to the field lovID in the codelist table T_LOV)	105 = inactive, 106 = active	Integer
repID	internal numerical database code connecting data to proper country, reported period and data delivery version (link to the table T_ReportPeriod)		Long integer
uwwCode	ID of UWWTP / collecting system without treatment (link to the table T_UWWTPs)		Text(32)
uwwName	Name of UWWTP / collecting system without treatment (link to the table T_UWWTPs)		Text(255)
uwwCollectingSystem	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)	111 = collecting system connected to UWWTP, 112 = collecting system not connected to UWWTP	Integer
uwwE_PRTRCode	E-PRTR code of waste water treatment plant under which it is reported in E-PRTR database		Text(128)
uwwpInhabitantsConnected	number of inhabitants connected to waste water treatment plant		Long integer
uwwMoreStringentStandards	Indication of application of more stringent effluent standards as compared to UWWTD		Boolean
uwwMoreStringentStandardsNtot	Indication of application of more stringent effluent standards for N total as compared to UWWTD		Boolean
uwwMoreStringentStandardsPtot	Indication of application of more stringent effluent standards for Ptotal as compared to UWWTD		Boolean
uwwMoreStringentStandardsBOD	Indication of application of more stringent effluent standards for BOD as compared to UWWTD		Boolean
uwwMoreStringentStandardsOther	Indication of application of more stringent effluent standards for other parameters as compared to UWWTD		Text(255)
uwwEffluentFLowType	Specification of effluent treatment	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;	Integer
uwwEffluentFLowTypeRemark	Remarks on the CSO		Text(255)
uwwRemarks	Memo		Text(255)

T_Add_on_MSLevel (1 record)
Table contains aggregated information (at MS level) on population connected to collecting systems, wastewater treatment plants, population not connected to any type of treatment. The data is provided for both agglomeration above and below 2000 p.e.

Field Name	Field definition	Data Type
repID	internal numerical database code connecting data to proper country, reported period and data delivery version (link to the table T_ReportPeriod)	Long integer
mslInhabitantsConnetecIAS	Number of inhabitants connected to IAS	Long integer
mslInhabitantsWithoutTreatment	Number of inhabitants not connected to collecting system nor served by IAS	Long integer
mslInhabitantsUwwtpCollsys	Number of inhabitants connected to collecting system or treatment plant	Long integer
mslInhabitantsUwwtpAgglo2	Number of inhabitants connected to collecting system or treatment plant serving agglomeration smaller than 2 000 p.e.	Long integer
mslInhabitantsIASAgglo2	Number of inhabitants connected to collecting system or treatment plant serving agglomeration smaller than 2 000 p.e.	Long integer
mslInhabitantsWithoutTreatmentAgglo2	Number of inhabitants in agglomeration smaller than 2 000 p.e.	Long integer
mslInfoFateWithoutTreatment	brief text information on the fate of generated wastewater	Text(255)

Code lists

T_BigCity
Codelist of Big cities / Big discharges

Field Name	Field definition	Note	Data Type
bigID	internal numerical database code of the Big city		Long integer
bigCityID	ID of the Big city		Text(32)
bigCountryCode	Member State abbreviation	ISO 3166-alpha-2 code	Text(4)
bigCity	Name of the BigCity		Text(255)

T_NUTS
Codelist of NUTS

Field Name	Field definition	Note	Data Type
nutID	internal numerical database code of the NUTS		Long integer
nutNUTS	ID of the NUTS		Text(16)
nutCountryCode	Member State abbreviation	ISO 3166-alpha-2 code	Text(2)
nutRegion	Name of the NUTS		Text(64)

T_LOV
Common codelist of values appropriated to various fields and tables

Field Name	Field definition	Data Type
lovID	internal numerical database code of the LOV	Long integer
lovName	Name of the LOV	Text(32)
lovKey	Key of the LOV	Text(16)
lovValue	Value of the LOV	Text(64)