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 //provider.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.