Enterprise Data Warehouse News
October 3, 2019
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 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 may occur during this time Potential service disruptions Potential delayed data If you have any questions or concerns, please contact...
September 26, 2019
UWSDBDataStore Reorg on October 19, 2019
Hello, The student database (SDB) will go through a reorganization on Oct. 19, 2019 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on Monday, Oct. 21, 2019 . (However, data on the new objects will be available as soon as the Data Custodians submit the security role definitions and the SIS team loads the data.) * New columns to be added: (last updated: 10.14.2019) Table Name Column Name Data Type Description budget_resources br_pkg_formula_no tinyint The packaging formula being used for the student for the specified quarter sa_sf_fund...