Handovers

Consolidated all Silver→STG→DW dim load procs into single Silver→DW stored procs for the Savills CRL Fabric Warehouse migration. Fixed DimClient count discrepancy (SELECT DISTINCT + ROW_NUMBER() no-op bug), applied UPPER() case-safe fixes across DimPerson/DimDocumentDescription/DimOfficeDepartment, built usp_DimDocumentDescription with s_ConsolidatedDocuments rebuild and BIGINT key writeback. Next: build usp_FactFinanceTransaction.

Northern Powergrid property access dispute at 18 Sandal Avenue. Latest session (31 May): read NPG formal letter (dated 22 May, received on return from holiday), analysed WhatsApp evidence from neighbour's wife confirming NPG committed to alternative route via Orrs' property only. Drafted comprehensive formal response challenging inconsistent stated purposes, unenforceable deadline, and disconnection threat — ready to send after call to Andy Molden (Surveyor, 03711 946325) to obtain job reference. Key deadlines: 14 June NPG response, 21 June SAR responses due.

Designed and documented the Fee Flash Gold layer for T&T Fabric Medallion. Established a three-fact-table architecture (fct_fee_flash_gl, fct_fee_flash_budget, fct_fee_flash_projtrans), wrote GL and Budget filter SQL queries, and fully rebuilt the schema mapping Excel workbook (16 sheets) including column maps for all three facts and Bronze/Silver build requirements for the ProjTrans Phase 2 build.

Renamed all 4 Savills project folders and associated documentation to append "Fabric Medallion" to each project name (CRL, EU Finance, Reapit, UK Finance). All 6 files updated; UK Finance folder renamed successfully. CRL, EU Finance, and Reapit folder renames are pending — blocked by OneDrive sync in progress; Matthew to complete in File Explorer once sync settles.

Built the complete Claude Code workspace and completed a full visual redesign of Claude Compass. Covers: workspace structure, 13 global rules, 11 skills, encrypted secrets vault, Azure DevOps pipeline to Cloudflare Pages, Turner & Townsend Fabric Medallion project with 3 repos, /clone-repo local-folder check, /create-project Personal/Disseminate workspace support, awwwards-inspired site redesign (top nav, amber accent, two logo variants, hero banners on all pages), nav reordered, structure page repos workflow rewritten, /update-handover renamed to /handover-update, Playwright MCP installed. Next: push Compass changes to trigger deployment, then set up compass.disseminate.co.uk custom domain and Cloudflare Access.