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

PennERA Proposals Collection Data Diagrams

The PennERA Proposals collection is described in the PennERA Proposals and PennERA Proposals Snapshots diagrams. Each diagram illustrates the architecture of a specific Business Objects Universe, displaying the tables that are included and the join criteria between tables. A table or Business Objects Class is shown in the diagram as a box; a join is shown as a line between the boxes for the joined tables. Click on the box for a table to see the data documentation for that table.

The PennERA Proposals diagram illustrates the architecture of the Business Objects Universe that is usually used to access the PennERA Proposals data collection, because it accesses the data that is refreshed nightly. Reference tables from the Salary Management data collection are included, to provide further information on PennERA people who are also University employees. Also included are reference tables from the General Ledger and Space@Penn data collections, to supply org. and school/center names, and to provide further information on the segments of the increment's award GL account and on the proposal's prime fund. See Notes on the PennERA Proposals diagram for an explanation of the blue labels next to the boxes and for other information about the diagram. If you choose to print the diagram, landscape orientation and letter-sized paper (8.5 by 11 inches) are recommended. Note: there is one PennERA Proposals table that is refreshed nightly, but is not included in the PennERA Proposals Universe: PENNERA_FUND_ADJ. It is available in the PennERA Balances Universe, which is a cross-collection Universe.

The PennERA Proposals Snapshots diagram illustrates the architecture of the Business Objects Universe that is designed to support longitudinal studies, because it accesses the annual snapshots of the PennERA Proposals data collection. This Universe also accesses Balances and GL Periods (in the General Ledger data collection), the annual snapshots of many of the reference tables for Balances, and the relevant monthly snapshots of Employee General and Job Class General (from the Salary Management data collection). The tables from the General Ledger and Salary Management data collections are shown in the diagram as boxes with grey backgrounds. See Notes on the PennERA Proposals Snapshots diagram for an explanation of the asterisks and for more information about the diagram. If you choose to print the diagram, specify landscape orientation, and legal-sized paper (8.5 by 14 inches).

  Collection Information:
top

Information Systems and Computing
University of Pennsylvania
Comments & Questions


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