Penn Computing

Penn Computing

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

  
  UPDATES
Current Load Status
Regular Availability
  
  INFORMATION
FAQs & Tips
Password Changer
Support services
Security
About the Data Warehouse
Data Administration
  
  DATA COLLECTIONS
Advancement
Assets
BRIM
Express Mail
Facilities
Faculty
GAR
General Ledger
Infrastructure
ISSS-iOffice
Learning Management
Position Inventory
Research-PennERA Proposals
Salary Management
Student
Travel Expense Management
Tuition Distribution
Cross-Collection

Tuition Distribution Collection Data Diagram

The Tuition Distribution Collection is different from the majority of the Data Warehouse, in that data was loaded into a star schema. This means that there is a central "Fact" table with unique relationships to the tables surrounding the Fact. Thus, all the joins are taken care of by the system, leaving you the user to pick the values you want to see.

The Tuition Distribution collection is described in two diagrams. The first is the Business Objects universe. The second is the underlying structure of which Business Objects uses a subset of data.

The Tuition Distribution Business Objects universe provides access to the complete Tuition Distribution data. Data available includes the Course Data, Student's Primary and Secondary Instructional Programs, Home School, and Teaching School, the Instructor's Primary Appointment and Primary Academic Appointment, and the Time Period for each snapshot. Only indvidiuals with access to the Student collection will be able to use all the tables in this universe. This diagram should be printed using landscape orientation.

The Tuition Distribution Warehouse diagram provides detailed information about links and field names in the production Tuition Distribution system.

  Collection Information:
top

Information Systems and Computing
University of Pennsylvania
Comments & Questions


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