Field name,Field Definition,Note,Data type
dcpState,Status of the discharge point,"105=deactivated, 106=active",Integer
rptMStateKey,Member State,All data are linked to rpMStateKey; ISO 3166-alpha-2 code,Text(2)
dcpID,internal numerical database code of discharge point,,Long integer
uwwID,internal numerical database code of UWWTP/ collecting system without treatment (link to the table 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 table NUTS),,Long integer
dcpLatitude,Latitude,,Decimal(18)
dcpLongitude,Longitude,,Decimal(18)
dcpWaterBodyType,Water body type,"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,In case of discharge on land please specify the purpose,,Integer
dcpTypeOfReceivingArea,Type of receiving area,"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 ReceivingAreas),"Relevant in case SA, CSA or LSA was chosen for parameter dcpTypeOfReceivingArea",Long integer
dcpSurfaceWaters,Are there surface waters available?,,Integer
dcpWaterbodyID,ID of WFD waterbody,,Text(64)
dcpNotAffect,Do comprehensive studies indicate that the discharge does not adversely affect the environment?,,Integer
dcpMSProvide,Has the Member State provided these studies to the Commission,,Integer
dcpCOMAccept,Did the Commission formally accept that the conditions under Art. 6(2) are met?,,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(10)
dcpWaterBodyReferenceDate,Reference date of the WFD waterbody,,Date(10)
dcpGroundWaterReferenceDate,Reference date of the WFD groundwater body,,Date(10)
dcpReceivingWaterReferenceDate,Reference date of the receiving water,,Date(10)
dcpWFDSubUnitReferenceDate,Reference date of the WFD sub-unit,,Date(10)
