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
