Service News Category: Enterprise Data Services

  • Empowering PIs and Grant Managers: New Resources for Grant Reporting

    March 28, 2024

    For many Grant Managers and Principal Investigators, the implementation of Workday Finance marked the beginning of a journey—for answers, efficiencies, and reports, but most importantly, data. Along the way, these folks have come across Office Hours and Webinars, UW Connect articles and wiki pages, seeking answers and sharing gaps and pain points, all of which have supported us as we develop solutions. While there is still more work to do, the Finance DATAGroup, with support from UW-IT Reporting & Analytics,…

  • Streamlining Security for Admissions Reporting in the BI Portal

    February 7, 2024

    Two resources in the BI Portal leverage the same data: UW Admissions Cube and All Applications Report. In an effort to streamline security for this data, we recently deployed security updates to both of these resources. Why was this change necessary? Historically, access to the UW Admissions Cube and All Applications Report was managed separately, meaning that a user could have access to one resource, but not the other. This change allows us to grant user access at the data…

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

  • Complying with Federal Grant Reporting Requirements: The New SF425 Report

    January 2, 2024

    As of 12/29/23, the BI Portal now includes Release 1 of the SF425 report! This report allows Grant and Contract Accounting (GCA) to pull data from Workday into the SF425 Federal Financial Report, which is required to report on a grant’s cumulative expenses. This report was developed in collaboration between the BI Portal and DATAGroup teams. Check out the SF425 report in the BI Portal to learn more! Why is the SF425 report a big deal? For Release 1, the report pulls…

  • Exploring Non-Numeric Grade Values: A New Academic Dashboard in the BI Portal

    December 12, 2023

    As of 12/5/23, the BI Portal now includes the Non-Numeric Grade Frequency Distribution dashboard! This dashboard allows users to explore trends in grading patterns, missing grades, and other non-numeric grade outliers across UW academic departments. It reflects rolling data from the last 12 quarters and is intended for advisors, registrars and academic service leaders. Check out the Non-Numeric Grade Frequency Distribution dashboard in the BI Portal to learn more! What are non-numeric grade values? These are values assigned to a…

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

  • Bridging the Divide: Three New Finance Reports in the BI Portal

    October 23, 2023

    It’s been three months since the UW went live with Workday Finance and as the dust settles across the financial ecosystem, bumps and crevices, once hazy and undefined, are coming into focus. As users adapt to the tools and processes of the Workday era, some areas are proving to be more difficult to navigate than others—reporting is one of these areas. The BI Portal is hoping to bridge this gap through an iterative expansion of its catalog.  Collaborating to Meet…

  • Workday HCM Reports: Continuing the BI Portal Catalog Expansion

    October 17, 2023

    The BI Portal report catalog now includes Workday Human Capital Management (HCM) reports! These updates were deployed to the BI Portal on 11/1/23. Finding Workday HCM Reports Today Historically, the Workday HCM Report Catalog was stored in Knowledge Navigator and supported by the Integrated Service Center (ISC) to reflect all custom reports available in Workday’s HCM module. While these reports are now available in the BI Portal, they will remain in Knowledge Navigator until 11/30/23, along with a page announcement,…

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

  • New Version of FWS Deployed for Finance Transformation

    August 15, 2023

    We recently deployed Financial Web Service (FWS) v2 to Production (PROD) to support UW Finance Transformation (UWFT) and the implementation of Workday Finance! Check out our new customer portal! We’ve updated the Financial Web Service | FWS customer portal to reflect the current status of the service: Removed v1 content to streamline the customer experience. Updated the Memorandum of Understanding to communicate key resources, environment considerations, and release policies. Migrated FWS Inbound to a new (and separate) customer portal: Secure…