Released immediately due to data error discovered in [QFACT_BMT_ACTUAL_HOURS_BY_IAS$] PRD 20240731
Alterations
Employee.Hours
Change UPLIFT to CAST(GROSS AS DECIMAL(10, 3)) – CAST(NETT AS DECIMAL(10, 3)) AS UPLIFT,
As UPLIFT was being delivered with discrepancies between rounding of GROSS and NETT
i.e. 21.8104 – 21.81 = -4.0E-4
This was causing an error in both CAST and Try_Parse
Project.Details ver 202404
CHANGE Code_E = PRU to CATEGORY1_ID
Details_Short
busopp_details_short.
customer_details_short.
employee_details_short.
project_details_short.
Returned for a rethink on delete policy!
Notes
[‘Files 20240731/svw_dev_flat\\busopp_details_short.sql and 20240731/svw_prd_flat\\busopp_details_short.sql are different.’,
‘Files 20240731/svw_dev_flat\\customer_details_short.sql and 20240731/svw_prd_flat\\customer_details_short.sql are different.’,
‘Files 20240731/svw_dev_flat\\employee_details.sql and 20240731/svw_prd_flat\\employee_details.sql are different.’,
‘Files 20240731/svw_dev_flat\\employee_details_short.sql and 20240731/svw_prd_flat\\employee_details_short.sql are different.’,
‘Files 20240731/svw_dev_flat\\employee_hours.sql and 20240731/svw_prd_flat\\employee_hours.sql are different.’,
‘Files 20240731/svw_dev_flat\\employee_hours_202404.sql and 20240731/svw_prd_flat\\employee_hours_202404.sql are different.’,
‘Files 20240731/svw_dev_flat\\employee_hours_202406.sql and 20240731/svw_prd_flat\\employee_hours_202406.sql are different.’,
‘Files 20240731/svw_dev_flat\\employee_hours_202407.sql and 20240731/svw_prd_flat\\employee_hours_202407.sql are different.’,
‘Files 20240731/svw_dev_flat\\project_details_202404.sql and 20240731/svw_prd_flat\\project_details_202404.sql are different.’,
‘Files 20240731/svw_dev_flat\\project_details_short.sql and 20240731/svw_prd_flat\\project_details_short.sql are different.’]