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.

EDW server names changed in August, 2014. See the crosswalk for a list of old and new server names.

Data Server

Server

Database

Description

edwpub.s.uw.edu

(via views with sec schema)

Note: some users may need a port number to connect, in which case use edwpub.s.uw.edu,1433

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

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

Cube Server

Server

Database

Cube

Description

cubes.uw.edu

Note: some users may need a port number to connect, in which case use cubes.uw.edu,2383

EDWAdminMart

EDWAdminMart

  • EDW report usage statistics since 2008
  • Cube refresh is on demand

EDWAdminMart

OLAPAdminMart

  • EDW cube usage statistics since 2010
  • Cube refresh is on demand

FinancialActivity2013*

Fin Activity Biennium 2013

  • 2013 Biennium to date
  • Cube refresh is daily

FinancialActivity2011*

Fin Activity Biennium 2011

  • 2011 Biennium to date
  • Cube refresh is daily through 7/31/2013, then frozen

FinancialActivity2009*

Fin Activity Biennium 2009

  • 2009 Biennium to date
  • No cube refresh required as biennium is closed
FinancialActivity2007*

Fin Activity Biennium Minus1

  • Full 2007 Biennium
  • No cube refresh required as biennium is closed
RADCube

RAD

  • Research Administration Awards data from 2006
  • Cube refresh is daily
*The Financial Activity cubes reflect transactions from the BudgetActivityDetail table in the ODS database.