Service News Category: Enterprise Data Warehouse

  • 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 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…

  • UWSDBDataStore Reorg on January 29, 2022

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

  • 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 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…

  • UWSDBDataStore changes for August 9,2021

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

  • 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 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…

  • 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  Second, to secure all Spend financials and diversity indicators attributed to those suppliers  And last, to attribute Procurement Credit Card transactions to the true supplier,…

  • 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 working on reports and visualizations that use fiscal calendar parameters/variables. Context:  In SQL, a function is a program that takes some input and generates a…

  • 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 are not able to resolve, please write help@uw.edu and put “EDWPub Server Upgrade” in the subject line.

  • 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”. Thank you, EDW team 2/2/2021 We’d like to share upcoming changes to the following columns in the views of the ODS and HumanResources databases.  The Impacted…

  • 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, the type of data you want most is Finance (75%), HR/Payroll (62%) and Academic (54%). Among the variety of databases that you access, the top…