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. |
