Enterprise Data Warehouse News
November 14, 2022
EDW Databases and Resources Available to Support Finance Transformation
The Enterprise Data Warehouse (EDW) is a secure central repository that integrates data from many sources across the University. It stores current and historical data that are used to support operational reporting and strategic analysis. The goal of the EDW is to support better and faster data-informed decision making. For more information about the EDW and how it fits within the Enterprise Data Platform, refer to Enterprise Data Platform. EDW and UW Finance Transformation (UWFT) UW Finance Transformation (UWFT) is much more than a system update - it is a redesign of our finance-related policies and processes, with the help of new...
Read EDW Databases and Resources Available to Support Finance Transformation
November 6, 2022
How To: URM Status SQL Function in the EDW
Do you get tired of maintaining the same business logic in many data products and spending too much time updating the logic in all those products? Are you looking for one version of the truth across all your academic reports, data cubes, and dashboards? The BI Team has great news for you. The EDW supports the first academic data-related SQL function, URM (Underrepresented Minority) Status, to help you reduce business logic maintenance, improve code readability, and keep one version of the truth for Underrepresented Minority students. Imagine that instead of spending time on updating, let's say, 12 academic reports with...
September 30, 2022
UWSDBDataStore Reorgs on October 22, 2022 and December 21, 2022
UWSDBDataStore Reorgs on October 22, 2022 & December 21, 2022 The student database (SDB) will go through a reorganization on October 22, 2022 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on October 24, 2022. 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. Please Note: The following column renames will be occurring in the SDB screens as of 10.22.22. The renames will be perpetuated to UWSDBDataStore and...
Read UWSDBDataStore Reorgs on October 22, 2022 and December 21, 2022
July 13, 2022
Knowledge Navigator Metadata Update Spring Qtr 2022
UW Metadata Manager, Keith A. Van Eaton, from Information Management’s Enterprise Reporting & Analytics team, has added or updated metadata objects in Knowledge Navigator. In their ongoing partnership, the UW’s data domain stewards, subject matter experts, and metadata manager ensure metadata objects are vetted and approved so that UW data users have a common understanding around UW data. New terms added 16 UW Workday Terms 9 Research Terms 7 Academic Terms New structured objects or reports added 17 Enterprise Dashboards 1 UW Finance Cube 1 UW General Ledger Cube 3 tables & 70 columns EFECSDataStore database 6 tables & 100...
May 31, 2022
UWSDBDataStore Reorg on June 4, 2022
UWSDBDataStore Reorg on June 4, 2022 The student database (SDB) will go through a reorganization on June 4, 2022 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on June 6. 2022. 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. Last Updated - 5.31.22 Columns to be Added Table Column DataType sa_transaction op_dat_wd_ck_no int sf_evaluation bridge_grant_amt int state_aid_only char(1) student_2 titleix_stat tinyint titleix_stat_dt datetime titleix_exp_dt datetime titleix_comment char(75)...
April 8, 2022
New CoreData Database provides a standard set of country names, abbreviations, and codes
Prior to 2021, the UW lacked a uniform list of countries from which to perform reporting and data analysis. This caused difficulty in providing consistent data and information across the enterprise and led to calls for a universal standard. In response to this need, the UW’s Data Governance Operational Committee published the UW Country Code Standard. In partnership with the UW’s Data Governance (DG) Operational Committee and Office of Global Affairs, the Enterprise Data Warehouse (EDW) has introduced the CoreData Database to help departments across the University adhere to this standard set of country names, abbreviations, and codes. Who should...
Read New CoreData Database provides a standard set of country names, abbreviations, and codes
January 27, 2022
UWSDBDataStore Reorg on January 29, 2022
UWSDBDataStore Reorg on January 29,2022 The student database (SDB) will go through a reorganization on January 29,2022 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on January 31, 2022. 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. (last modified: 01.29.2022) *Please continuously monitor this site for the most current update. Old Columns to be deleted Table Column sa_sf_fund fund_flag_45 sa_wd_det_trans wd_det_proc_pd sa_wd_sum_tran wd_sum_proc_pd Columns to be Added...
October 12, 2021
UWSDBDataStore Reorg on October 23, 2021
The student database (SDB) will go through a reorganization on October 23, 2021 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on October 25, 2021. 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. (last modified: 10.22.2021) *Please continuously monitor this site for the most current update. Old Columns to be deleted Table Name Column Name sdbdb01 g_sa_flag4 sa_sf_awards award_event_dt1 award_event_dt2 award_event_dt3 award_event_dt4 award_event_dt5 award_event_dt6 award_status_cd1 award_status_cd2 award_status_cd3...
July 15, 2021
UWSDBDataStore changes for August 9,2021
The EDW team will perform housecleaning on the UWSBDataStore on August 9, 2021. This is to make some column names, data types and nullability constraints to be exactly aligned to the source system. Please take note of the changes below which may affect your queries and reports. Send all questions and concerns to help@uw.edu, with the subject line: "UWSDBDataStore Changes 08.09.2021". Column Rename TABLE NAME OLD COLUMN NAME NEW COLUMN NAME sys_tbl_39_calendar fifth_yr_reg_dt_c2 fifth_yr_rg_dt_c2 Data Type Change TABLE NAME COLUMN NAME OLD DATA TYPE NEW DATA TYPE APPLHISTAdmInst appl_qtr smallint tinyint APPLHISTAdmInst inst_type smallint tinyint APPLHISTAdmInst system_key decimal int APPLHISTAdmInst trans_campus smallint...
May 14, 2021
UWSDBDataStore Reorg on June 5, 2021
The student database (SDB) will go through a reorganization on June 5, 2021 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on June 7, 2021. 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. (last modified: 05.28.2021) *Please continuously monitor this site for the most current update. Old Columns to be deleted Table Name Column Name sa_sf_fund fund_type sr_instructor instr_hepps_dt sr_stu_disability stu_disab_grp_cd stu_disab_acc_5 sys_tbl_19_disability_grp disab_grp_desc New columns to...