Decision Support

List of Servers, Data Sources and Descriptions

This page provides a list of the Data Warehouse servers, data sources, and a description of the content available to authorized users.

The Warehouse tier (in yellow) is for ad hoc querying and is not designed for performance queries or reports.

Server

Data Sources

Data Source Description

Production Data
edwsqlc1db2.admin.washington.edu\sql02

Test Data
edwtest1.admin.washington.edu\pres

(via views with sec schema)

EDWPresentation

Integrated financial, research, and academic data designed for easy queries and analysis, with certified definitions and documented business rules.

FinancialSumMart

Daily accumulation of FAS transaction data, budget index, etc.

FRDataMart

Archive (from the ODS) of one year payroll check register detail, and gross pay control totals used for verification.

GLDataMart

General ledger data mart. GL transactions including payroll cash detail and use tax detail for the current biennium and prior three biennia

Production Data
ucssqlc1db1.admin.washington.edu\ods

Test Data
edwtest1.admin.washington.edu\oper

(via views with sec schema)

EFECSDataStore

Daily snapshot of data generated from online faculty effort certification

ODS Daily snapshot of human resources and finance operational data.
RAD Daily snapshot of Research-Administrative data related to research activities

UWSDBDataStore

Daily snapshot of UWSDB including additional lookup tables

Production Data
edwsqlc1db1.admin.washington.edu

Test Data
edwtest1.admin.washington.edu\integ

(via views with sec schema)

HumanResources

UW employee and payment history detail from 1982 to the present.