Understanding the Cycle Load Process

The Compensation Cycle Load process loads awards and salary updates from the Compensation Cycle processing tables to employees’ job data. For this to happen, managers should have entered and submitted their proposals through the Allocate Compensation page in eCompensation Manager Desktop. After the compensation administrator has confirmed the accuracy of the proposals or they have been approved through the AWE process, the compensation administrator has to mark the group Ready to Load.

The Load Salary Updates and Awards process is an AE program that is run via the PeopleSoft Process Scheduler. It is launched via a standard run control component. In general, access to this component should be controlled as the new Job Data Salary change transactions that will be created need to be coordinated with benefits and payroll.

Note: The Load process sets the group node status in either the Complete or Complete with Error status. The Load Salary Updates and Awards process will only process a group node that is in the Ready to Load status once. However, as group nodes move to the Ready to Load status, you can continue to run the Load Salary Updates and Awards process for your Compensation Cycle to process those nodes.

Step

Description

Validate Run Control Parameters

The system obtains run control parameters as well as the cycle status for the designated cycle. If the cycle status is not Open, the system perform exits to abort the process.

Populate Configuration Row Sets

The system creates stand alone component level row sets to hold the variable compensation, salary, and salary action cycle configurations. For non-cash variable compensation plans, the system obtains the current valuation per unit value.

Create Direct Report Group Row Set

The system selects all direct report group rollup nodes where the group status is equal to Ready To Load. For each row, the system retrieves information from the Process Salary Increases, Process Awards and Update Group Status sections.

Process Salary Increases

For each employee salary plan row within the selected group, which is ordered by employee ID, record number, plan sequence and reason sequence, the system:

  1. Obtains the current compensation row for the compensation rate code.

  2. Annualizes the current compensation rate.

  3. Converts eCompensation increase amounts to the currency code using cycle currency conversion parameters.

  4. Adds converted eCompensation increase to the current annualized compensation rate, while obtaining the new annualized compensation rate.

  5. Converts the new annualized compensation rate to the current compensation frequency, while obtaining the new compensation rate.

  6. Inserts new Job Data rows.

  7. Makes the effective date equal to the planned effective date from the cycle definition.

  8. Makes the effective sequence equal to the current effective sequence plus 1 if the current effective date is equal to the planned effective date, otherwise it's zero.

  9. Makes the action equal to the action from the corresponding Salary Action Cycle row.

  10. Makes the reason equal to the reason from the corresponding Salary Action Cycle row.

  11. Updates the appropriate Compensation rows with the new compensation rate.

  12. Invokes the Calculate Compensation button.

  13. Saves.

Note: The system sets the row status to Error if the component interface fails for any reason. If the save is successful, the system sets the row status to Processed.

Process VC Awards

For each eCompensation Variable Compensation row within the selected group, which is ordered by employee ID, record number and variable compensation plan ID, the system updates the Variable Compensation Award table with appropriate amounts as follows:

  1. Obtains currency code from the corresponding Variable Compensation Award row.

  2. Converts the eCompensation adjusted and proposed award amounts from the eCompensation currency code to the variable compensation currency code using the cycle currency conversion parameters if the plan is monetary.

  3. Makes the variable compensation adjusted award equal to the converted eCompensation adjusted award.

  4. Makes the variable compensation actual award amount equal to the converted eCompensation proposed award, if the plan is monetary.

  5. Makes the variable compensation adjusted actual award unit equal to the eCompensation proposed award, if the plan is non-monetary.

  6. Makes the variable compensation award value equal to the eCompensation proposed award time, which corresponds to the valuation per unit value, if the plan is non-monetary.

  7. Sets the variable compensation award status to Approved if the eCompensation proposed amount is greater than 0; otherwise the system sets the status to canceled.

  8. Sets the row status to Processed.

Note: If a row is excluded, the system sets the proposal status to Bypassed and ends further processing on the row. If there is not a corresponding row in the Variable Compensation Award table for the plan, payout period, employee ID, and employee record, the system sets the proposal status to Error, logs the action, and ends further processing on the row.

Update Group Status

Sets the group status to Complete.

Terminate

Writes totals to log and closes the process.

Updating Future Dated Job Row(s) with a Salary Update

The Compensation Cycle Load process performs specific validations prior to inserting a new job data row with the approved salary update. If a future dated job row exists to that salary update being applied, then the process performs the same validations on the future dated row to determine if the salary update can be inserted into job.

If it finds that any of these conditions is not true:

  • The employee status is equal to A, L, P, or S.

  • The employee still has the compensation rate code being adjusted by the cycle.

  • The employee has the same currency code that was used during the cycle.

  • The employee has the same annual salary that was adjusted during the cycle.

It sets the proposal status to Load Error and writes the error in the log for the salary update. The compensation administrator, after reviewing the error information, can take the appropriate action based on company policy to manually apply the salary update to the employee’s job data.