Overview

The Enterprise Data Warehouse (EDW) at the University of Washington provides structured data access for institutional reporting and analysis. This guide outlines the available server environments, the databases in use, and how to access them.

Server Environments

Each EDW database operates in two environments:

• Production (PROD)
  • SQL Server: edwpub.s.uw.edu
  • Updates: Databases follow unique update schedules, listed under Data Load Status
• Test (TEST)
  • SQL Server: edwtestpub3.s.uw.edu
  • Updates: Applied as needed or by request via edw-help@uw.edu
  • Latest Changes: Listed on Data Load Status; modifications may be made without notice

Available Databases

EDW databases store essential financial, academic, and research data. Below is a breakdown of major databases and their current state.

 

Database	Description	State
CoreData	A database that includes a cross-section of source-similar reference data from multiple domains, which is designated by the UW Data Governance Steering Committee as essential to UW core business. This data is managed to guarantee uniformity and usage in support of UW functions.	Current
EDWPresentation	The presentation layer includes integrated financial, research, and academic data designed for easy queries and analysis, with certified definitions and documented business rules. The presentation layer is optimized for commonly requested queries and analyses of institutional data. Predefined reports, dashboards, and cubes based on EDWPresentation data are available in the BI Portal.	Current
IBS	The Institutional Base Salary (IBS) database is the operational database for School of Medicine salary data downloaded from ADP.	Current
UWODS	The UWODS is a database which reflects the Foundation Data Model (FDM), the technical framework that organizes HR/Payroll and Finance data in UW's implementation of Workday. This database supports reporting for the following: Workday Foundation Data Model (FDM) and Financial Reference Data HR/Payroll Data	Current
UWSDBDataStore	A relational database that provides data from the central mainframe Student system which includes student demographic information, course schedule and student enrollment information, student degrees, student majors, registration and transcript information, and many other topics and tables in the area of academics.	Current
WDFinDataMart	A Finance Data Mart introduced as part of UW Finance Transformation (UWFT) and providing the following data from Workday: Accounting & Operational Journal Transactions Grant & Financial Budgets Current Budget Balances Payroll Journal Line Detail	Current
RAD2	RAD2 is an analytic database in the Enterprise Data Warehouse (EDW) that supports research administration reporting by providing access to proposal, award, and sponsor data. Built in collaboration with ORIS and launched in April 2025, RAD2 replaces the legacy RAD Cube and addresses data gaps caused by the transition to Workday Finance. It integrates proposal data from SAGE via the RIP platform, award data from Workday, and sponsor data from FE-App, enabling users to analyze research activities by sponsor, funding action type, and organizational unit.	Current
AnalyticInteg (AIDB)	A sandbox environment that was created to give data users across campus the ability to work with and explore PNBDB data structures in a SQL context. AIDB was built in collaboration with the Office of Planning and Budgeting (OPB) to serve as a proof of concept for consolidating academic and finance data.	Academic data: Current Finance data frozen as of 7/27/2023 with the retirement of FAS and introduction of Workday Finance. (See UWODS and WDFinDataMart for current data).
FinancialSumMart	A relational database that is organized to meet various administrative needs including annual financial auditing, UW organizational financial reporting, and budgeting analysis. The data covers the university business domains of budget, expenditures, revenue, gifts and endowments, as well as some grant information.	Frozen as of 7/27/2023 with the retirement of FAS and introduction of Workday Finance. (See UWODS and WDFinDataMart for current data)
FRDataMart	Archive (from the ODS) of one year payroll check register detail, and gross pay control totals used for verification.	Frozen as of 7/27/2023 with the retirement of FAS and introduction of Workday Finance
GLDataMart	A General Ledger Data Mart. This database contains GL transactions including payroll cash detail and use tax detail for the current biennium and prior three biennia.	Frozen as of 7/27/2023 with the retirement of FAS and introduction of Workday Finance. (See UWODS and WDFinDataMart for current data).
HumanResources	An integration database for HR/Payroll data	Frozen as of 7/27/2023 with the retirement of FAS and introduction of Workday Finance (See UWODS and WDFinDataMart for current data).
ODS	A relational database based on data that was originally captured in the central mainframe financial system (FAS) and the Human Resources/Payroll system (Workday). This database includes financial transactions, a variety of paid and unpaid employment information, academic relationships, details about positions at the UW, and many other topics and tables in the area of Finance and HR/Payroll.	Frozen as of 7/27/2023 with the retirement of FAS and introduction of Workday Finance. (See UWODS and WDFinDataMart for current data).
RAD	Relational database that provides Research Administrative data related to research activities.	Frozen as of 7/6/2023 with the retirement of FAS and introduction of Workday Finance. (See UWODS and WDFinDataMart for current post-Award data. Contact grantrp@uw.edu for pre-Award data.
EFECSDataStore	This database is a copy of some Management Accounting & Analysis (MAA)-related tables from the eFECS EffortReport database.	Frozen with the retirement of FAS/Introduction of WorkDay.