Enterprise Data Warehouse News
May 29, 2025
Announcement: New Data Addition to the RAD2 Database in EDW
The RAD2 database is introducing the second set of Research Administration Data views, which are obtained from the Research Integration Platform in the Office of Research Information Services (ORIS), whereby data from the SAGE system and associated datasets are integrated. vAdminAction vAdminActionSubtype vAdvance vAward vAwardRequest vAwardSetupRequest vComplianceQuestion vComplianceResponse Definitions for the views and columns will be made accessible in the Knowledge Navigator shortly. The EDW team will incorporate an additional set of views into RAD2 in the near future as soon as the source data has been verified to meet Production quality standards. Tentative list: vComplianceSubResponse vModification The announcement of the RAD2 launch in...
Read Announcement: New Data Addition to the RAD2 Database in EDW
May 19, 2025
UWSDBDataStore Reorg on June 7, 2025
UWSDBDataStore Reorg on June 7, 2025 The student database (SDB) will go through a reorganization on June 7, 2025 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on June , 2025 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.30.2025 Additions Table Column DataType SA_TRANSACTION CXLD_CHECK_RPTD bit SF_EVALUATION CUI_IP_ATI decimal(15,0) CUI_IP_P_PTA decimal(15,0) CUI_IP_IPA int CUI_IP_P_PEEA decimal(15,0) CUI_IP_AI int CUI_IP_AAI int CUI_IP_STX int CUI_IP_STD_PTA decimal(15,0)...
April 9, 2025
Announcement: Launch of the New RAD2 Database in EDW
A new database RAD2 is introducing the initial set of Research Administration Data views, which are obtained from the Research Integration Platform in the Office of Research Information Services (ORIS), whereby data from the SAGE system and associated datasets are integrated. vEGC1 vEGC1Abstract vEGC1Person vProposedBudgetData vSubaward vSubawardRequest vSubrecipient Definitions for the views and columns will be made accessible in the Knowledge Navigator shortly. The EDW team will incorporate an additional set of views into RAD2 in the near future as soon as the source data has been verified to meet Production quality standards. Tentative list: vAdminAction vAdminActionSubtype vAdvance vAward vAwardRequest...
January 22, 2025
UWSDBDataStore Reorg on February 1, 2025
UWSDBDataStore Reorg on February 1, 2025 The student database (SDB) will go through a reorganization on February 1, 2025 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on February 3, 2025 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 - 1.30.2025 Columns to be Added Table Column DataType SF_EVALUATION1 PROF_JUDGE_DATE datetime STUDENT_1 TOT_NONGRD_ATTMP decimal(4,1) TRANSCRIPT QTR_NONGRD_ATTMP decimal(3,1) Columns to be Removed Table Column SF_EVALUATION COFH_INDICATOR...
September 27, 2024
UWSDBDataStore Reorg on October 19, 2024
UWSDBDataStore Reorg on October 19, 2024 The student database (SDB) will go through a reorganization on October 19, 2024 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on October 21, 2024. 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 - 9.27.24 Columns to be Added Table Column DataType ISIR_TRANSACTIONS ISIR_MAX_PELL_IND char(1) ISIR_MIN_PELL_IND char(1) I_SPO_BIRTH_DT datetime I_SPO_SS_NO int I_P1_BIRTH_DT datetime I_P1_SS_NO int I_P2_BIRTH_DT datetime I_P2_SS_NO int...
January 17, 2024
UWSDBDataStore Reorg on January 27, 2024
UWSDBDataStore Reorg on January 27, 2024 The student database (SDB) will go through a reorganization on January 27, 2024 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on January 29, 2024. 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 - 1.23.24 **below additions to SF_Evaluation will result in additional records being shifted to SF_Evaluation1, will add details as soon as available. Columns to be Added...
October 26, 2023
HR Hierarchy data now in UWODS
Introducing HR Hierarchy Historically, UW relied on financial org code (fin org) for HR reporting. With the introduction of Workday Finance, fin org was retired and a replacement was needed to support HR reporting going forward. A new HR Hierarchy structure that more accurately represents HR relationships was introduced to Workday. To learn more about the new HR Hierarchy, refer to https://hr.uw.edu/hrbais/hrhierarchy/. Introducing a new HROrganization table in UWODS The Enterprise Data Warehouse (EDW) introduced the UWODS database in July 2023, which provides HR/Payroll and Finance data sourced from Workday. The EDW recently added a new HROrganization table to UWODS...
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