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