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

This lesson should take about 50 minutes to complete. After completing this lesson, you should be able to identify the three Business Object's universes that make up the General Ledger Data Collection and identify the tables that make up the FINQUERY Universe.

Lesson 2. General Ledger Data Diagrams

Activity 1

Read the document "Data Diagrams," and then complete Activites 2, 3, and 4. (Once you've completed the reading, use your browser's back button to return to this lesson.)

Activity 2

Display the FINQUERY diagram and become familiar with the context of this diagram. (After viewing the diagram, use your browser's back button to return to this lesson). After viewing the diagram, please answer the following questions:

  1. What is the join criteria between the BALANCES table and the ORG_CODES table?
  2. What financial information does the FINQUERY universe allow you to access?
  3. What is a decode table?
  4. Name the tables that make up the FINQUERY universe.
  5. What is the join criteria between the BALANCES table and the FUND_CODES table?

Activity 3

Display the FINSUMQ diagram and become familiar with the context of this diagram. (After viewing the diagram, use your browser's back button to return to this lesson.) After viewing the diagram, please answer the following questions.

  1. What financial information does the FINSUMQ universe allow you to access?

Activity 4
Display the FINQO2N diagram and become familiar with the context of this diagram. After viewing the diagram, please answer the following questions:

  1. What is the primary purpose of the FINQO2N universe?

Activity 2 Answers

  1. COA_ORG = ORGANIZATION_CODE
  2. The FINQUERY Universe provides access to General Ledger balances.
  3. A decode table (also called a reference table) contains the description or meaning of a code.
  4. BALANCES, CNAC_CODES, ORG_CODES, FUND_CODES, OBJECT_CODES, PROGRAM_CODES, CENTER_REF_CODES, ORG_CODES_RESP.
  5. COA_FUND = FUND_CODE

Activity 3 Answers

  1. The FINSUMQ Universe allows you to access General Ledger summary balances.
Activity 4 Answers
  1. The FINQO2N Universe allows you to translate financial query records into terms that were used before the implementation of the present General Ledger accounting structure (in use at Penn since July 1, 1996).

Additional Lessons
Lesson 1. Security, Etiquette, and Ethics
Lesson 3. Table and Data Element Documentation
Lesson 4. Questions to Ask Before Writing a General Ledger Query
Lesson 5. Evaluating Query Results
Lesson 6. Getting General Ledger Help
 
top

Information Systems and Computing
University of Pennsylvania
Comments & Questions


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