Field name,Field Definition,Note,Data type
uwwState,Status of the UWWTP,"105=deactivated, 106=active",Integer
rptMStateKey,Member State,All data are linked to rpMStateKey; ISO 3166-alpha-2 code,Text(2)
uwwID,internal numerical database code of UWWTP/ collecting system without treatment,,Long integer
aggID,internal numerical database code of agglomeration (link to the table 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,"111=collecting system connected to UWWTP, 112=collecting system not connected to UWWTP",Integer
uwwDateClosing,Date of closing of the UWWTP,,Date(10)
uwwHistorie,Explanation for closing of the UWWTP/What happened with the wastewater since last reporting exercise,,Memo
uwwLatitude,Latitude,,Decimal(18)
uwwLongitude,Longitude,,Decimal(18)
uwwNUTS,internal numerical database code of Region (NUTS) (link to the table NUTS),,Integer
uwwLoadEnteringUWWTP,Load entering UWWTP (p.e.),,Long integer
uwwCapacity,Organic design capacity (p.e.),,Long integer
uwwPrimaryTreatment,Primary treatment,,Bool(1)
uwwSecondaryTreatment,Secondary treatment,,Bool(1)
uwwOtherTreatment,More stringent treatment,,Bool(1)
uwwNRemoval,N-removal,,Bool(1)
uwwPRemoval,P-removal,,Bool(1)
uwwUV,UV,,Bool(1)
uwwChlorination,Chlorination,,Bool(1)
uwwOzonation,Ozonation,,Bool(1)
uwwSandFiltration,Sand filtration,,Bool(1)
uwwMicroFiltration,Micro filtration,,Bool(1)
uwwOther,Other type of more stringent,,Bool(1)
uwwSpecification,Please specify other type of more stringent treatment,,Text(128)
uwwBOD5Perf,Treatment performance: BOD5,"1=FAIL, 2=PASS",Integer
uwwCODPerf,Treatment performance: COD,"93=FAIL, 95=PASS, 94=Not relevant",Integer
uwwTSSPerf,Treatment performance: TSS,"93=FAIL, 95=PASS, 94=Not relevant",Integer
uwwNTotPerf,Treatment performance: N,"93=FAIL, 95=PASS, 94=Not relevant",Integer
uwwPTotPerf,Treatment performance: P,"93=FAIL, 95=PASS, 94=Not relevant",Integer
