February 2, 2026
EDW Breaking Changes March 11, 2026
EDW Breaking Changes March 11, 2026
Summary of changes, details to follow below.
| JIRA | Database | Table | Notes |
| EDW-25564 | UWODS | sec.EmploymentStatus | Logic change, existing logic avaialble in new table sec.EmploymentStatusWorkerType |
| EDW-25654 | UWODS | sec.CustomerRefund | Column Removals |
| EDW-25590 | SpaceDataStore | sec.BuildingInteriorSpace | Data type changes |
| sec.EmployeeInSeat | |||
| sec.FunctionalUse | |||
| sec.PIsToRooms | |||
| sec.SharedSpace | |||
| sec.SpaceWorktag |
EmploymentStatus Logic Change – EDW-25564
A new table UWODS.sec.EmploymentStatusWorkerType has been created to replace the existing UWODS.sec.EmploymentStatus. The table currently named UWODS.sec.EmploymentStatus can show multiple statuses for the same person when they have worked under multiple worker types. The new table name better respresents this behavior and avoids confusion.
| Table | Notes |
| sec.EmploymentStatusWorkerType | New table (already available), replacing existing sec.EmploymentStatus. |
| sec.EmploymentStatus | Existing table, no change to column structure. Going forward will return one record instead of multiple when cases of multiple statuses for the same person. |
If you are in need of multiple statuses for the same person – please migrate from UWODS.sec.EmploymentStatus to UWODS.sec.EmploymentStatusWorkerType
CustomerRefund Column Removals – EDW-25654
| Table | Column | Notes |
| sec.CustomerRefund | RefundStatusKey | Replace with RefundStatus_DocumentStatusKey |
| RefundStatusWID | Replace with RefundStatus_DocumentStatusWID |
SpaceDataStore Data Type Change Details – EDW-25590
| Table | Column | Existing Data Type | New Data Type |
| sec.BuildingInteriorSpace | Usable | No data type change, currently showing sq ft. Will change back to Yes/No | |
| Assignable | |||
| sec.SharedSpace | BuildingKey | varchar(max) | nvarchar(50) |
| FloorKey | varchar(max) | nvarchar(50) | |
| SpaceID | varchar(max) | nvarchar(50) | |
| ShortName | varchar(max) | nvarchar(25) | |
| AllocationAssignmentKey | varchar(max) | nvarchar(50) | |
| RoomPercent | varchar(max) | numeric(10,2) | |
| sec.EmployeeInSeat | EmployeeID | varchar(max) | nvarchar(9) |
| PrimaryRoom | varchar(max) | boolean | |
| BuildingKey | varchar(max) | nvarchar(50) | |
| FloorKey | varchar(max) | nvarchar(50) | |
| SpaceID | varchar(max) | nvarchar(50) | |
| ShortName | varchar(max) | nvarchar(25) | |
| sec.FunctionalUse | FunctionalUse | varchar(max) | nvarchar(6) |
| RoomPercent | varchar(max) | numeric(10,2) | |
| AllocationAssignmentKey | varchar(max) | nvarchar(50) | |
| BuildingKey | varchar(max) | nvarchar(50) | |
| FloorKey | varchar(max) | nvarchar(50) | |
| SpaceID | varchar(max) | nvarchar(50) | |
| ShortName | varchar(max) | nvarchar(25) | |
| sec.PIsToRooms | EmployeeID | varchar(max) | nvarchar(9) |
| PIPercent | varchar(max) | numeric(10,2) | |
| BuildingKey | varchar(max) | nvarchar(50) | |
| AllocationAssignmentKey | varchar(max) | nvarchar(50) | |
| FloorKey | varchar(max) | nvarchar(50) | |
| SpaceID | varchar(max) | nvarchar(50) | |
| ShortName | varchar(max) | nvarchar(25) | |
| sec.SpaceWorktag | WorktagID | varchar(max) | nvarchar(10) |
| WorktagName | varchar(max) | nvarchar(255) | |
| WorktagPurpose | varchar(max) | nvarchar(100) | |
| CostCenter | varchar(max) | nvarchar(10) | |
| EmployeeID | varchar(max) | nvarchar(9) | |
| AllocationAssignmentKey | varchar(max) | nvarchar(50) | |
| PrimaryRoom | varchar(max) | boolean | |
| BuildingKey | varchar(max) | nvarchar(50) | |
| FloorKey | varchar(max) | nvarchar(50) | |
| SpaceID | varchar(max) | nvarchar(50) | |
| ShortName | varchar(max) | nvarchar(25) | |