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.
These DataViews support:
- 📊 Environmental Compliance Reporting
Enables tracking of product use against approved chemical lists and environmental limits. - ⚠️ Substitution Warning Analysis
Identifies products containing substances subject to substitution under OCNS/CEFAS guidance. - 🧾 Product Registration and Audit
Supports consultancy-led reviews of product classifications and compliance obligations.
Note: This is a Management Consultancy Deliverable Product
These views are designed specifically for regulatory analysis and insight purposes. They are not part of the base global data warehouse structure and are maintained separately in line with consultancy delivery cycles.