Field Name,Field definition,Note,Data Type
rcaID,internal numerical database code of Receiving area,,Long 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)
rcaState,Status of the Receiving area (link to the field lovID in the codelist table T_LOV),"105 = inactive, 106=active",Integer
rcaCode,ID of the Receiving  area,,Text(32)
rcaName,Name of the Receiving area,,Text(255)
rcaType,Type of the 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
rcaSensitiveArea,Related Sensitive area,-999 = data not available,Long integer
rcaDateArt58,Starting date of application of Art. 5(8) of UWWTD,,Date
rcaParameterN,Parameters subject to More Stringent Treatment: N,"0 = false, -1 = true",Boolean
rcaParameterP,Parameters subject to More Stringent Treatment: P,"0 = false, -1 = true",Boolean
rcaParameterOther,Parameters subject to More Stringent Treatment: Other,"0 = false, -1 = true",Boolean
rcaDateDesignation,Last date of designation or revision/ in case Art. 5(8) and 5(2-3) is applied: Starting date of application of Art. 5(2-3),,Date
rcaANitro,"Designation Criteria (a, b, c): a - Nitrogen","0 = false, -1 = true",Boolean
rcaAPhos,"Designation Criteria (a, b, c): a - Phosphorus","0 = false, -1 = true",Boolean
rcaB,"Designation Criteria (a, b, c): b","0 = false, -1 = true",Boolean
rcaC,"Designation Criteria (a, b, c): c","0 = false, -1 = true",Boolean
rcaCRelevantDirective,Designation criteria c - relevant EU-Directives and related parameters,,Memo
rcaMorphology,Less sensitive area - Designation criteria (Annex II B): Morphology,"0 = false, -1 = true",Boolean
rcaHydrologie,Less sensitive area - Designation criteria (Annex II B): Hydrology,"0 = false, -1 = true",Boolean
rcaHydraulic,Less sensitive area - Designation criteria (Annex II B): Specific hydraulic conditions,"0 = false, -1 = true",Boolean
rcaAbsenceRisk,Less sensitive area - Designation criteria (Annex II B): Absence of risk of transfer of discharged load to adjacent areas,"0 = false, -1 = true",Boolean
rcaDateArt54,Starting date of application of Art. 5(4) of UWWTD,,Date
rcaArt54Applied,Indication of application of Art. 5(4) of UWWTD,"0 = false, -1 = true",Boolean
