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,"105=deactivated, 106=active",Integer
repID,internal numerical database code connecting data to proper reporting period (link to the table ReportPeriod),,Long integer
rptMStateKey,Member State,All data are linked to rpMStateKey; ISO 3166-alpha-2 code,Text(2)
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,year,Integer
uwwHistorie,Explanation for closing of the UWWTP/What happened with the wastewater since last reporting exercise,,Memo
uwwLatitude,Latitude,,Decimal
uwwLongitude,Longitude,,Decimal
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,,Boolean
uwwSecondaryTreatment,Secondary treatment,,Boolean
uwwOtherTreatment,More stringent treatment,,Boolean
uwwNRemoval,N-removal,,Boolean
uwwPRemoval,P-removal,,Boolean
uwwUV,UV,,Boolean
uwwChlorination,Chlorination,,Boolean
uwwOzonation,Ozonation,,Boolean
uwwSandFiltration,Sand filtration,,Boolean
uwwMicroFiltration,Micro filtration,,Boolean
uwwOther,Other type of more stringent treatment,,Boolean
uwwSpecification,Please specify other type of more stringent treatment,,Text(255)
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
uwwOtherPerf,Treatment performance: Other,"93=FAIL, 95=PASS, 94=Not relevant",Integer
