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
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
 

 


top

Information Systems and Computing
University of Pennsylvania
Comments & Questions


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