RF Salary Review – Assignments with No Salary Change CSV Report

Description

Purpose

The RF Salary Review – Assignments with No Salary Change CSV Report provides campuses with a tool to monitor employee salary changes. It is specifically designed to monitor salary plan implementation.

Note: This report should be run in conjunction with the RF Salary Review CSV Report.

Frequency

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.

Setting Report Parameters

The following table describes the required and optional parameters to use to run the "RF Salary Review – Assignments with No Salary Change CSV " report:

Parameter

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

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)

Understanding the Output

To Export Data to Excel:

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 parameters selected in this report)

Reason

Salary change reason for last salary change

Helpful Tips

Effective Date: 9/4/2007 9:35:52 AM