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
