Data Warehouse: BRS Data Collection


	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.



Information Systems and Computing University of Pennsylvania Comments & Questions