RF RFASI GMS Balance Comparison

Description

Purpose

This monitoring report displays the balance in the last RFASI that was run and compares that balance to the balance in the GMS Balances Table. The report can be limited to awards with a difference over a specified dollar value. Corporate funded awards are excluded from the output of this report (corporate funded awards include Payroll Suspense, SUNY Suspense, Other Institutional Activities, Vacation Payments, Refunds, Payroll Overpayment, and NIH Salary Cap Awards).

For more information on the GMS balance, refer to: Resolving Differences Between the GMS and RFASI Balance.

Frequency

Run this report as needed.

Responsibilities with Access

ORG Grants Inquiry
ORG Account Establishment Specialist
ORG Account Establishment Specialist with Budget Approval
ORG Account Establishment Administrator
ORG OGM Billing Specialist
KEY Key Member

Setting Report Parameters

The following table describes the optional parameters to use to run the report:


Parameter	Description (click in the field to see the List of Values)
Optional Parameters
Organization		Location code and operating location name Leave blank to run the report for your location, or enter your three-digit location code, press the Tab key, and the operating location displays. Operating locations are allowed to run reports only for their own location. Central office may use this parameter to run a report for any location.
Award Number		Click the List of Values (LOV) and either select the number of the specific award or leave blank to run the report for all awards at your location.
Project Number		Click LOV and either select the number of a specific project or leave blank to run the report for all projects at your location.
Amount Greater Than		Enter a dollar amount (for example, 500) to limit the report to display only those differences over that limit, or leave blank for all. Do not use the > (greater than) symbol or the $ (dollar) symbol, and do not use a comma. Example: 1000 rather than 1,000
Start Date		Enter the first day of a given month to display awards that will be ending in that month. Enter in the format of DD-MMM-YYYY (for example, 01-JUL-2001).
End Date		Enter the last day of a given month to display awards that will be ending in that month. Enter in the format of DD-MMM-YYYY (for example, 31-JUL-2001).

Understanding the Output

The following table describes the report output:

Column Heading	Description of Column
Award Number	The award number
Project Number	The project number
Task Number	The task number
GMS Balance	The balance in the GMS Balances Table as of the date on which the report is run
RFASI Balance	The available balance in the RFASI as of the last date on which the RFASI was run
RF GMS Balance Difference	The amount calculated as the difference between the balance in the GMS Balance Table and the balance shown in the RFASI
RFASI Last Run Date	The date and time at which the RFASI was last run or a message that shows Never Run

Helpful Tips

For complete details on running Oracle reports, refer to the Run a Report help topic.
The report is available in PDF and ASCII (TEXT) format. PDF is a formatted, printable version. ASCII can be easily pulled into a spreadsheet or word processor.
Once you select a format and run the report, you cannot change the output format. You will need to run the report again and select the desired output format on the Submit Request window.

Effective Date: 3/14/2007 8:55:36 AM