Overview & History

What is the Caltech Data Warehouse?

Overview
The Caltech Data Warehouse is a reporting tool that gathers and analyzes data from the central administrative systems. It takes huge amounts of data from various source systems and converts it into meaningful information.

The datamarts are described below.

HR Datamart
The Human Resources (HR) Datamart consists of essential personnel and salary information from Oracle Applications' Human Resources module. Information in the HR Datamart includes detailed information on employees' information such as name, address, assignment(s), organization, and salary information.

Grants Accounting Datamart
The Caltech Grants Accounting (GA) Datamart consists of essential financial reporting information from the Oracle Applications Grants Accounting module. Information in the GA Datamart includes financial summaries; expenditure and commitment details; and installment, funding, and budgeting data.

FAMIS Datamart (Facilities)
The Caltech FAMIS Datamart consists of essential Facilities information from the FAMIS system. Information in the FAMIS Datamart includes Capital Project cost analysis, work order detail, labor utilization, equipment history, and building maintenance costs.

Labor Distribution Datamart
The Labor Distribution (LD) Datamart consists of essential labor schedule and distribution information from Oracle Applications' Labor Distribution module. Information in the LD Datamart includes detailed information on employees' labor schedules, labor distributions and adjustments.
The LD Datamart is updated on a nightly basis.

 

History

Caltech implemented its first Data Warehouse in 1999 when the Oracle Applications went live. Since then, Oracle Discoverer and Webster have been the main reporting tools on Campus. Approximately 1,500 people still use Discoverer for reporting. Over the last several years, other reporting tools have been implemented to meet the needs of specific business areas. These tools are not integrated with one another. 

In 2005, Caltech purchased the Cognos reporting tool. The first phase of the Caltech Data Warehouse re-design project implemented the Accounts Payable, Purchasing, and General Ledger datamarts. For the first time, Caltech had an integrated reporting tool that could be expanded to fit the needs of a Campus-wide user community.

Phase III of the Caltech Data Warehouse went live Tuesday, July 6th, 2010. This phase included the addition of the HR Datamart.