Service News Category: Enterprise Data Warehouse

  • UWSDBDataStore Reorg on October 19, 2024

    September 27, 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…

  • UWSDBDataStore Reorg on January 27, 2024

    January 17, 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…

  • HR Hierarchy data now in UWODS

    October 26, 2023

    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…

  • UWSDBDataStore Reorg on October 21, 2023

    October 11, 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…

  • UWODS and WDFinDataMart Databases now offering Workday HR/Payroll and Finance data

    July 13, 2023

    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…

  • EDW for Finance Transformation Release 21 is Now Available

    May 31, 2023

    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…

  • UWSDBDataStore Reorg on June 3, 2023

    May 22, 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…

  • EDW for Finance Transformation Release 20 is Now Available

    May 2, 2023

    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…

  • EDW for Finance Transformation Release 19 is Now Available

    April 4, 2023

    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…

  • Important Notice – Upcoming Data Tenant Changes in EDP for Finance Transformation Environments

    March 29, 2023

    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…