Enterprise Data Warehouse News
October 11, 2023
UWSDBDataStore Reorg on October 21, 2023
UWSDBDataStore Reorg on October 21, 2023 The student database (SDB) will go through a reorganization on October 21, 2023 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on October 23, 2023 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 - 10.19.23 Columns to be Added Table Column DataType SF_EDIT_DESC SF_ED_Year_Code smallint SR_ADM_APPL SEATTLE_PROMISE char(1) SR_TEST_SCORES TEST_SCORE_DEC decimal(4,1) SYS_TBL_42_TEST_RANGE TEST_MIN_SCORE_DEC decimal(4,1) TEST_MAX_SCORE_DEC decimal(4,1) SYS_TBL_63_NONTUIT_CHANGES AID_REPAY_FUND int...
July 13, 2023
UWODS and WDFinDataMart Databases now offering Workday HR/Payroll and Finance data
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. Introducing Workday Finance data to the EDW The EDW is now providing Finance and HR/Payroll data from Workday with the introduction of two new databases: UWODS and WDFinDataMart. These databases went...
Read UWODS and WDFinDataMart Databases now offering Workday HR/Payroll and Finance data
May 31, 2023
EDW for Finance Transformation Release 21 is Now Available
Enterprise Data Warehouse (EDW) has released an update in UWODS and WDFinDataMart in support of UW Finance Transformation (UWFT). For an overview of how EDW is adapting to support UWFT, refer to EDW for Finance Transformation. Monthly Scheduled Releases Updates to UWODS and WDFinDataMart are released on the same monthly schedule. This allows us to better synchronize with Enterprise Data Platform’s release schedule for Finance Transformation. For more information, refer to the Data Availability Timeline. Updated access to UWODS and WDFinDataMart data If you HAVE ACCESS to EDW HR/Payroll and or Finance data in PRODUCTION today, you now have access to the same type of...
Read EDW for Finance Transformation Release 21 is Now Available
May 22, 2023
UWSDBDataStore Reorg on June 3, 2023
UWSDBDataStore Reorg on June 3, 2022 The student database (SDB) will go through a reorganization on June 3, 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 5. 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 - 06.01.23 Columns to be Added Table Column DataType BUDGET_RESOURCES BR_PPLUS_LOAN_FEE int BR_GPLUS_LOAN_FEE int DL_SUPL_PLUS SP_PREV_CR_STAT char(1) SF_EDIT_DESC SF_ED_EDIT_CD2 char(3) SF_ED_EDIT_CD3 char(3) SF_ED_HOLD_CD2 char(2) SF_EVALUATION...
May 2, 2023
EDW for Finance Transformation Release 20 is Now Available
Enterprise Data Warehouse (EDW) has released an update in UWODS and WDFinDataMart in support of UW Finance Transformation (UWFT). For an overview of how EDW is adapting to support UWFT, refer to EDW for Finance Transformation. Monthly Scheduled Releases Updates to UWODS and WDFinDataMart are released on the same monthly schedule. This allows us to better synchronize with Enterprise Data Platform’s release schedule for Finance Transformation. For more information, refer to the Data Availability Timeline. What’s New in EDW Release 20 Database Overview of Release UWODS This release includes: 2 new tables containing 33 columns and 119 columns were added to existing tables. Introduced Breaking Changes by renaming and...
Read EDW for Finance Transformation Release 20 is Now Available
April 4, 2023
EDW for Finance Transformation Release 19 is Now Available
Enterprise Data Warehouse (EDW) has released an update in UWODS and WDFinDataMart in support of UW Finance Transformation (UWFT). For an overview of how EDW is adapting to support UWFT, refer to EDW for Finance Transformation. Monthly Scheduled Releases Updates to UWODS and WDFinDataMart are released on the same monthly schedule. This allows us to better synchronize with Enterprise Data Platform’s release schedule for Finance Transformation. For more information, refer to the Data Availability Timeline. What’s New in EDW Release 19 Database Overview of Release UWODS This release includes 20 new tables and 156 columns were added to existing tables. Introduced Breaking Changes by removing columns from a table....
Read EDW for Finance Transformation Release 19 is Now Available
March 29, 2023
Important Notice – Upcoming Data Tenant Changes in EDP for Finance Transformation Environments
Updated April 19, 2023 Some EDP environments will be subject to multiple data tenant switches during the month of April to support various UWFT activities. If you are accustomed to using the following environments for your development and testing work, these environments may not reflect the data you think it should during this time. Tenant build 5.0 data is now available in FWS v2 EVAL and UWODS/WDFinDataMart PROD environments per the EDP FT Environment Schedule. Environment Expected Dates for Unreliable Data Recommended Action Link to Reliable Environment FWS v2 DEV Outbound March 30 – May 3 If you require a...
Read Important Notice – Upcoming Data Tenant Changes in EDP for Finance Transformation Environments
February 28, 2023
EDW for Finance Transformation Release 18 is Now Available
Enterprise Data Warehouse (EDW) has released an update in UWODS and WDFinDataMart in support of UW Finance Transformation (UWFT). For an overview of how EDW is adapting to support UWFT, refer to EDW for Finance Transformation. Monthly Scheduled Releases Updates to UWODS and WDFinDataMart are released on the same monthly schedule. This allows us to better synchronize with Enterprise Data Platform’s release schedule for Finance Transformation. For more information, refer to the Data Availability Timeline. What's New in EDW Release 18 Database Overview of Release UWODS This release includes 36 new tables and 366 columns were added to existing tables. Introduced Breaking Changes by...
Read EDW for Finance Transformation Release 18 is Now Available
January 30, 2023
EDW for Finance Transformation Release 17 is Now Available
Enterprise Data Warehouse (EDW) has released an update in UWODS and WDFinDataMart in support of UW Finance Transformation (UWFT). For an overview of how EDW is adapting to support UWFT, refer to EDW for Finance Transformation. Monthly Scheduled Releases Updates to UWODS and WDFinDataMart are released on the same monthly schedule. This allows us to better synchronize with Enterprise Data Platform’s release schedule for Finance Transformation. For more information, refer to the Data Availability Timeline. What's New in EDW Release 17 Database Overview of Release UWODS This release includes 9 new tables, 2 new views, and 22 columns were added to existing tables. Introduced Breaking Changes by renaming and...
Read EDW for Finance Transformation Release 17 is Now Available
January 23, 2023
UWSDBDataStore Reorgs on January 28, 2023
UWSDBDataStore Reorgs on January 28, 2023 The student database (SDB) will go through a reorganization on January 28, 2023 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on January 30, 2023. 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 - 01.23.2023 Column Adds to Existing Tables: Table Column DataType STUDENT_2 IMM_CON_ID CHAR(12) STUDENT_2_UW_DEGREE_INFO DEG_GRANT_DATE DATETIME SF_EVALUATION INCARC_APP_FLG CHAR(1) Columns to be Removed: Table Column STUDENT_2...