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
ISSS-iOffice
Learning Management
Position Inventory
Research-PennERA Proposals
Salary Management
Student
Travel Expense Management
Tuition Distribution
Cross-Collection

Notes on the PennERA Balances Diagram

If the diagram is printed, landscape orientation and legal-sized paper (8.5 by 14 inches) are recommended.

The PennERA Balances Universe combines tables from three data collections: PennERA Proposals, Salary Management, and General Ledger. The diagram illustrates the architecture of the Universe, displaying the tables that are included and the joins between the tables.

A table or view is shown in the diagram as a black-bordered box. The background color of the box indicates the source data collection. White is used for the PennERA Proposals tables, grey for Salary Management tables, and green for General Ledger tables. Click on the box for a table to see the documentation for that table. (Note: Users who are authorized to use the PennERA Proposals data collection have access to every table in this Universe except for BALANCES. Users must be authorized to use the General Ledger data collection in order to access the BALANCES table.)

A join is shown as a line between the boxes for the joined tables. Labels next to the lines indicate the join criteria.

In the Universe, a Business Objects Class folder roughly corresponds to a table. However, some folders include Objects from reference tables that are joined to the Class's table, but are not necessarily shown in the diagram. (If the Class's table includes a coded data element, the Class usually retrieves just the corresponding name or description from the relevant reference table, rather than including all of that reference table's data elements. For example, a Class that includes the proposal responsible org. code may also include the description for that org., retrieved from the ORG_CODES table.) While viewing the diagram, click on the blue label next to a box to see the list of the reference tables and data elements included in that Class, with links to the data documentation. Note: if the diagram shows the Class's table joined to another table, and that other table is also used as a reference table within the Class, that other table does not appear in the list of the reference tables and data elements included in that Class.

(LABEL)
Class
Schema.ReferenceTableName.ReferencedDataElement
(ACT)
Pennera Proposal Activity
DWADMIN.PENNERA_PEOPLE.NAME
(BAL)
Balances
DWADMIN.FUND_CODES (all of its data elements are in the Balances folder)
DWADMIN.OBJECT_CODES (all of its data elements are in the Balances folder)
DWADMIN.RCM_OBJECT_TREE (all of its data elements are in the Balances folder)
(EG)
Employee General
DWADMIN.ORG_CODES.CENTER_NAME
DWADMIN.ORG_CODES.DESCRIPTION
(FUND INCR)
Fund Codes INCR
DWADMIN.CNAC_CODES.CENTER_NAME
DWADMIN.FUND_BILLING_FORMAT_CODES.BILLING_FORMAT_DESC
DWADMIN.FUND_BILLING_FREQ_CODES.BILLING_FREQ_DESC
DWADMIN.FUND_FINAL_RPT_CODES.DAYS_TO_SUBMIT_FINAL_RPT_DESC
DWADMIN.FUND_INVESTMENT_CODES.INVESTMENT_REV_TREATMENT_DESC
DWADMIN.FUND_LOC_RPTG_CODES.LOC_REPORTING_DESC
DWADMIN.FUND_RECLASS_CODES.RESTRICT_RECLASS_DESC
DWADMIN.FUND_RPT_FORMAT_CODES.REPORT_FORMAT_DESC
DWADMIN.FUND_RPT_FREQ_CODES.REQUIRED_FIN_RPT_FREQ_DESC
DWADMIN.FUND_SFS_CATEGORY_CODES.SFS_CATEGORY_DESC
DWADMIN.FUND_SPONSORS.FUND_SPONSOR_DESC
DWADMIN.FUND_SPONSORS.LEGACY_FUND_SPONSOR_CODE
DWADMIN.ORG_CODES.DESCRIPTION
DWADMIN.ORG_CODES.LEDGER_ALIAS_CODE
DWADMIN.PARENT_ORG_CODES.PARENT_ORG
DWADMIN.PARENT_ORG_CODES.PARENT_ORG_DESC
DWADMIN.PURPOSE_CODES.PURPOSE_DESC
(FUND PRIME)
Fund Codes Current Prime Fund
(INCR)
Pennera Increment
(INV)
Pennera Proposal Investigator
DWADMIN.ORG_CODES.CENTER_NAME
DWADMIN.ORG_CODES.DESCRIPTION
(PER)
Pennera Period
(PPL)
Pennera People
DWADMIN.ORG_CODES.CENTER_NAME
DWADMIN.ORG_CODES.DESCRIPTION
(PROP)
Pennera Proposal
(REQ)
Pennera Request

 

top

Information Systems and Computing
University of Pennsylvania
Comments & Questions


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