Release 65

by

Scope: Updates to Common Data Model (CDM) and project-specific views
Total File Changes: 34

🔄 Summary of Key Changes

✅ Stabilised Views for 202409 Reporting

These views are now stable and finalised for the 202409 reporting cycle, helping to prevent reuse issues in future CDM deployments.

🛠️ Updated PRUs for Project Views

CAD Region Updates:

  • project_cost_CAD
  • project_details_CAD
  • project_details_plus_CAD
  • project_revenue_CAD
when 'CIV - Ship Support and Delivery' then '3135013'
when 'GOV - Ship Support and Delivery' then '3115013'
when 'IND - Ship Support and Delivery' then '3125013'

USD Region Updates:

  • project_cost_USD
  • project_details_plus_USD
  • project_revenue_USD
when 'US Pipeline Integrity' then '3305088'

APC Region Updates:

  • customer_details_APC
  • project_details_APC
  • project_details_plus_APC
('Maritime Engineering (Infrastructure) - SI', '3007', '3403007'),
('Defence Ship Design - DEF AUS', '4003', '2014003')

🧩 New CDM Views (202404) for Historical Tracking

  • busopp_dates_202404
  • busopp_codes_202404
  • employee_codes_202404

Supports introduction of CDM-based temporal history models.

📊 Business Opportunity Domain (CDM) Buildout

  • busopp_core
  • busopp_codes
  • busopp_dates
  • busopp_values

Launch of the CDM-aligned Business Opportunity domain, enabling clearer lineage and attribute tracking.

🔧 Agile Enhancements to Existing CDM Views

  • customer_core
  • employee_core
  • project_core
  • supplier_core
  • employee_codes
  • employee_dates
  • project_codes
  • project_dates

Improvements include standardisation of hash generation and metadata alignment.

🌍 Global Organisation and Company Enhancements

Expanded logic for region mapping, e.g.:

WHEN company_label.ID = '9900' THEN 'GLOBAL'
WHEN COUNTRY_CODE = 'GB' THEN 'UK/EU'

New source table: ifs.DIM_COMPANY_MIS

📐 Other Key Fixes

  • project_details_USD.sql

Revert corrected column reference from Unnamed__0 to Estimate_Overhead to align with revised source spreadsheet.

Notes

🔍 Found 34 unique file changes for datamart view in the given period:
1. ⚠️ DIFFERENT: supplier_details_202409.sql
2. ⚠️ DIFFERENT: supplier_invoice_202409.sql
3. ⚠️ DIFFERENT: supplier_purchaseorderline_202409.sql
4. ⚠️ DIFFERENT: project_cost_CAD.sql
5. ⚠️ DIFFERENT: project_details_CAD.sql
6. ⚠️ DIFFERENT: project_details_plus_CAD.sql
7. ⚠️ DIFFERENT: project_revenue_CAD.sql
8. ⚠️ DIFFERENT: busopp_dates_202404.sql
9. ⚠️ DIFFERENT: busopp_codes.sql
10. ⚠️ DIFFERENT: busopp_dates.sql
11. ⚠️ DIFFERENT: busopp_values.sql
12. ⚠️ DIFFERENT: busopp_codes_202404.sql
13. ⚠️ DIFFERENT: employee_codes_202404.sql
14. ⚠️ DIFFERENT: busopp_core.sql
15. ⚠️ DIFFERENT: customer_core.sql
16. ⚠️ DIFFERENT: employee_core.sql
17. ⚠️ DIFFERENT: project_core.sql
18. ⚠️ DIFFERENT: supplier_core.sql
19. ⚠️ DIFFERENT: busopp_dates_202409.sql
20. ⚠️ DIFFERENT: project_cost_USD.sql
21. ⚠️ DIFFERENT: project_details_plus_USD.sql
22. ⚠️ DIFFERENT: project_revenue_USD.sql
23. ⚠️ DIFFERENT: employee_codes.sql
24. ⚠️ DIFFERENT: employee_dates.sql
25. ⚠️ DIFFERENT: project_codes.sql
26. ⚠️ DIFFERENT: project_dates.sql
27. ⚠️ DIFFERENT: global_organisation_202409.sql
28. ⚠️ DIFFERENT: global_organisation.sql
29. ⚠️ DIFFERENT: project_details_USD.sql
30. ⚠️ DIFFERENT: customer_details_APC.sql
31. ⚠️ DIFFERENT: project_details_APC.sql
32. ⚠️ DIFFERENT: project_details_plus_APC.sql
33. ⚠️ DIFFERENT: global_company.sql
34. ⚠️ DIFFERENT: global_company_202409.sql

Leave a Comment