Penn Computing

Penn Computing

Computing Menu Computing A-Z
Computing Home Information Systems & Computing Penn

Current Load Status
Regular Availability
FAQs & Tips
Password Changer
Support services
About the Data Warehouse
Data Administration
Express Mail
General Ledger
Learning Management
Position Inventory
Research-PennERA Proposals
Salary Management
Travel Expense Management
Tuition Distribution

About the Warehouse and the Data Collections

Implemented in 1995 after an indepth pilot study, the University's Data Warehouse makes Penn's institutional data available to decision makers for query, analysis, and reporting. The Warehouse stores selected data from Penn's business systems, such as SRS (Students Record System) and BEN Financials. The data is filtered, made consistent, and aggregated in various ways. Use of the Warehouse is restricted to authorized individuals of the Penn community. Access to the Warehouse does not require formal programming skills; desktop tools such as Business Objects support analysis and reporting.

The Warehouse contains student and course data, sponsored project data, salary management data, general ledger data, property management asset data, space data and insitutional advancement data. See the quick reference guides below for overviews of the various data collections.

  • Assets (PDF)
  • BRS (PDF)
  • Facilities (PDF)
  • Faculty (PDF)
  • General Ledger (PDF)
  • PennERA Proposals / Research (PDF)
  • Salary Management (PDF)
  • Student (PDF)
    • Graduate Admission (PDF)
    • Student Financial Aid (PDF)
  • Travel and Expense Management (PDF)
  • Tuition Distribution (PDF)

While the Warehouse is organized by subject areas, into "data collections", tables from various collections are often joined together to provide integrated information about the University.

Technical Information
The University's Data Warehouse is an Oracle (11g) relational database management system (RDBMS). The database resides on a eight processor IBM P6 Series Symmetric Multiprocessor (SMP) server with 64 GB of memory and over 1.25 TB disk space, running under AIX 6.1

More information about the University's Data Warehouse is available in the following documents:
How the Warehouse Works
What the Warehouse Contains


Information Systems and Computing
University of Pennsylvania
Comments & Questions

Penn Computing University of Pennsylvania
Information Systems and Computing, University of Pennsylvania