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

Tuition Distribution Collection Refresh Schedule

Tuition Distribution tables are loaded five times per term, for each of the three terms. The load schedule is set by Student Financial Services, using the month end date of the BRS system. This ensures that the tuition data in the collection will tie to the BEN deferred income amount.

The basic schedule is as follows:

Spring: Five (5) loads, once a month, from January to May
Summer: Five (5) loads, once a month, from May to September
Fall: Five (5) loads, once a month, from September to January

These loads are identified in the Collection as Extract Date.

Source of the Data
The sources of the data in the Tuition Distribution tables are primarily snapshots of data from the Student and BRS_DETAIL tables from the Data Warehouse. Data are collected on the enrollment and Primary Instructional Programs (Division, Degree, Major, Special Program) of the students registered, as well as the total amount of tuition billed and paid by those Instructional Programs. From those data, calculations are performed to determine an amount per course unit which then determines tuition distribution.

Time Span Covered
The Tuition Distribution data collection was loaded on January 26, 2006 for Fall 2004, Spring 2005, Summer 2005, and Fall 2005. The data in the collection for those terms are valid as of that load date, (i.e., they will not match the census reports precisely). Spring 2006 was considered test data using production feeds. Summer 2006 and Fall 2006 are production loads.

  Collection Information:

Information Systems and Computing
University of Pennsylvania
Comments & Questions

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