Enterprise Data Warehouse News
November 25, 2019
Table Reorg for the UWSDBDataStore Curriculum Management objects on December 16, 2019
Hello, The Curriculum Management tables in UWSDBDataStore will have some changes on Dec. 16, 2019. These changes to the objects (listed below) will be available in the UWSDBDataStore on Dec 17, 2019 . However, data on the new objects will be visible as soon as the Data Custodians submit the security role definitions. (last updated: 11.25.2019) New columns to be added: Table Name Column Name Data Type CM_Programs CIPCode_title nvarchar(300) program_dateEndLabel varchar(25) CM_Credentials credential_dateEndLabel varchar(25) CIPCode_title nvarchar(300) stemCIP varchar(10) alt_thesis_requirement varchar(100) Existing columns to be deleted: Table Name Column Name CM_Programs Program_Status CM_Credentials credential_Status Please Note: The scope of...
Read Table Reorg for the UWSDBDataStore Curriculum Management objects on December 16, 2019
October 28, 2019
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 Medical Center (UWMC) UW Physicians (UWP) staff will become part of the UW Medicine Health System (UWMHS) supervisory org structure in Workday and part of the School of Medicine otherwise A major component of this consolidation effort includes integration of ~2600 NWH and UWP employees...
Read EDW & EWS Data Changes Coming to Support Northwest Hospital (NWH) and UW Physicians (UWP)
October 16, 2019
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 column name. There is another column in the table, “TotalUpdTransfer”, that should be used instead. Please send all questions and concerns to help@uw.edu, with the subject line “UWProfilesStudent Update 11/4/2019”.
October 16, 2019
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 may occur during this time Potential service disruptions Potential delayed data This exercise has been rescheduled from its original date of October 9, 2019. If you have any questions or concerns, please contact us at help@uw.edu. Update October 23, 9:22 a.m.: The EDW Annual DR...
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...