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.

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