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