🔧 Summary of Changes
This week’s release includes updates to four DataMart view SQL files, all related to a recent data unification issue affecting the CAD domain. The issue arose due to conflicting records across two client lists. This has now been resolved by aligning with the authoritative CL extracted from the Vision database (last exported in March 2025).
This became a release of two parts…
Included Changes
Created to avoid dependencies on shared SVWs.
employee_hours_202409
➤ Stable Copy Created from 202407
A dedicated 202409 version was introduced to ensure production (PRD) stability
customer_details_202404
➤ Field Added: customer_item_id
This enhancement improves join capability with item-level records.
customer_thermometer_202404
➤ New View Created
Developed following identification of usage.
📄 Updated Views
- ⚠️
customer_details_CAD.sql - ⚠️
project_cost_CAD.sql - ⚠️
project_details_CAD.sql - ⚠️
project_details_plus_CAD.sql
These updates ensure consistent client references and correct downstream value reporting across CAD-related datasets.
✅ Fix Details
- Issue: Inconsistent client lineage for CAD data caused by duplication across two lists.
- Resolution: All references now point to the unified Client List (CL) derived from the Vision database export (dated Mar-25).
- Impact: Improved accuracy and reliability in CAD reporting views, especially where project and cost attribution are concerned.