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

Notes to FINQUERY Diagram

· FINQUERY diagram  · data diagrams
  • The diagram identifies those tables that make up the FINQUERY 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
top

Information Systems and Computing
University of Pennsylvania
Comments & Questions


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