Water Framework Directive reporting resources

× Important! The reporting guidance has been updated on 2022/10/26. Version 6.6.

× Important! The access database template has been updated on 2023/05/26 to version 2.5, and it is the version for which the conversion tools were created.
The latest version of the pre-filled files was also generated in this date and using this template version. Access database version and convertion tool version not matching may cause an unexpected behaviour in the conversion tool.

The creation date and version information for the template can be accessed in the 'Metadata' table.

CHANGES LOG:

Version 2.5:
        Date: 26 May 2023
         * Correction of the SQL query to get a drop-down list of options for table column "GWExemption.gwExemptionsTransboundary".

Version 2.4:
        Date: 23 May 2023
         * Data type of table column SWType.swTypeDescription changed from Text (limit of 255 characters) to Memo (to allow 1000 characters).

Version 2.3:
        Date: 05 May 2023
         * Modification of table RBMP and RBMP's related tables (RBMP_*) to allow duplicate values in table column RBMP.rbmpName.

Version 2.2:
        Date: 21 February 2023
         * Correction of a few values in WFDCommon table.

Version 2.1:
        Date: 28 November 2022
         * Missing selector of ReferenceType added to tables SWManagementObjectives_managementObjectivesReference and SWManagementObjectives_waterResourcePlansReference.

Version 2.1:
        Date: 22 November 2022
         * Service.serviceExternalEnvironmentalResourceCostJustification changed from 'Short text' to 'Memo'.

Version 2.0:
        Date: 06 October 2022
         * Costs table updated. Datatype of Costs.euFunds20152021 and Costs.euFunds20212027 have been changed from 'Long integer' to 'Double'.

Version 1.9:
        Date: 27 September 2022
         * WFDCommon table updated. "CAS_57-63-6 - 17alpha-ethinylestradiol (EE2)" changed to "CAS_57-63-6 - 17alpha-ethinylestradiol".

Version 1.9:
        Date: 23 September 2022
         * PoM table and its children tables modified due to changes in QC 0450 (euSubunitCode can be empty for Groundwater).

Version 1.8:
        Date: 21 September 2022
         * Removed "CAS_175013-18-0 - Carbamic acid".
         * Added "CAS_175013-18-0 - Pyraclostrobin" and "CAS_463-77-4 - Carbamic acid".

Version 1.8:
        Date: 09 September 2022
         * Missing chemical substances of "PS_Inventory" codelist added: "CAS_191-24-2 - Benzo(g,h,i)perylene", "CAS_205-99-2 - Benzo(b)fluoranthene" and "CAS_207-08-9 - Benzo(k)fluoranthene".
         * Chemical substance of "PS_Inventory" codelist deleted: "EEA_33-54-5 - Dioxin-like polychlorinated biphenyls (12 PCB-DLs: 77,81,105,114,118,123,126,156,157,167,169,189)".
         * Incorrect chemical substance of "SignificantPressureOrSubstanceFailingType_Union" codelist modified: "EEA_33-57-8 - Hexabromocyclododecanes (HBCDD)" --> "EEA_33-57-8 - Hexabromocyclododecanes (alpha + beta + gamma + 1,3,5,7,9,11 + 1,2,5,6,9,10 -HBCDD)".

Version 1.8:
        Date: 26 July 2022
         * RBMPPoM/POM/euSubUnitCode is now an optional field (0..1). 

Version 1.8:
        Date: 11 July 2022
         * Correction of "serviceExternalEnvironmentalResourceCostJustification" field. It needs to
          allow 2500 characters.

Version 1.8:
	Date: 30 June 2022
	 * Deletion of incorrect table index.

Version 1.8:
	Date: 05 May 2022
	 * Correction of values in table "WFDCommon" for the enumeration "WQUseType":
		"Consumptive Use Water Supply GW" changed to "Consumptive Use Public Supply GW".
		"Consumptive Use Water Supply SW" changed to "Consumptive Use Public Supply SW".

Version 1.8:
	Date: 13 April 2022
	 * EQStandardType_Enum corrected, removing the '-' symbol that is not present in the xsd.

Version 1.6 to 1.7:
	Date: 04 April 2022
	 * Datatype of [Progress].[rbmpGeneralProgress] changed from [Short text] to [Long text].
	 * [Metadata] updated:
		Version date: 2022-04-05 16:06
		Version number: 1.7

Version 1.5 to 1.6:
	Date: 25 March 2022
	 * Deletion of incorrect index on table [FailingRBSP]
	 * [Metadata] updated:
		Version date	2022-03-25 09:00
		Version number	1.6

Version 1.4 to 1.5:
	Date: 11 March 2022
	 * All [euRBDCode] table columns are now "NOT NULL"
	 * [Metadata] updated:
		Version date: 2022-03-11 09:06
		Version number: 1.5

Version 1.3 to 1.4:

	Date: 23 February 2022 
	 * Elimination of unique index on table ThresholdValue 

	Date: 24 February 2022 
	 * Added Combo Box to table column SWRBSP.RBSPCode as RBSP_Enum values from WFDCommon 

	Date: 02 March 2022 
	 * Two new values added to UnitOfMeasure_Enum: "[CFU]/dL" and "{FNU}" 
	 * Current unique index on table ThresholdValue eliminated. 
	 * Database version (Metadata table) changed to: 
		Version date: 2022-03-02 13:56 
		Version number: 1.4 

Version 1.2 to 1.3:

	Date: 02 December 2021 
	 * Added missing dropdowns in SignificantPressureOrSubstanceFailing/substanceFailing and WQUse/euRBDCode. 
	 * Changed type to long text in Service/serviceExternalEnvironmentalResourceCostJustification 

	Date: 02 December 2021 
	 * Corrected cardinalities of investmentCosts20212027 and swEcologicalStatusOrPotentialExpectedAchievementDate. 

	Date: 14 December 2021 
	 * Updated PhysChemParameter_Enum, CycleType and RBSP_Enum. 

	Date: 11 January 2022 
	 * Changes: 
		ALTER TABLE [InputCategory] DROP  CONSTRAINT [PK_InputCategory]
		CREATE UNIQUE INDEX [IDX_U_InputCategory] ON [InputCategory] ([euRBDCode] ASC,[euSubUnitCode] ASC,[chemicalSubstance] ASC,[inputYearPeriod] ASC,[inputTotalType] ASC,[inputCategoryScheme] ASC,[inputCategoryCode] ASC,[inputUWWTPCoverage] ASC) 
	 * Column [inputTotalType] of table [InputCategory]: changed to Combo Box. Values from: SELECT inputTotalType FROM InputTotal; 
	 * New version (table Metadata) set to : 
		Version date: 2022-01-11 15:34 
		Version number: 1.3 

	Date: 20 January 2022 
	 * Changed MonitoringParameter_Union_Enum by adding PhysChemParameter_Enum to the union. 

	Date: 21 January 2022 
	 * New version (table Metadata) set to: 
		Version date: 2022-01-21 09:37 
		Version number: 1.3