Deployment status of the Department and Division dimension changes (Local Department / Local Division, To-Be presentation, cleanup) per environment. All scripts are in main; Prod is a manual deployment from saved scripts. Audited 29 Sep 2026 by scripting each object out of every environment and comparing to main.
Department
| SQL Object | Dev | UAT | Support | Prod |
|---|---|---|---|---|
staging.department |
Deployed | Deployed | Deployed | Pending |
DIM.DimDepartment |
Deployed | Deployed | Deployed | Pending |
LOAD.usp_dimdepartment |
Deployed | Deployed | Deployed | Pending |
DIM.Department |
Deployed | Deployed | Deployed | Pending |
Division
| SQL Object | Dev | UAT | Support | Prod |
|---|---|---|---|---|
staging.division |
Deployed | Deployed | Deployed | Pending |
DIM.DimDivision |
Deployed | Deployed | Deployed | Pending |
LOAD.usp_dimdivision |
Deployed | Deployed | Deployed | Pending |
DIM.Division |
Deployed | Deployed | Deployed | Pending |
WIP Data Model
| Object | Dev | UAT | Support | Prod |
|---|---|---|---|---|
| WIP Data Model (semantic model) | Deployed | Deployed | Deployed | Pending |
Prod Deployment Notes
Department (in order):
| # | Step |
|---|---|
| 1 | Deploy staging.department (current main) |
| 2 | Deploy LOAD.usp_dimdepartment (v5) |
| 3 | Deploy DIM.Department (current main, incl. Department Code - Local Name) |
| 4 | ALTER TABLE [DIM].[DimDepartment] DROP COLUMN [DepartmentGroup]; |
| 5 | Run LOAD.usp_dimdepartment — expect full-table update (hash formula changed), then ~0 on rerun |
Division (in order):
| # | Step |
|---|---|
| 1 | Deploy staging.division (current main) |
| 2 | ALTER TABLE [DIM].[DimDivision] ADD [LocalDivision] varchar(200) NULL; (matches Dev; before the proc — v3 writes it) |
| 3 | Deploy LOAD.usp_dimdivision (v3) |
| 4 | Deploy DIM.Division (current main) |
| 5 | ALTER TABLE [DIM].[DimDivision] DROP COLUMN [Title], [DivisionTranslated]; (after nothing references them) |
| 6 | Run LOAD.usp_dimdivision — expect full-table update, then ~0 on rerun |
Expected one-off effects in Prod: full-table hash churn on the first load of each dim (hash formulas changed); the Department column in reports changes from the local name to the central D365 name (To-Be presentation) — business-visible, communicate before deploying; orphaned 'Unknown' division rows may linger in DimDivision (null-division mapping rows are no longer staged — the load has no delete) and can be tidied separately.
Pre-flight checks: confirm no Prod semantic model references DepartmentGroup, Title or Division Translated before the column drops; confirm the Prod hotfix comments (department hash patch, division ISNULL patches) have no surviving purpose — both are superseded by the current views.