Querying Executive Summary Information

FGIBDSR

FGIBDSR looks identical to FGIBDST, but functions in a different way. In FGIBDST, information could only be queried based on data enterable FOP (Fund Org Program) codes. If you need to query on a high-level summary code, such as an Org code for an entire school or college, you must use FGIBDSR. When you query on non-data enterable codes, you cannot view transaction detail, because that detail is linked to the data enterable code, not the summary code.

1. In the Go To... field of the Banner Menu Form, type FGIBDSR. Type <return>. The Executive Summary Form will open.

2. CHART and FISCAL YEAR fields will default. <TAB> through both fields.
    
3. <TAB> through INDEX. At UCSC, the INDEX field is only used by Central Offices for certain transactions.
    
4. Leave the THRU FISCAL PERIOD field blank to see all activity for the fiscal year, or specify a fiscal period (01-12) to see activity through that period.
    
5. <TAB> to QUERY SPECIFIC ACCOUNT checkbox. Box can be left unchecked for a relative account listing (i.e., the system will produce a list of all accounts greater than the account code entered into the ACCOUNT field), or can be checked [spacebar] to limit the query to specific account detail.
    
6. INCLUDE REVENUE ACCOUNTS. Leave checkbox blank unless your unit has income from revenue type accounts and you wish these totals to be included in the detail below.
    
7. <TAB> to COMMIT TYPE. Leave “Both” (the default).
    
8. <TAB> to ORGANIZATION. Provide your Organization code, if desired.
    
9. <TAB> to FUND. Enter Fund code for query, if desired.
    
10. <TAB> to PROGRAM. Enter Program code for query, if desired.
     
11. <TAB> to ACCOUNT. Leave blank to query all accounts. Otherwise, specify specific account code.
     
12. <TAB> to ACCOUNT TYPE. Leave blank to query all account types, or indicate account type code to limit query to a specific Level 2 account type (e.g., ‘71’ Non-Capital Expenditures). See table below for a list of Level 2 account types.
    
    
    

    Level 2 Acct Type	Acct Type Title
    71	Non-Capital Expenditures
    72	Capital Expenditures
    73	Indirect Costs (Contract & Grant O/H)
    79	CIP Expenditures
    61	Salaries & Wages
    66	Retirement & Employee Benefits
    51	Tuition & Fees
    52	State Government
    53	Local Government
    54	Federal Government
    55	Private Gifts, Grants, & Contracts
    56	Sales & Services of Educational Act
    57	Service Enterprises
    58	Other Services
    59	Sales & Services of Auxiliary Ent

    
     
13. <TAB> to ACTIVITY. Leave blank to query on all activity codes (includes transactions with or without activity codes attached), or enter specific code to limit query.
     
14. <TAB> to LOCATION. The Location Code field is only used by Plant Accounting and Physical Planning & Construction in conjunction with Plant Funds to denote the building for which the corresponding transaction is being posted. All other users should always leave this field blank.
     
15. Type [control page down] Next Block.
     
16. The form displays the budget status for the FOAPAL combination you have entered. To view additional budget lines, scroll up and down using the vertical scroll bar, [page up] and [page down] keys, or <> <> arrow keys.
     
17. If you have queried on data enterable codes, you may jump to FGITRND (see below for instructions).
    If you have queried on non-data enterable codes, (e.g. Org 2681) you cannot jump to FGITRND.
     
18. To start a new query, click the Rollback icon or type Shift-F7 or Right Click-Rollback.
     
19. To exit the form, type [control q] or click on in the toolbar or Right Click-Exit.

Jumping from FGIBDSR to FGITRND Detail Transaction Activity

While using FGIBDSR (see above), you can view detail transaction activity via FGITRND. You can view transactions which make up any amount in FGIBDSR’s Adj Budget, YTD Activity or Commitment columns

Note: When you query on non-data enterable codes, you cannot view transaction detail, because that detail is linked to the data enterable code, not the summary code.

1. In the lower block of FGIBDSR, in any of the three columns (Adj Budget, YTD Activity, Commitment), click on the amount for which you need further detail.
    
2. Go to Menu-Options-FGITRND (Transaction Detail Information) or Right Click-FGITRND.
   

3. You may scroll through the transactions using the vertical scrollbar, [page up] and [page down] keys, or <> <> arrow keys. Additional fields in each record can be accessed by using the horizontal scrollbar.
    
4. To return to FGIBDSR, type [control q] or click on in the toolbar or Right Click-Exit.