Penn Computing

Penn Computing

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

 
  UPDATES
Current Load Status
Regular Availability
 
  INFORMATION
FAQs & Tips
Password Changer
Support services
Security
About the Data Warehouse
Data Administration
 
  DATA COLLECTIONS
Advancement
Assets
BBR
BRIM
Express Mail
Facilities
Faculty
GAR
General Ledger
Infrastructure
ISSS-iOffice
Learning Management
Position Inventory
Research-PennERA Proposals
Research Inventory
Salary Management
Student
Travel Expense Management
Tuition Distribution
World Travel
Cross-Collection

Pennant Accounts 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.

STUDENT_ACCOUNT_BALANCE
Table   Elements
DETAIL_CODE
Table   Elements

STUDENT_ACCOUNT_DETAIL
Table   Elements

BANNER_DETC_TO_BRS_SUBCODE
Table   Elements
STUDENT_ACCT_GL DETAIL
Table   Elements
STUDENT_ACCT_HOLDS
Table   Elements
STUDENT_ACCOUNT_GL
Table   Elements
 
STUDENT_ACCT_DEFAULT_GL
Table   Elements
 
STUDENT_ACCOUNT_PAID_APPLIED
Table   Elements
 
   

 

 

 

 

Related Student tables included in the Pennant Accounts universe:
DEGREE_TERM_ALL_V
Table   Elements
PERSON_ALL_V
Table   Elements
DEGREE_PURSUAL_ALL_V
Table   Elements
ADDRESS
Table   Elements
ENROLLMENT_ALL_V
Table   Elements
COURSE_SECTION
Table   Elements

Related employee data included in the Pennant Accounts universe:
EMPLOYEE_GENERAL
Table   Elements

Related GL reference tables included in the Pennant Accounts universe:
(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
 

 

  Collection Information:

top

Information Systems and Computing
University of Pennsylvania
Comments & Questions


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