Additions
employee_details_plus (202409)
ADD Person.USER_ID (Windows Login)
ADD User.UPN_EMAIL (Primary/Service Principle Email)
Sourced EMAIL _ADDRESSS from User
Associated Tickets and Actions
myBMT | Employee Email Address (bmt-dwh-uks-app-my.azurewebsites.net)
Change Request Register – Update data warehouse feed to include the users “identity” and “office” location information. (sharepoint.com)
busopp_details_plus (202409)
Change source to ifs.FACT_BUSINESS_OPP_OL$
Include [CF$_PRU_VALUE] as PRU
busopp_value (202409)
Change source to ifs.FACT_BUSINESS_OPP_OL$
ADD CF$_ESTIMATED_NFI
ADD ESTIMATED_SIGN_DATE
Associated Tickets and Actions
myBMT | Missing Fields (bmt-dwh-uks-app-my.azurewebsites.net)
myBMT | VERIFY DEL_PROJECT_ID (bmt-dwh-uks-app-my.azurewebsites.net)
myBMT | CR 308: Complete ?project/pru? (bmt-dwh-uks-app-my.azurewebsites.net)
customer_invoice (202409)
CHANGE Source to [QFACT_BMT_DWH_INVOICE_TAB_IAS$]
ADD CREATORS_REFERENCE as ORDER_NO
202409 is in preparation for the release of [QFACT_BMT_DWH_INVOICE_TAB_IAS$] in PRD
Associated Tickets and Actions
myBMT | ADD OrderPipeline refernce (bmt-dwh-uks-app-my.azurewebsites.net)
customer_orderline (202409)
ADD AUTHORIZE CODE
ADD BUSINESS_OPPORTUNITY_NO
ADD TARGET DATE
Associated Tickets and Actions
myBMT | CR 476 – TARGET_DATE to FACT_CUSTOMER_ORDER_LINE_OL$ (bmt-dwh-uks-app-my.azurewebsites.net)
myBMT | Missing Fields (bmt-dwh-uks-app-my.azurewebsites.net)
Alterations
project_customerinvoice
CHANGE Source to [QFACT_BMT_DWH_INVOICE_TAB_IAS$]
ADD CREATORS_REFERENCE as ORDER_NO
This cannot be release to 202409 until [QFACT_BMT_DWH_INVOICE_TAB_IAS$] is available in PRD
Notes
File sql/svw/employee/employee_details_plus_202409.sql found in DEV but not in PRD.
File sql/svw/employee/202409 found in DEV but not in PRD.
Files sql/svw/employee/employee_details_plus.sql (DEV) and sql/svw/employee/employee_details_plus.sql (PRD) are different
File sql/svw/busopp/busopp_details_plus_202409.sql found in DEV but not in PRD.
File sql/svw/busopp/busopp_value_202409.sql found in DEV but not in PRD.
Files sql/svw/busopp/busopp_value.sql (DEV) and sql/svw/busopp/busopp_value.sql (PRD) are different
Files sql/svw/busopp/busopp_details_plus.sql (DEV) and sql/svw/busopp/busopp_details_plus.sql (PRD) are different
Files sql/svw/project/project_customerinvoice.sql (DEV) and sql/svw/project/project_customerinvoice.sql (PRD) are different
Files sql/svw/project/project_customerorderline.sql (DEV) and sql/svw/project/project_customerorderline.sql (PRD) are different
File sql/svw/customer/customer_invoice_202409.sql found in DEV but not in PRD.
File sql/svw/customer/customer_orderline_202409.sql found in DEV but not in PRD.
File sql/svw/customer/202409 found in DEV but not in PRD.
Files sql/svw/customer/customer_orderline.sql (DEV) and sql/svw/customer/customer_orderline.sql (PRD) are different
Files sql/svw/customer/customer_invoice.sql (DEV) and sql/svw/customer/customer_invoice.sql (PRD) are different