Penn Computing

Penn Computing

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

  Query the warehouse
What you need
Access request forms
Password change
Query tool software
Training options
Tips
  
  Related information
About the warehouse
Data Administration
Security
Support services
Warehouse updates
  
  Data collections
advancement
assets
brs
faculty
general ledger
position inventory
research
salary management
space@penn
student
tuition distribution
cross-collection

BRS Collection Refresh Schedule

The BRS_DETAIL table is refreshed on a daily basis, Monday through Friday, following SRS and BRS source system processing. The BRS_SUBCODE, BRS_COURSE_FEE and BRS_FEE_RATE lookup tables are refreshed on an ad hoc basis, usually after SRFS has changed the source tables.

Source of the Data
The sources of the data in the BRS_DETAIL table are the Bursar_Detail, Intermediate and History files, which contain data from the online Billing and Receivables System (BRS). Together, these files represent all the data on a student account. The BRS_SUBCODE, BRS_COURSE_FEE and BRS_FEE_RATE tables contain only the most current versions of the subcode, course fee and tuition rate lookup data.

Time Span Covered
The BRS data collection stores from fiscal year 2005 and on. The data loads began in mid-Summer of 2004. Select records from years previous to fiscal 2005 are also available, in cases where older charges were not yet fully paid and applied.

top

Information Systems and Computing
University of Pennsylvania
Comments & Questions


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