Release 42

New Versions 202410

Content Reviewed by AI

Project Details

Removal of legacy Project_Item_ID as HASH
ADD project [STATUS]

Project Details_Plus

ADD Project Manager Email
Remove Project Dates (for Project.Dates)
Remove FINANCIALLY RESPONSIBLE (for Project.RoleAssignment)
Remove CUSTOMER RESPONSIBLE (for Project.RoleAssignment)

Project Dates

First Version since Beta

Project_Cost

ADD PRU Code
REMOVE Dates (for Project.Dates)
Include Currency (of Company)
COALESCE(dim_proj.PROJECT_CURRENCY_CODE, dim_company.CURRENCY_CODE) AS CURRENCY_CODE

Project_Value

New View

Notes

Files Found in DEV but Not in PRD:

1. sql/svw/project/202410/project_value_202410.sql
2. sql/svw/project/202410/project_details_plus_202410.sql
3. sql/svw/project/202410/project_dates_202410.sql
4. sql/svw/project/202410/project_cost_202410.sql
5. sql/svw/project/202410/project_details_202410.sql