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

General Ledger Collection Data Diagrams

The General Ledger Data Collection is described in the FINQUERY, FINQUERY Template Universe, FINSUMQ, and FINQO2N diagrams. Each diagram illustrates the architiecture of a specific Business Objects universe and identifies the join criteria between tables.

The FINQUERY diagram provides access to the General Ledger balances. In most instances, you will use this diagram when querying the General Ledger Data Collection.

The FINQUERY Template Universe diagram depicts the assorted template tables, which can be used to roll up balances or mimic General Ledger reports, joined to the FINQUERY universe.

The FINSUMQ diagram provides access to summary balances.

The FINQO2N diagram helps you to translate financial query records into terms that were used before July 1 1996, when the present General Ledger accounting structure was implemented. For example, translate object codes into subject codes.

In addition, users of the General Ledger data collection are automatically authorized to view the following:

The Express Mail diagram identifies the tables that make up the Express Mail universe and their join criteria. This diagram should be printed using landscape orientation.

The ISC Billing Detail diagram provides access to ISC Networking Billing detail data.

The ISC Telecommunications Detail diagram provides access to ISC Telecommunications invoice and charge data.

The ISC Mainframe Chargeback diagram provides access to Mainframe Chargeback invoice summary data..

  Collection Information:
top

Information Systems and Computing
University of Pennsylvania
Comments & Questions


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