EDW Payroll data will include NWH and UWP employees

As part of the Enterprise Data Warehouse’s support for the Northwest Hospital Integration effort, beginning with the next payroll, pay period Jan 1-15, the EDW payroll data will include the Northwest Hospital (NWH) and UW Physicians (UWP) employees who are all now UW employees as of the beginning of 2020. If you have any questions…

Column Change: EarnType in BudgetActivityDetail

The Change The length for column EarnType (description) in the BudgetActivityDetail table has been increased from a varchar(25) to a varchar(255). This change will occur in the following ODS tables: BudgetActivityDetail BudgetActivityDetail2Bien BudgetActivityDetailCurrentBiennium BudgetActivityDetailCurrentBienniumMinus1 BudgetActivityDetailCurrentBienniumMinus2 BudgetActivityDetailCurrentBienniumMinus3 BudgetActivityDetailCurrentBienniumMinus4 BudgetActivityDetailCurrentBienniumMinus5 BudgetActivityDetailCurrentBienniumMinus6 BudgetActivityDetailCurrentBienniumMinus7 How will this affect me? If you query the tables directly, you may be affected….

UWSDBDataStore Reorg on February 1, 2020

Hello, The student database (SDB) will go through a reorganization on February 1, 2020 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on Monday, February 3, 2020. (However, data on the new objects will be available as soon as the Data…

EDW HR/Payroll data will be paused 12/27-12/28 to support Northwest Hospital Cutover

Between December 26-29, 2019, Northwest Hospital and UW Physicians employees will be integrated into Workday. During this transition period, employee data from Workday may not be complete. Therefore the EDW will proactively pause daily HR/Payroll data updates until the fully integrated employee data is available. The last EDW HR/P daily load before the pause will…

EDW & EWS Data Changes Coming to Support Northwest Hospital (NWH) and UW Physicians (UWP)

This is a heads up on upcoming changes to both the Enterprise Data Warehouse (EDW) and Enterprise Web Services (EWS).   As you may be aware, UW Medicine is currently in the process of consolidating activities across two of its major entities:  Northwest Hospital (NWH) will become a second campus of the University of Washington…

EDWPresentation – UWProfilesStudent Reorg 11/4/2019

This table is scheduled to be updated on Monday, November 4th, 2019. Logic changes:    Table Name Column New Logic UWProfilesStudent VisaType Blank values will show as NULL RunningStart Blank values will show as NULL   Columns to be deleted:    Table Name Column Name Notes UWProfilesStudent ToalUpdTransfer There was a typo in the original…

EDW Disaster Recovery Exercise on October 23, 2019

On Wednesday, October 23, 2019 from 8 a.m. to 10:30 a.m. the Enterprise Data Warehouse team will complete our Annual Disaster Recovery Exercise. Because this exercise affects the EDWPUB SQL Server as well as Reporting Services Reports hosted on the BI Portal, your user experience may be impacted in the following ways: System performance issues…

EDW Disaster Recovery Exercise Rescheduled

Update Oct 9 2019 8:21AM: The EDW DR Exercise previously scheduled for this morning has been cancelled and will be rescheduled for a later date. On Wednesday, October 9, 2019 from 8 a.m. to 10:30 a.m. the Enterprise Data Warehouse team will complete our Annual Disaster Recovery Exercise. Because this exercise affects the EDWPUB SQL…