Penn Computing
 UPDATES Current Load Status Regular Availability INFORMATION FAQs & Tips Password Changer Support services Security About the Data Warehouse Data Administration DATA COLLECTIONS Advancement Assets BBR 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 World Travel Cross-Collection

## 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?

1. COA_ORG = ORGANIZATION_CODE
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