Notes on the PennERA Proposals Diagram
If the diagram is
printed, landscape orientation and letter-sized paper (8.5 by 11
inches) are recommended.
The PennERA Proposals Universe combines tables from the PennERA
Proposals data collection with reference tables from the Salary
Management, General
Ledger, Space@Penn, and Human Subjects Protocols data
collections. 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, green for General Ledger tables, and pink for Human Subjects Protocols tables. While viewing the diagram,
click on the box for a table to see the documentation for that 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 also includes 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.
|