Project.ActivityDetails

by

Purpose [FACT_PROJ_ACTIVITY_INFO_OL] unique based on ACTIVITY_SEQ, CONTROL_CATEGORY_KEY This table plans to be unique for ACTIVITY_SEQ only Use Case Owner: Martyn ColeTypical Use Case: Provide details for ACTIVITY_SEQ and Sub Project IDStyle: Dimension, Dimension i.e. Single row per ACTIVITY_SEQ Source Key Parameters CompanyProjectCustomerActivitySeq Sample Exec Response SEQ Dates Measures Codes SQL

Release 25

by

Notes Alterations project_customerorderlineproject_customerorderline_202407 ADD PRE_ACCOUNTING_IDAwaiting arrival of [QFACT_PRE_ACCOUNTING_OL$]Internal Notes project_timeproject_time_202407 ADD INTERNAL_COMMENTsParallel change with project.expenses Resource_Activity_202407 Remove Resource Title, to use DataView (dvw) Additions project_activitydetailsproject_activitydetails_202407 [FACT_PROJ_ACTIVITY_INFO_OL] unique based on ACTIVITY_SEQ, CONTROL_CATEGORY_KEYThis table plans to be unique for ACTIVITY_SEQ only employee.leaveentitlementemployee.leaveentitlement_202406 myBMT | CR354: Employee Leave Entitlements (bmt-dwh-uks-app-my.azurewebsites.net) get.myView2 New version of get.myView for UAT Auto … Read more

Customer.Details

by

Purpose The Customer Details view serves as a unified source for basic business customer information, accessible across departments for consistent reporting and analysis. It excludes transactional data (like dates or measures) and provides a limited set of dimensional attributes, designed for integration with fact tables in reporting scenarios. Use Case Owner: Data EngineeringTypical Use Case: … Read more

Employee.LeaveEntitlement

by

Purpose The Employee Leave Entitlement fact table is designed to display quantitative data related to employees. This table integrates with dimension tables, such as employee_details_plus, to provide detailed insights into various aspects of employee performance, compensation, and other metrics. The primary purpose is to support data-driven decision-making across the organisation. Use Case Owner: Sam Jopson-WhiteTypical … Read more

Project.CustomerInvoice

by

Purpose The Project Customer Invoice (value) Fact TableDesigned to display quantitative data related to invoices generated for projects. This table integrates with dimension tables, such as client_details and project_details, to provide detailed insights into the financial aspects of projects, including invoicing, revenue, and billing trends. The primary purpose is to support forecasting, budgeting, and proactive project … Read more

Project.CustomerOrderLine

by

Purpose The Project Customer Orderline (value) Fact TableDesigned to display quantitative data related to orders generated for projects. This table integrates with dimension tables, such as client_details and project_details, to provide detailed insights into the financial aspects of projects, including invoicing, revenue, and billing trends. The primary purpose is to support forecasting, budgeting, and proactive project … Read more