Additions
Customer Details USD
✅ New Addition customer_details_USD – Part of the CAD/USD series of changes.
⚠️ Contains Created (Hash) Customer IDs – This will be corrected in the next release.
Considerations & Next Steps
🔹 Customer ID Fix Pending – Plan for a smooth transition when correcting the Customer ID field.
🔹 UNION-based “mega” list for customer_details across all regions would create a single, comprehensive view. This can facilitate regional comparisons, aggregated analytics, and simpler downstream queries.
Project.Core & Codes
The Project.Core and Project.Codes views establish the foundation of the Common Data Standard for DataMart views. These ensure a structured, reusable, and scalable approach to managing project-related data across analytical and reporting frameworks.
📌 Upcoming additions may include:
- Project.Status – Historical and real-time project tracking.
- Project.Value – Financial and resource-based metrics.
Alterations
Wanted Delivery Date
Addition of “Wanted Delivery Date” to buspp.dates – This field was previously omitted and has now been included in the current view.
Next Steps:
- Ensure that the new column is correctly populated and formatted as expected.
- Validate the impact on dependent queries and reports.
- If required, update documentation to reflect the inclusion of “Wanted Delivery Date.”
Project.Value
Addition of “Used Cost” to Project.Value – Added at the request of the Machine Learning programme. However, Considered Similar To “Actual Value”.
Considerations
🔹 Alignment with “Actual Value” – If used_cost and actual_value are closely related, consider clarifying their distinction in documentation.
🔹 Impact on Reporting & Models – Ensure that reports and Machine Learning models interpret used_cost correctly.
🔹 Data Population – Confirm that used_cost is correctly sourced and doesn’t introduce duplication.
Notes
1. ⚠️ DIFFERENT: busopp_dates.sql
2. 🔴 MISSING IN PRD CONTAINER: busopp_dates_202502.sql
3. 🔴 MISSING IN PRD CONTAINER: customer_details_USD.sql
4. 🔴 MISSING IN PRD CONTAINER: project_codes.sql
5. 🔴 MISSING IN PRD CONTAINER: project_core.sql
6. ⚠️ DIFFERENT: project_value.sql
Total number of different files: 2
Total number of missing files in DEV CONTAINER: 0
Total number of missing files in PRD CONTAINER: 4