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

FINQUERY Template Universe Repository Reports

RCM 210

This report is intended to allow users to mimic the BEN Financials RCM 210 report using the Data Warehouse BALANCES and GL_REPORT_TEMPLATE tables. Two queries (Financial Data and RCM Labels) are linked together (on the Sequence column), to join balances with the full skeleton of the RCM report. Therefore, the file consists of three tabs - the first (Financial Data) shows only the template lines for which the query retrieves balances. The second tab (RCM Labels) shows the skeleton of the RCM template. The final tab (RCM report) shows the entire RCM template, with balances populated where available.

The Financial Data query makes use of a union, to allow users to retrieve all rows in the template - those represented by a parent object, and those represented by COA objects which do not roll directly to a K-parent. For more on the template table, refer to http://www.upenn.edu/computing/da/dw/genled/gl_report_template.t.html.

Data in this report can be verified using the BEN Financials 210 report.

Financial Data

  • Union Query 1 Result Objects:

    BALANCES: SUM Orig Budget FY Total, SUM Oper Budget FYTD, SUM Actual Month, SUM Actual FYTD, SUM Total Encumbered
    Template Parents: Par Label Name
    Template Parents: Par Sequence

  • Union Query 1 Conditions:

    BALANCES:

    
            Accounting Period = prompt : ('Enter Accounting Period')
    COA Org = prompt : ('Enter COA ORG:')
    Template Parents:
    
            Par Template Name = prompt : ('Enter template name (select from list of values):')
    Par Sequence >= 1580
    Par Fund Codes P:
    
            Parent Fund = prompt : ('Enter Fund Group:)
    
           
    
    
  • Union Query 2 Result Objects:

    BALANCES: Orig Budget FY Total, Oper Budget FYTD, Actual Month, Actual FYTD, Total Encumbered
    Template Children: Child Label Name

    Template Children: Child Sequence

  • Union Query 2 Conditions:

    BALANCES:

    
            Accounting Period = prompt : ('Enter Accounting Period')
    COA Org = prompt : ('Enter COA ORG:')
    Template Children:
    
            Child Template Name = prompt : ('Enter template name (select from list of values):')
    
            Child Sequence >= 1580
    Par Fund Codes P:
    
            Parent Fund = prompt : ('Enter Fund Group:)
    
           
    
    

RCM Labels

  • Result Objects:

    Template Children: Child Label Name
    Template Children: Child Sequence

  • Conditions:

    Template Children:

    
            Child Template Name = prompt : ('Enter template name (select from list of values):')
    Child Sequence >= 1580

To import this file for your own use:

  1. Log on to Business Objects.
  2. From the File menu, click "Retrieve From", and then "Corporate Documents" (or, if you're still using version 4, choose to retrieve from "Repository").
  3. Click on the name of the file you'd like to retrieve, and then click the Retrieve button.
  4. If you are using Business Objects version 5, you may choose whether to open the document upon retrieval.
  5. Retrieved files are saved in your UserDocs directory by default. You may wish to relocate and/or rename them.
top

Information Systems and Computing
University of Pennsylvania
Comments & Questions


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