The RF Salary Review Report provides campuses with a tool to monitor employee salary changes. It is specifically designed to monitor salary plan implementation.
This report should be run periodically to monitor salary plan implementation and ensure that all intended changes were made. It can also be run at any other time to gather data on employee salary changes that did or did not occur.
The following table describes the required and optional parameters to use to run the "RF Salary Review" report:
Parameter |
Description |
Parameters |
|
Session Date |
Date that all current data on the report is based on. Defaults to current day |
Location |
Enter campus location number |
Organization (Default: ALL) |
Enter specific campus organization if you wish to only run for that organization. If left blank, will default to ALL organizations at that campus location. (Optional) |
From Date |
Start date to check for any salary changes |
To Date |
End date to check for any salary changes |
Assignment Group |
Enter specific assignment group you wish to look at in the report. If left blank, will default to ALL assignment groups (employee graduate, employee regular, employee undergraduate) |
Assignment Status |
Enter specific assignment status you wish to look at in the report. If left blank, will default to ALL statuses (active, paid leave, unpaid leave, SUNY extra service, and unpaid grad summer) |
Proposal Reason Option1 |
Select the salary change reason that you would like included in the report from the list of values |
Proposal Reason Option2 |
Select an additional salary change reason that you would like included in the report from the list of values. (Optional) |
Proposal Reason Option3 |
Select an additional salary change reason that you would like included in the report from the list of values. (Optional) |
The "RF Salary Review Report" produces a report with 2 sections:
Section 1: Employees With Salary Change Between "Date From" & Date To" Parameters (Note: Beginning of the report output)
Column Heading |
Description of Column |
Employee Name |
Full employee name |
Employee Number |
Employee number |
Hire Date |
Date first hired from people form |
Current Asg. Status |
Assignment status as of the session date entered in the parameter |
Organization |
Specific organization as of salary change date |
Assignment Category |
Employee assignment category |
Change Date |
Change date on the salary form |
Salary |
Salary as of the change date |
Inc |
Amount salary changed from previous proposal |
Inc % |
Percent that salary changed from previous proposal |
Reason |
Salary change reason |
Grade |
Grade as of salary change date |
FTE |
Employee FTE as of the salary change date |
Assign. Group |
Assignment group as of salary change date |
Salary Basis |
Salary basis as of salary change date (annual, period or hourly) |
Job Name |
Job title on assignment form as of session date entered in the parameter |
Section 2: Employees With No Salary Change Between "Date From" & "Date To" Parameters (Note: This section is at the end of the report output)
Column Heading |
Description of Column |
Employee Name |
Full employee name |
Employee Number |
Employee number |
Hire Date |
Original hire date of employee from People form |
Grade |
Grade as of session date |
Assign Group |
Assignment group as of session date |
Salary Basis |
Salary basis as of session date (annual, period or hourly) |
Organization |
Specific organization as of session date |
Assignment Status |
Assignment status as of session date |
Job |
Job title as of session date |
Last Proposal Date |
Date of last salary change date (outside the date parameters selected in this report) |
Reason |
Salary change reason for last salary change |
For complete details on running Oracle reports, refer to the Run a Report help topic.
It may be useful to run the report for an entire year based on when the salary plan is implemented.
If the salary plan is implemented on different dates for different organizations at your location, you can run it for each specific organization with different "date from" and "date to" dates.
If you would like to manipulate the data in Excel format, run the reports titled RF Salary Review CSV Report and RF Salary Review – Assignments with No Salary Change CSV Report.