Service News Category: Enterprise Data Warehouse

  • Knowledge Navigator Metadata Update Spring Qtr 2022

    July 13, 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…

  • New CoreData Database provides a standard set of country names, abbreviations, and codes

    April 8, 2022

    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…

  • UWSDBDataStore Reorg on October 23, 2021

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

  • UWSDBDataStore Reorg on June 5, 2021

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

  • New PAS Data Enhancement in the EDW

    March 4, 2021

    Procurement Credit Card Spend Data Now Matched to True Supplier In October of 2018, a project was initiated to capture all suppliers from the University’s Procurement Accounting System (PAS) in the Enterprise Data Warehouse (EDW). The project was comprised of three major steps: First, to capture all existing Suppliers from the PAS system in EDW …

  • How To: Finance Date Functions in EDW

    February 22, 2021

    Do you ever get tired of building complicated date logic in your EDW queries? The EDW now supports several finance date functions to help you simplify your queries! These functions help enterprise data users to easily convert calendar dates, months, and years to UW fiscal calendar objects. These functions are most helpful to SQL developers…

  • EDW Upgrade to SQL Server 2019 Complete

    February 10, 2021

    The EDW successfully upgraded our user-facing servers (EDWPub.s.uw.edu) to SQL Server 2019.  We believe you will experience minimal impact, however, if you do experience any issues, please reference our IT Connect article titled, “Preview available for upcoming EDW server upgrade” which contains a list of known issues. Reporting issues If you experience any issues you…

  • Upcoming changes on EDW process dates for WorkerPosition-related views

    February 2, 2021

    Update on 2/12/2021: EDW team is going to deploy this change on Saturday February 27th to give room for our Payroll data processing to take place in the week of March 1st.  If you have any concerns with the 2/27 deployment, please let us know as soon as possible by emailing help@uw.edu with the subject: “EDW WorkerPosition Changes”….

  • EDW Customer Survey: The Results Are In

    January 21, 2021

    If you participated in the EDW’s Customer Survey, thank you! Understanding how you use the EDW helps us improve our services and enhances our ability to support you now and in the future. Over One Million You queried the EDW over one million times from August 2019 to August 2020. By Popular Demand By far,…

  • UWSDBDataStore Reorg on January 30, 2021

    December 18, 2020

    The student database (SDB) will go through a reorganization on January 30, 2021 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on February 1, 2021. However, data on the new objects will be available as soon as the Data Custodians submit…