|
|
Notes to FINSUMQ Diagram
- The diagram identifies the tables that make up the FINSUMQ universe
and the join criteria for the tables.
- Note that for each set of parent codes (for example, organization
parents), there is only one physical table (for example, PARENT_ORG_CODES).
In Business Objects, the Universes have been designed with more than
one Class for each parent table, to facilitate reporting on parents
and grandparents at the same time. The Business Objects Class names
for the parent Classes end in P; those for the grandparent Classes end
in GP. .
- Asterisks indicate those tables that are linked to decode tables by
outter joins.
* ORG_CODES table is linked to the PURPOSE_CODES table.
** FUND_CODES table is linked to:
FUND_BILLING_FORMAT_CODES
FUND_BILLING_FREQ_CODES
FUND_FINAL_RPT_CODES
FUND_INVESTMENT_CODES
FUND_LOC_RPTG_CODES
FUND_RECLASS_CODES
FUND_RPT_FORMAT_CODES
FUND_RPT_FREQ_CODES
FUND_SPONSORS
|
|
|
|
