RF Salary Sum Report and RF Salary Sum Excel Report

Description

Purpose

Oracle Grants Management (GM) maintains detailed salary and fringe benefit expenditures. The Research Foundation (RF) customized the Salary Sum to create a report of total salary and fringe benefit amounts along with fellows and participant support expenditures by employee expended over specified periods for a given award. This report is sorted by resource group level and then by employee last name. Subtotals are displayed at the resource group level between each section.

A summary of payments is provided at the end of the report to provide subtotals by resource group and a grand total for the period of all personal service costs. This report is used for account analysis and to provide detailed backup documentation to some sponsors.

Frequency

Run this report as needed.

Responsibilities with Access

Setting Report Parameters

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

Parameters

Description
(click in the field to see the List of Values)

Required Parameters

Project Number

Required on the Project Salary Sum and Project/Task Salary Sum

 

The project number for expenditures

Award Number

The award number for expenditures

Task Number

Required on the Project/Task Salary Sum

 

The task number on the project number for expenditures

Starting Period

The month and the year, formatted MON-YYYY, of the data will be reported

 

Example: JUL-2006

Ending Period

Fills automatically with the same month as the Starting Period. To report more than one month, change this date, formatted MON-YYYY, to the last month to be reported

 

Example: JUN-2007

Understanding the Output

The report displays by employee total salary and fringe benefit item detail for the month and/or months entered in the parameters box for a specific award (that is, all projects funded by the award). The output file is PDF.

The following table describes the report output:

Column Heading

Description of Column

Last Name

The last name of the employee

First Name

The first name of the employee

MI

The optional middle initial of the employee

Emp No

The employee number (that is, the unique identifying number) of the person who has been paid

Title

The job position of the employee

Term Date

The current labor schedule termination date

Employee Salary

The total salary distributed for a specific regular employee

Student Salary

The total salary distributed for a specific student employee

Fringe Benefits Salary

The total fringe benefits charged for an employee

Summary of Payments Section

Displays summary of payments made sorted by resource group and type of payment with a grand total summary of all payments made

Employee

The subtotal for all regular salary employees for a resource group

Student

The subtotal for all student salary employee for a resource group

Fringe

The subtotal for all salary employees for a resource group

Total Salary

The Grand Total salary of all employees

Total Fringe Benefits

The Grand Total fringe benefits of all employees

Total Payments

The Grand Total of salary costs charged (that is., salary, fringe, fellowships, participant support)

Helpful Tips

Effective Date: 3/29/2011 9:20:49 AM