Release 43

Release includes 23 improvements and 8 new views, affecting Project, Business Opportunity (Busopp), Customer, and Employee data views.

DataMarts Affected

1. Project-related Views:

• DataMarts Affected:
  • project_activitydetails
  • project_forecast
  • project_details_plus
    • and their 202407 and 202410 versions.
  • project_cost_CAD
  • project_revenue_CAD
• Changes:
  • Introduction of Canadian versions and preparation for the North American project data set.
  • project_activitydetails: SEQ reordering for ‘Array version’.
  • project_forecast: Added [PROJECT_COST_ELEMENT].
  • project_details_plus: PRU replaced by [PRU_Code].
  • New CAD versions for details, details_plus, cost, and revenue views.

2. Business Opportunity (Busopp) Views:

• DataMarts Affected:
  • busopp_dates
  • busopp_details_plus
• Changes:
  • busopp_dates: NEW Partitioning of dates and values moved out of busopp_details_plus.

3. Customer-related Views:

• DataMarts Affected:
  • customer_orderlinevalue
  • customer_invoicevalue
  • customer_invoice
  • customer_orderlinestatus
  • customer_orderline
  • customer_invoicestatus and their 202409 versions.
• Changes:
  • SEQ improvements in preparation for ‘Array version’ enhancements.

4. Employee-related Views:

• DataMarts Affected:
  • employee_details_202410
  • employee_details_plus_202410
• Changes:
  • Added QFACT_EMP_JOB_ASSIGN_CFV_OL$ as a data source.

Notes

Files sql/svw/project/project_activitydetails.sql (DEV) and sql/svw/project/project_activitydetails.sql (PRD) are different.
Files sql/svw/project/project_forecast.sql (DEV) and sql/svw/project/project_forecast.sql (PRD) are different.
Files sql/svw/project/project_details_plus.sql (DEV) and sql/svw/project/project_details_plus.sql (PRD) are different.
Files sql/svw/project/project_details_plus_CAD.sql (DEV) and sql/svw/project/project_details_plus_CAD.sql (PRD) are different.
Files sql/svw/project/project_cost_CAD.sql (DEV) and sql/svw/project/project_cost_CAD.sql (PRD) are different.
Files sql/svw/project/project_details.sql (DEV) and sql/svw/project/project_details.sql (PRD) are different.
Files sql/svw/project/project_revenue_CAD.sql (DEV) and sql/svw/project/project_revenue_CAD.sql (PRD) are different.
Files sql/svw/project/project_details_CAD.sql (DEV) and sql/svw/project/project_details_CAD.sql (PRD) are different.
Files sql/svw/project/202407/project_activitydetails_202407.sql (DEV) and sql/svw/project/202407/project_activitydetails_202407.sql (PRD) are different.
File sql/svw/project/202410/project_roleassignment._202410.sql found in DEV but not in PRD.
File sql/svw/project/202410/project_revenue_202410.sql found in DEV but not in PRD.
File sql/svw/project/202410/project_activitydetails_202410.sql found in DEV but not in PRD.
Files sql/svw/project/202410/project_details_plus_202410.sql (DEV) and sql/svw/project/202410/project_details_plus_202410.sql (PRD) are different.
Files sql/svw/project/202410/project_details_202410.sql (DEV) and sql/svw/project/202410/project_details_202410.sql (PRD) are different.
File sql/svw/busopp/busopp_dates.sql found in DEV but not in PRD.
Files sql/svw/busopp/busopp_details_plus.sql (DEV) and sql/svw/busopp/busopp_details_plus.sql (PRD) are different.
Files sql/svw/customer/customer_orderlinevalue.sql (DEV) and sql/svw/customer/customer_orderlinevalue.sql (PRD) are different.
Files sql/svw/customer/customer_invoicevalue.sql (DEV) and sql/svw/customer/customer_invoicevalue.sql (PRD) are different.
Files sql/svw/customer/customer_invoice.sql (DEV) and sql/svw/customer/customer_invoice.sql (PRD) are different.
Files sql/svw/customer/customer_orderlinestatus.sql (DEV) and sql/svw/customer/customer_orderlinestatus.sql (PRD) are different.
Files sql/svw/customer/customer_orderline.sql (DEV) and sql/svw/customer/customer_orderline.sql (PRD) are different.
Files sql/svw/customer/customer_invoicestatus.sql (DEV) and sql/svw/customer/customer_invoicestatus.sql (PRD) are different.
Files sql/svw/customer/202409/customer_invoicestatus_202409.sql (DEV) and sql/svw/customer/202409/customer_invoicestatus_202409.sql (PRD) are different.
Files sql/svw/customer/202409/customer_orderlinevalue_202409.sql (DEV) and sql/svw/customer/202409/customer_orderlinevalue_202409.sql (PRD) are different.
Files sql/svw/customer/202409/customer_orderlinestatus_202409.sql (DEV) and sql/svw/customer/202409/customer_orderlinestatus_202409.sql (PRD) are different.
Files sql/svw/customer/202409/customer_invoice_202409.sql (DEV) and sql/svw/customer/202409/customer_invoice_202409.sql (PRD) are different.
Files sql/svw/customer/202409/customer_invoicevalue_202409.sql (DEV) and sql/svw/customer/202409/customer_invoicevalue_202409.sql (PRD) are different.
Files sql/svw/customer/202409/customer_orderline_202409.sql (DEV) and sql/svw/customer/202409/customer_orderline_202409.sql (PRD) are different.
File sql/svw/employee/202410/employee_details_202410.sql found in DEV but not in PRD.
File sql/svw/employee/202410/employee_details_plus_202410.sql found in DEV but not in PRD.