Data Warehouse: BRS Tables and Data Elements


	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
	brim
	brs
	express mail
	facilities
	faculty
	general ledger
	infrastructure
	learning management
	position inventory
	research
	salary management
	student
	tuition distribution
	cross-collection

BRS Collection Tables & Data Elements

Tables are listed in alphabetical order. Select Table to obtain the explantion, common uses, primary keys, indexed data elements, and related tables for a table. Select Elements to obtain the definition, list of values, formats, and not null values for each data element in the table. A description of table and data element terminology is in the document What the Warehouse Contains.

BRS_DETAIL
Table Elements

BRS_SUBCODE
Table Elements

BRS_SUBCODE_HISTORY_V
Table Elements

Related Student tables included in the BRS Combined universe:

DEGREE_TERM_ALL_V
Table   Elements
PERSON_ALL_V
Table   Elements

Related employee data included in the BRS Combined universe:

EMPLOYEE_GENERAL
Table   Elements

Related GL reference tables included in the BRS universes
(in folders prefixed by 'Acct1' and 'Acct2'):

CENTER_REF_CODES
Table   Elements OBJECT_CODES
Table   Elements

CNAC_CODES
Table   Elements ORG_CODES
Table   Element

FUND_CODES
Table   Elements PROGRAM_CODES
Table   Elements



Information Systems and Computing University of Pennsylvania Comments & Questions