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
BRIM
Express Mail
Facilities
Faculty
GAR
General Ledger
Infrastructure
Learning Management
OIP
Position Inventory
Research-PennERA Proposals
Salary Management
Student
Tuition Distribution
Cross-Collection

General Ledger 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.

BALANCES
Table   Elements

BUDGET_PERIODS
Table   Elements

CENTER_REF_CODES
Table   Elements

CNAC_CODES
Table   Elements

FUND_BILLING_FORMAT_CODES
Table   Elements

FUND_BILLING_FREQ_CODES
Table   Elements

FUND_CODES
Table   Elements

FUND_CODES_HISTORY
Table   Elements

FUND_FINAL_RPT_CODES
Table   Elements

FUND_FREEZE
Table   Elements

FUND_FREEZE_HISTORY
Table   Elements

FUND_INVESTMENT_CODES
Table   Elements

FUND_LOC_RPTG_CODES
Table   Elements

FUND_RECLASS_CODES
Table   Elements

FUND_RPT_FORMAT_CODES
Table   Elements

FUND_RPT_FREQ_CODES
Table   Elements

FUND_SFS_CATEGORY_CODES
Table   Elements

FUND_SPONSORS*
Table   Elements
*Sponsor Code Conversion notes

FUND_STATUS
Table   Elements

GL_DETAIL
Table   Elements

GL_FULL_OLD_TO_NEW
Table   Elements

GL_PART_OLD_TO_NEW
Table   Elements

GL_REPORT_TEMPLATE
Table   Elements

GL_SUBCD_OLD_TO_NEW
Table   Elements

HYP_REVEXP
Table   Elements

ISC_BILLING_DETAIL
Table   Elements

MAINFRAME_CHGBK_SUMMARY
Table   Elements

OBJECT_CODES
Table   Elements

ORG_CODES
Table   Elements

ORG_OLD_TO_NEW
Table   Elements

PARENT_CNAC_CODES
Table   Elements

PARENT_FUND_CODES
Table   Elements

PARENT_OBJECT_CODES
Table   Elements

PARENT_ORG_CODES
Table   Elements

PARENT_PROGRAM_CODES
Table   Elements

PROGRAM_CODES
Table   Elements

PROGRAM_CODES_HISTORY
Table   Elements

PURPOSE_CODES
Table   Elements

RCM_OBJECT_TREE
Table   Elements

SUMMARY_BALANCES
Table   Elements

TELECOM_CALL_DETAIL
Table   Elements

TELECOM_INVOICE_SUMMARY
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