This release documents updates to the Data Warehouse covering changes made since 30 June. It focuses on the continued rollout of CDM-aligned views and early implementation of Resource views. 🔁 Customer & Supplier Domains customer_core_details supplier_core_details 👥 Employee Domain employee_hours Absence-Related Views employee_item_codes_absenceemployee_item_dates_absenceemployee_item_values_absence employee_meta_codes 📁 Project Domain project_item_codes_forecastproject_item_values_forecast 🔧 Resource Domain (Initial Release) resource_item_codes_activityresource_item_values_activity

Changes busopp_dates_202409 Updated to source Wanted Delivery Date from the refactored QFACT_BUSINESS_OPP_OL (formerly FACT_BUSINESS_OPP_OL$). project_value_202410 Now filtered to exclude rows where CONTROL_CATEGORY is NULL. OCNS / CEFAS DataViews These views provide an overview of the product-related DataViews derived from OCNS (Offshore Chemical Notification Scheme) and CEFAS (Centre for Environment, Fisheries and Aquaculture Science) regulatory sources. … Read more

View: project_forecast_202409 Enhancements: Spark-SQL Compatibility and Safe-Code Updates Changes Implemented To improve compatibility with Spark SQL and prepare views for future transition into Fabric or Lakehouse environments, the following adjustments have been made: Outstanding Compatibility Issues 1. IIF() in object CODE should be CASE 2. Square brackets on reserved words (e.g. [identifier]) 3. CF$ field … Read more