UPDATE EMPLOYEES FOR COMPENSATION PLAN CHANGES

Use this screen to update an employee's Salary Info and History table after you have made changes to the Compensation Plan Salary Ranges table. After changing the effective dates and salary ranges in the Compensation Plan Salary Ranges table, you can use this application to print a report showing all employees that are affected by the changes and then update the affected employee's record in the Salary Info and History table. However, the application will generate a new line in the Salary Info and History table only when the employee falls within the minimum section of the Compensation Plan Salary Ranges table and only when the effect is an increase in salary. You must update employees in the other sections of the Compensation Plan Salary Ranges table manually in the Salary Info and History screen.

Run this screen whenever there is a change to your Compensation Plan Salary Ranges table.

Primary Sort

Use the options in this group box to select the order in which you want the report to print.

Employee Name

 Select this radio button to sort the report by employee name.

Employee ID

Select this radio button to sort the report by employee ID.

Labor Group

Select this radio button to sort the report by the labor group that is assigned to the employee in the Salary Info and History screen. If your primary sort is by labor group, you must then select either Employee Name or Employee ID for your secondary sort.

Home Organization

Select this radio button to sort the report by the home organization that is assigned to the employee in the Salary Info and History screen. If your primary sort is by home organization, you must then select either Employee Name or Employee ID for your secondary sort. The report prints all levels of the home organization.

Next Review Date

Select this radio button to sort the report by the next review date that is assigned to the employee in the Salary Info and History screen. If your primary sort is by next review date, you must then select either Employee Name or Employee ID for your secondary sort.

Secondary Sort

The radio buttons in this group box are activated depending on your selection from the Primary Sort group box. If you print this report by Labor Group, Home Organization, or Next Review Date, the Employee Name or Employee ID radio buttons will be available for selection. If you select Employee Name or Employee ID in the Primary Sort group box, the None radio button will automatically default for this group box and cannot be changed.

Employee Name

Select this radio button to print the report by employee name for employees within a labor group, home organization, or next review date category. If you select Employee Name or Employee ID for your primary sort, this radio button is disabled.

Employee ID

Select this radio button to print the report by employee ID for employees within a labor group, home organization, or next review date category. If you select Employee Name or Employee ID for your primary sort, this radio button is disabled.

None

This radio button is disabled if the primary sort you selected is by Labor Group, Home Organization, or Next Review Date. If you selected one of these radio buttons, you must select either Employee Name or Employee ID for your secondary sort. If you selected Employee Name or Employee ID for your primary sort, this radio button is the only choice available.

Report Status

This non-editable field indicates whether or not the report has been printed in this session, and whether you can proceed to update employees for compensation plan changes. If you change any of the previously selected criteria after printing the report, the field will be set to "Report Not Printed," and you will have to print the report again before you can update employees for compensation plan changes.

Select Compensation Plan

Use the fields in this group box to select the compensation plan to which this update applies.

Compensation Plan

Use this drop-down box to select the compensation plan to which this update applies.

Description

This field displays the description for the compensation plan you have chosen and cannot be edited.

Effective Date

Enter the effective date of the Compensation Plan Salary Ranges table for which these changes apply. This date will be the effective date used for the new line that will be added to the Salary Info and History table when you perform the update.

Process

Select this button on the toolbar to update the employee's Salary Info and History table as indicated on your report. You update as close as possible to the effective date of the changes for affected employees falling within the minimum section of the salary ranges.

Process/Print

Select this button on the toolbar to print the report and update the Employee's Salary Info and History table in one process.

Hint: You CANNOT use the Update Employees for Compensation Plan Changes process to update the employee's Salary Info and History table when the salary ranges of an existing compensation plan have been recalculated but the plan's effective dates have not changed.

Table Information

Changes to this screen update the following fields:

Update Employees for Compensation Plan Changes - PARMS_HSCOMP

Compensation Plan Salary Ranges - COMP_PLAN_LN

Compensation Plan Setup - COMP_PLAN_SETUP

Basic Employee Info - EMPL

Salary Info and History - EMPL_LAB_INFO

Employee Taxes - EMPL_TAX

Labor Settings - LAB_SETTINGS

Pay Periods - PAY_PD

Timesheet Periods - TS_PD

Report Columns

Column Heading

Screen

Table Name

Employee ID

Basic Employee Info

EMPL

 

Salary Info and History

EMPL_LAB_INFO

Employee Name

Basic Employee Info

EMPL

 

Salary Info and History

EMPL_LAB_INFO

Current Effective Dt/ Next Rvw Dt

Salary Info and History/ Basic Employee Info

EMPL_LAB_INFO/ EMPL

Home Organization/ Labor Group

Salary Info and History

EMPL_LAB_INFO

Grade

Salary Info and History

EMPL_LAB_INFO

Current Annl Amt/ New Annl Amt

Salary Info and History/ Compensation Plan Salary Ranges

EMPL_LAB_INFO/  COMP_PLAN_HDR,   COMP_PLAN_LN

Annual Difference

Salary Info and History/ Compensation Plan Salary Ranges

** New Annl Amt -  Current Annl Amt **

EMPL_LAB_INFO/  COMP_PLAN_HDR,   COMP_PLAN_LN

**New Annl Amt - Current Annl Amt **

Salary Difference

Derived - Annual Difference / pay periods

No particular tables

Eligible to Update

If there is a positive Salary Difference, the employee will be eligible to update.

No particular tables