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 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)
rcaState,Status of the area,"105=deactivated, 106=active",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
rcaParameterN,Parameters subject to More Stringent Treatment: N,,Boolean
rcaParameterP,Parameters subject to More Stringent Treatment: P,,Boolean
rcaParameterOther,Parameters subject to More Stringent Treatment: Other,,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",,Boolean
rcaAPhos,"Designation Criteria (a, b, c): a - Phosphorus",,Boolean
rcaB,"Designation Criteria (a, b, c): b",,Boolean
rcaC,"Designation Criteria (a, b, c): c",,Boolean
rcaCRelevantDirective,Designation criteria c - relevant EU-Directives and related parameters,,Memo
rcaMorphology,Less sensitive area - Designation criteria (Annex II B): Morphology,,Boolean
rcaHydrologie,Less sensitive area - Designation criteria (Annex II B): Hydrology,,Boolean
rcaHydraulic,Less sensitive area - Designation criteria (Annex II B): Specific hydraulic conditions,,Boolean
rcaAbsenceRisk,Less sensitive area - Designation criteria (Annex II B): Absence of risk of transfer of discharged load to adjacent areas,,Boolean
rcaDateArt54,Starting date of application of Art. 5(4) of UWWTD,,Date
rcaArt54Applied,Indication of application of Art. 5(4) of UWWTD,,Boolean
