Field name,Field Definition,Note,Data type
rcaState,Status of the area,"105=deactivated, 106=active",Integer
rptMStateKey,Member State,All data are linked to rpMStateKey; ISO 3166-alpha-2 code,Text(2)
rcaID,internal numerical database code of receiving area,,Long integer
rcaCode,ID of the area,,Text(32)
rcaName,Name of the Receiving area,,Text(255)
rcaType,Type of the 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
rcaSensitiveArea,Related Sensitive area,,Long integer
rcaDateArt58,Starting date of application of Art. 5(8) of UWWTD,,Date(10)
rcaParameterN,Parameters subject to More Stringent Treatment: N,,Bool(1)
rcaParameterP,Parameters subject to More Stringent Treatment: P,,Bool(1)
rcaParameterOther,Parameters subject to More Stringent Treatment: Other,,Bool(1)
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(10)
rcaANitro,"Designation Criteria (a, b, c): a - Nitrogen",,Bool(1)
rcaAPhos,"Designation Criteria (a, b, c): a - Phosphorus",,Bool(1)
rcaB,"Designation Criteria (a, b, c): b",,Bool(1)
rcaC,"Designation Criteria (a, b, c): c",,Bool(1)
rcaCRelevantDirective,Designation criteria c - relevant EU-Directives and related parameters,,Memo
rcaMorphology,Les sensitive area - Designation criteria (Annex II B): Morphology,,Bool(1)
rcaHydrologie,Les sensitive area - Designation criteria (Annex II B): Hydrology,,Bool(1)
rcaHydraulic,Les sensitive area - Designation criteria (Annex II B): Specific hydraulic conditions,,Bool(1)
rcaAbsenceRisk,Les sensitive area - Designation criteria (Annex II B): Absence of risk of transfer of discharged load to adjacent areas,,Bool(1)
rcaDateArt54,Starting date of application of Art. 5(4) of UWWTD,,Date(10)
rcaArt54Applied,Indication of application of Art. 5(4) of UWWTD,,Bool(1)
