This section provides an overview of wage progression and discusses how to:
Set up wage progression run IDs.
Extract information from PeopleSoft Payroll for North America.
Maintain worker wage progression information.
Approve and process wage advancement.
When you assign a worker to a labor agreement and bargaining unit on the Job Data - Job Labor page (JOB_LABOR) and a salary plan with wage progression rules on the Job Data - Salary Plan page (JOB_DATA_SALPLAN), you can manage their wage plan's step progression using the wage progression processes.
Wage progression is the step-by-step advancement of a worker's compensation rate from a beginning rate to one of full parity. The progression is based on a wage progression rule associated with the worker's salary plan. The rule includes step progression requirements and a rate calculation formula.
The Update Wage Progression processes gather the data required to make a decision about the worker's eligibility to advance and stores that information in the Review Wage Progression component (HR_WP_MAINT_ACTVTY). Once all of the necessary data is accumulated , the system can flag qualified workers for advancement. The system inserts a new Job Data row for the qualified workers with their new step and related wage rate. The system processes the new compensation rate in the next payroll.
If, during the calculation of a worker's new rate, they reach or exceed the maximum rate for the salary grade, the system considers them at parity for their job wage rate. In these circumstances, the system increments the worker to the next highest step for the grade and no longer includes them in the wage progression processes.
See Using Wage Progression with Administer Compensation.
To insure timely reflection of the increased pay rate in a worker's paycheck, evaluate workers on wage progression for step increases prior to each payroll.
To manage wage progression:
Set up wage progression run IDs on the Wage Progression Run ID page (HR_WP_ID_DEFN).
Wage progression run IDs determine the population of workers considered for processing. The run ID is the key value in progression processes.
To process wage progression rules based on time worked , you must import time data into the wage progression staging table.
Use the Extract Payroll Data process (HR_EXTRT_NAP) to extract the last pay period's confirmed time data from Payroll for North America. Write additional processes to extract data from other time sources. The Update Wage Progression - Update Activity with Time Data process retrieves the time data from this table.
Run the Update Wage Progression processes from the Update Wage Progression page (RUN_UPD_WP_ACTVTY).
To be included in wage progression processing, a worker must have the following:
A labor agreement.
A bargaining unit.
The Stop Wage Progression check box on the Job Data - Job Labor and Review Wage Progression page is not checked.
Use the Approve Employees to Advance page (HR_WP_ADVANCE) to approve workers for wage progression if approval is required by the salary plan's wage progression rule.
See Approving and Processing Wage Advancements.
Note. To set up a salary plan requiring advancement approval,
select the Advancement Approval Required check
box on the Salary Plan Table - Define Wage Progression Rule page (SALARY_PLAN_TABLE2).
The system will automatically approve workers for advancement if their
job and time data meets the advancement criteria and if their plan's wage
progression does not require approval for advancement.
Process workers approved for advancement using the Advance Employees to next Step process (HR_WP_ADV) from the Process Wage Progression page (RUN_UPD_WP_ADVC).
At any point in the process, you can review or modify a worker's wage progression activity details on the Review Wage Progression page (HR_WP_MAINT_HIST).
See Reviewing and Manually Adjusting Wage Progression Details.
To set up wage progression run IDs use the Wage Progression Run ID component (HR_WP_ID_DEFN).
This section provides an overview of wage progression run IDs and describes how to set up wage progression run IDs.
Wage progression run IDs enable you to create discrete populations of workers and manage their wage progression consistently throughout the process. The run ID is a key on the process run control pages and the Approve Employees to Advance page.
Determine the best way to define your population (for example, by salary plan), and then use that method for all your wage progression run IDs.
Note. Be sure to configure run ID populations in such a way that you will be including a worker's Job Data record in only one population.
Page Name |
Definition Name |
Navigation |
Usage |
HR_WP_ID_DEFN |
Workforce Administration, Labor Administration, Wage Progression, Wage Progression Run ID, Wage Progression Run ID |
Define groups of workers to manage throughout the wage progression process. |
Access the Wage Progression Run ID page (Workforce Administration, Labor Administration, Wage Progression, Wage Progression Run ID, Wage Progression Run ID).
Wage Progression Population Basis
Choose the method by which to determine the population for the wage progression run ID:
Labor Agreement
Salary Plan
Group ID
Wage Progression by Bargaining Unit
When you select Labor Agreement as your run ID population basis, enter one or more labor agreements in the grid and the workers associated with the selected labor agreements will make up the run ID population.
Wage Progression by Salary Plan
When you select Salary Plan as your run ID population basis, enter one or more salary plans in the grid and the workers associated with the selected plans will make up the run ID population.
Wage Progression by Group ID
When you select Group ID as your run ID population basis, enter one group ID and the workers associated with the selected group ID will make up the run ID population.
See Setting Up and Working with Group Definitions.
To obtain time-worked information from PeopleSoft Payroll for North America, use the Extract Payroll Data component (HR_WP_NA_PY_EXTRCT).
This section provides an overview of the Extract Payroll Data process and discusses how to extract information from Payroll for North America.
If you are using Payroll for North America to process your workers' payroll and if you have workers in a salary plan with wage progression rules that use special accumulators for hours worked or leave hour limits, use the Extract NA Payroll Data process (HR_EXTRT_NAP) to extract time data of your workers.
Run the process once per pay cycle. The Extract NA Payroll Data process:
For the selected company, extracts all the previous payroll's confirmed time data specified in the wage progression rule's accumulator ID and places it in an HR staging tables HR_PAY_STG and HR_PAY_STG_ERNS.
Sets the HR_WP_PROCESS_FLG on the PAY_CHECK record to indicate that the time data has been processed and to prevent the system from gathering the same data multiple times.
The Update Wage Progression - Payroll Update process retrieves the time data from the staging table and updates the Review Wage Progression page with the information to enable you to manage wage progression and process workers for advancement. After you run the Update Wage Progression process you can review the detailed time data using the Review Time Details page.
See Understanding the Extract Payroll Data Process.
See Understanding the Update Wage Progression Process.
See PeopleSoft Payroll for North America 9.1 PeopleBook.
Extracting Off-Cycle Runs
The Extract Payroll Data process will not extract off-cycle payrolls for a Pay Run ID until an on-cycle payroll has been run first for the same Pay Run ID.
If the year-ending month is opened up for an off-cycle payroll after the next period on-cycle payroll has already been run, make sure to accommodate the payroll time entries in wage progression while the off-cycle payroll is open. The extraction process will not recognize the additional entries for the Pay Run ID once the off-cycle payroll has been closed again.
Page Name |
Definition Name |
Navigation |
Usage |
HR_WP_NA_PY_EXTRCT |
Workforce Administration, Labor Administration, Wage Progression, Extract Payroll Data, Extract Payroll Data |
Run the Extract Payroll Data process. Select the company whose payroll data you want to extract. |
To maintain worker wage progression information use the Update Wage Progression component (RUN_UPD_WP_ACTVTY) and Review Wage Progression component (HR_WP_MAINT_ACTVTY).
This section provides an overview of the Update Wage Progression process and discusses how to:
Update wage progression details systematically.
Review and manually adjust wage progression details.
Review time details.
View and acknowledge exception conditions.
The Update Wage Progression process is made up of three processes that gather the job and payroll time information related to wage progression for workers included in the Wage Progression Run ID, and determine when a worker is qualified to advance based on their wage progression rule. Each process updates the Review Wage Progression page.
The three processes are:
The Update Activity with Job Data process (HR_WP_UPD_JC).
Run to update workers' wage progression records with relevant updates from their job data records.
The Update Activity with Time Data process (HR_WP_UPD_PY0).
Run to update workers' wage progression records with time worked information extracted from the payroll system.
The Qualify Employees process (HR_WP_UPD_QL).
Run to evaluate and qualify if workers are ready for advancement.
Note. You must run these processes in sequence.
Update Activity with Job Data Process
If a worker is assigned to a bargaining unit, labor agreement, and salary plan that includes a wage progression rule, the Update Activity with Job Data process:
Detects changes to the following fields on the current Job Data record:
Bargaining unit.
Labor agreement.
SETID_JOBCODE, if the change is the result of a change in the worker's business unit.
JOBCODE, if the new value is manually entered.
SETID_SALARY, if the change is the result of a change in the worker's business unit.
SAL_ADMIN_PLAN, if the new value is manually entered or changed as a result of a system rule.
GRADE, if the new value is manually entered or changed as a result of a system rule.
STEP, if the new value is manually entered.
STEP_ENTRY_DT , if the value is updated
WPP_STOP_FLAG, if the new value is manually entered.
Note. The system processes the Job Data record that is current on the process' As of Date.
When a Job Code change occurs, checks and applies the carryover rules selected for the worker's labor agreement on the Labor Agreement page (HR_LABOR_AGR_DEFN1).
Inserts a new row into the Review Wage Progression page with the updated information.
The system identifies this row by populating the Type field with the value of Job Change.
Updates the Last Process Dates date and time stamps.
Note. After the process initially records a selected Stop Wage Progression check box for a worker, it will no longer gather job data for workers who have the Stop Wage Progression check box selected on the Job Labor page or Review Wage Progression - Activity tab.
Update Activity with Time Data Process
Run this process when the wage progression rule is based on hours worked or when an elapsed-time wage progression rule has leave limits in effect. The process processes all staged time data, processed by the Extract Time Data process, for workers active in wage progression. The staging tables (HR_PAY_STG and HR_PAY_STG_ERNS) must first be populated with data extracted from Payroll for North America or another external subsystem.
If the process detects previously extracted and staged time data, it:
Inserts a new row into the Review Wage Progression page with the updated information.
The system identifies this row by populating the Type field with the value of Payroll Update.
Inserts a new row into the Review Time Detail page.
Deletes the row from the staging table after processing.
Updates the Last Process Dates date and time stamps.
Note. The process will not gather time data for workers who have the Stop Wage Progression check box selected on the Job Labor page or Review Wage Progression - Activity tab but it will deleted the row in the staging table so that the time will not be processed once you deselect the Stop Wage Progression check box for the worker.
Note. You do not need to enter an As of Date to run this process as all rows in the staging tables will be processed. The system will create a separate Review Wage Progression entry for each pay period.
See Extracting Information from PeopleSoft Payroll for North America.
The Qualify Employees process determines if a worker is ready for step advancement. The process should be the last update run prior to Process Wage Progression which will perform the actual wage advancement.
The process qualifies workers under an elapsed-time wage progression rule by looking at the adjusted step entry date in the most recent job change or manual row in the Review Wage Progression page comparing it to the as of date entered on the run control page.
The process qualifies workers under hours-worked rules by looking at the first payroll update row in the Review Wage Progression page with hours that qualify. Whenever there is a manual row with the same date as a job change or payroll update row, the process gives the manual row's data precedence. The process:
Calculates and populates the Estimated Advancement Date value.
This calculation is based on the wage progression rule's advancement parameters, the worker's adjusted step entry date, as of date, hours worked, on the Review Wage Progression page and, for hours worked rules, the standard hours on the Job Data - Job Information page.
The process will set the worker's wage progression status depending on the type of wage progression rule:
For hours-worked wage progression rules, the process determines if the worker has accumulated enough hours since the step's original entry date.
If the Accumulated Hours Worked is greater than the step's Required Hours and the wage progression rule does not indicate that approval is required, the system sets the worker's status to Approved; or if Approval is required, Qualified-Approval Required or Almost Qualified, if the wage progression approval rule allows for an hours within tolerance.
For elapsed-time rules, the process determines if the calendar time between the worker's adjusted step entry date and the process As of Date exceeds the time required in the salary step.
If the time has been met and the wage progression rule does not indicate that approval is required, the system sets the worker's status to Approved. If the rule does require approval, the system sets the status to Qualified - Approval Required. If the wage progression approval rule allows for an hours within tolerance, the system may set the status to Almost Qualified.
In all other circumstances, the process sets the status to Not Qualified.
Updates the qualifying row on the Review Wage Progression page with the Status field accordingly.
Updates the Last Process Dates date and time stamps.
All Update Wage Progression processes identify circumstances that fall outside the basic wage progression definition and flags the workers' Review Wage Progression records with an exception condition. The system will not process for advancement workers with a row in an exception state but all other wage progression processes will continue.
During any of the Update Wage Progression processes, the system will mark a worker for exception when it encounters an exception condition. The system inserts a red alert icon (!) on the worker's Review Wage Progression page. Additionally, you can generate a list of workers with exceptions using the Wage Progression Exception report. The table below lists the various exceptions, what triggered the exception, and the action you might take before acknowledging the exception.
Exception Condition |
What it Means |
Action Required |
Job Data Correction |
A user has made a correction to a Job Data row, effecting job data that impacts wage progression. |
Review the worker's Job Data record and make modifications to the job data record or the worker's wage progression record, if necessary. |
Manual Step Advance |
A user has manually changed a worker's grade step level on the Job Data - Salary Plan page. |
Review the change for accuracy. |
Exceeded Leave Hours |
The worker's leave hours have exceeded the leave limit prior to meeting the elapsed time required for step advancement. |
Review the worker's wage progression record and modify the Orig Step Entry Date value if appropriate. |
Exceeded Time Limit |
The worker has worked the required number of hours in the required calendar period. |
Review the worker's wage progression record and modify the Orig Step Entry Date or Hours Worked value if appropriate. |
Approved but Stop Wage Progression |
A user has selected one of the Stop Wage Progression check boxes of a worker who was approved for advancement. |
Review the worker's Job Data record and wage progression record and make modifications to the job data record or the worker's wage progression record, if necessary. |
Released Stop Wage Progression |
A user has cleared one of the Stop Wage Progression check boxes. |
Review the worker's Job Data record and wage progression record and make modifications to the job data record or the worker's wage progression record, if necessary. |
Two Earnings Periods |
The Update Activity with Time Data process includes time from two or more earnings periods. |
Review the worker's Job Data record and wage progression record and make modifications to the job data record or the worker's wage progression record, if necessary. |
Special Accumulator ID Changed |
A user has changed the wage progression rule's accumulator ID on the Salary Plan Table – Define Wage Progression Rule page. |
Review the worker's wage progression record and modify if appropriate. |
New Time < Old Time |
The Update Activity with Time Data process has caused the worker's new Hours Worked total to be less than the previous Hours Worked value. |
Review the worker's wage progression record and modify if appropriate. |
Page Name |
Definition Name |
Navigation |
Usage |
RUN_UPD_WP_ACTVTY |
Workforce Administration, Labor Administration, Wage Progression, Update Wage Progression, Update Wage Progression |
To update a worker's wage progression activity record, run the following wage progression processes in sequence:
|
|
HR_WP_MAINT_HIST |
Workforce Administration, Labor Administration, Wage Progression, Review Wage Progression, Review Wage Progression |
Review a worker's wage progression activity rows and add new rows to make manual adjustments to the activity record. |
|
HR_WP_EARN_INQUIRY |
|
Review earning period details per pay period about a worker's leave and worked hours. |
|
HR_WP_MSG_SEC |
Workforce Administration, Labor Administration, Wage Progression, Review Wage Progression, Review Wage Progression Click the Exception Detail button on the Review Wage Progression - Exception tab of the Review Wage Progression page. |
Review system messages about why a worker was excepted from advancement. Acknowledge exception to resume wage advancement eligibility. |
|
RUN_WP002 |
Workforce Administration, Labor Administration, Wage Progression, Wage Progression Exception Rpt, Wage Progression Exception Rpt |
Run the exceptions report (WP002). It lists all employees within a Wage Progression Run ID group that have unacknowledged exceptions and indicates the exception type. |
Access the Update Wage Progression page (Workforce Administration, Labor Administration, Wage Progression, Update Wage Progression, Update Wage Progression).
You must run the three update process one at a time, in this order:
Update Activity with Job Data process (HR_WP_UPD_JC)
Update Activity with Time Data process (HR_WP_UPD_PY0)
Qualify Employees process (HR_WP_UPD_QL)
Wage Progression Run ID |
Select the run ID representing the information group on which you want to collect activity data. |
As of Date |
Select the date as of which you want to incorporate changes to the Job Data pages or qualify an Elapsed Rule based worker for advancement. |
Last Process Dates |
There are five wage progression programs. This group box lists the last time each of the processes were run and which process was run most recently. |
Access the Review Wage Progression page (Workforce Administration, Labor Administration, Wage Progression, Review Wage Progression, Review Wage Progression).
Static Columns
These columns appear on each tab.
! |
For workers with unacknowledged exceptions, the system marks the rows with a red alert icon. |
Notes |
Click to access the Notepad feature to enter or review notes about a row of wage progression activity. You should add a note of explanation for all manual adjustments. |
Activity Date |
The date the wage progression activity took place. The activity date for rows with a type of:
|
Type |
The system populates this field with one of the following values to indicate what type of update has been made to the worker's wage progression history:
|
Progression Type |
Displays the progression rule's increment type, either Elapsed Time Based on Reported Time Based. |
Status |
The Qualification subprocess from the Update Wage Progression process page or an individual manual row entry may trigger a status change if the data supports it. When there is a manual row on the same date as another type of row, the system gives the manual row precedence. The system will evaluate this row for proper status and adjust the other rows accordingly. The system updates the Status field with the following values:
|
Activity
Approved By |
|
Stop WP (stop wage progression) |
Select this check box here or on the Job Labor page to suspend a worker's participation in the wage progression process. When you select this check box here the system inserts a new Job Data row and selects the Stop Wage Progression check box on the Job Data - Job Labor page. When you select the Stop Wage Progression on the Job Labor page, the system updates the wage progression activity when you next run the Update Activity with Job Data process. When you select the check box, the system:
The system also selects this check box when a worker completes the wage progression. |
Estimated Advance |
Displays the system-calculated estimated date the worker will be eligible to advance based on the wage progression rule of their salary plan. For rules based on hours worked, the system bases this calculation on the standard hours on the worker's Job Data record. The date will always be the first day of the next pay period after the worker qualifies. This is only an estimate since various other factors could impact the actual advancement date. |
Date Posted |
Displays the system date the row was generated or created. |
Elapsed Time
These fields are applicable for elapsed time-based wage progression rules only.
Orig Step Entry Date (original step entry date) |
Displays the date the worker originally entered their current salary step. The system draws this value from the Step Entry Date field on the Job Data - Salary Plan page. |
Adj Step Entry Date (adjusted step entry date) |
Manually adjust the step entry date here to maintain wage progression accuracy. |
Leave Limit |
(Optional) Displays the maximum number of leave hours a worker can accumulate while in the step, as defined in the salary plan's progression rule. |
Leave Hours |
(Optional) Displays the leave hours the worker has accumulated since the original step entry date. The Update Activity with Time Data process updates this value. |
Time Detail |
(Optional) Click to view the Review Time Details page. |
Reported Time
These fields are applicable for hours-based wage progression rules only.
Required Hours |
Displays the number of hours the worker needs to accumulate to advance to the next grade step defined in the salary plan's progression rule. |
Hours Worked |
Displays the qualifying hours the worker has worked since the original step entry date. The Update Activity with Time Data process updates this value and also adds in any adjusted hours from a previous manual row. |
Adj Hours (adjusted hours) |
Manually enter hours here to establish a new total for hours worked. Adjust the hours as necessary to maintain wage progression accuracy. The next Update Wage Progression with Time Data will incorporate manual adjustments. The system uses this adjusted value to qualify if the worker is ready to progress to the next step by comparing it to the Required Hours. |
Time Detail |
(Optional) Click to view the Review Time Details page. |
Exception
Exception Detail |
These columns only appear if there is a row with an exception. Click to view the details about the worker's exception from advancement. |
Acknowledge Exception |
Select to indicate that you acknowledge the exception message and return the worker to advancement eligibility. |
Job
Job Code and Description |
Displays the job code and a description of the worker's job. |
Wage Plan
Salary/Wage Plan, Salary Grade and Step |
Displays the wage progression salary plan, grade, and step currently held by the worker. |
Labor Agreement
Labor Agreement . Description , and Bargaining Unit |
Displays the worker's labor agreement and bargaining unit. |
Access the Review Time Details page (click the Time Detail button on the Review Wage Progression - Elapsed Time tab (leave hours ) and Review Wage Progression - Reported Time tab (hours worked) on the Review Wage Progression page).
Note. The data populated on this page depends on the source of the data and process by which you populate this page. The Extract Payroll Data process populates the page with Payroll for North America pay period and earning period time data for the special accumulator identified in the worker's wage progression rule.
Access the Exception Messages page (click the Exception Detail button on the Review Wage Progression - Exception tab of the Review Wage Progression page).
When a worker's wage progression conditions warrant manual review and a possible manual adjustment, the Update Wage Progression process will flag their Review Wage Progression record. When a worker is excepted, you cannot advance the person until you have acknowledged the exception by selecting the Acknowledge Exception check box on the Review Wage Progression - Exception tab. However, the system will continue to update the worker's Review Wage Progression record when you run the Update Activity with Job Data and the Update Activity with Time Data processes.
When you select the Acknowledge Exception check box and save the Review Wage Progression page, the system updates the Acknowledged By and Acknowledged On fields with your user ID and the date and time you acknowledged the exception. Click the Notepad button to enter comments. You should add a note of explanation for all exception acknowledgements.
To approve and process wage advancements, use the Approve Employees to Advance component (HR_WP_ADVANCE) and the Process Wage Progression component (RUN_UPD_WP_ADVANCE).
This section provides an overview of the Advance Employees to the Next Step process and discusses how to:
Approve workers for advancement.
Process wage progression.
The Process Wage Progression process (HR_WP_ADV) advances employees to their next wage step, inserting a new Job Data row for each worker being processed.
If workers have a status of Approved on the Review Wage Progression page or you have manually approved them for advancement on the Approve Employees to Advance page, the process:
Updates the Job Data - Salary Plan page with the new step information and executes a Default Pay Components action to enter the new pay rates on the Compensation page (JOB_DATA3). Only rate codes with a Source of Sal Step will be updated. The process will not modify rate codes with a source of Manual.
Updates the qualifying row on the Review Wage Progression page for the completed salary step, setting the status to Advanced..
Inserts a new row into the Review Wage Progression page for the new salary step and sets the status to Not Qualified..
Note. If the worker has a status of Completed Wage Progression on the Review Wage Progression page, indicating that they have already reached the top of the wage progression, the process selects the Stop Wage Progression check box on the Job Data - Job Labor page.
You can also launch a preview report, Employees Due Advancement (WP001.SQR), from the Process Wage Progression page to create a list of all of the workers that the Process Wage Progression process will advance. The system will not include workers who have already been processed for advancement.
Page Name |
Definition Name |
Navigation |
Usage |
HR_WP_ADVANCE |
Workforce Administration, Labor Administration, Wage Progression, Approve Employees to Advance, Approve Employees to Advance |
If the worker's wage progression rule requires approval, approve workers for wage progression from the online list displayed by a Wage Progression Run ID. |
|
RUN_UPD_WP_ADVC |
Workforce Administration, Labor Administration, Wage Progression, Process Wage Progression, Process Wage Progression |
|
Access the Approve Employees to Advance page (Workforce Administration, Labor Administration, Wage Progression, Approve Employees to Advance, Approve Employees to Advance).
To approve a worker for wage progression, select the Select check box.
The system only displays those workers who have a status of Qualified - Approval Required or Almost Qualified on the Review Wage Progression page. Click the Activity Detail button to review a worker's wage progression information on the Review Wage Progression page.
If a worker has an unacknowledged exception, the system marks their row with a red alert icon (!) and makes the Select check box next to their name unavailable. Click the Exception Detail button to review the Exception Messages page.
Workers remain on the Employees Pending Advancement list until you process the wage advancement using the Process Wage Progression process. If you do not approve a worker on this list prior to running the Process Wage Progression process, the system changes their status on the Review Wage Progression page to Not Approved. You need to run the Update Wage Progression - Qualify Employees process to reset their status to Qualified - Approval Required or Almost Qualified and make them appear on this page for approval again.
Access the Process Wage Progression page (Workforce Administration, Labor Administration, Wage Progression, Process Wage Progression, Process Wage Progression).
Wage Progression Run ID |
Select the wage progression run ID representing the population of workers you want to process for advancement. |
Update Future Rows |
Select whether to update future-dated Job Data rows. If a worker has future-dated Job Data rows (rows whose effective dates are greater than the date the of the Job Data row the Advance Employees to next Step process will insert), the system will update the step and compensation data in the future Job Data rows in addition to adding the new current row. The process will only update future-dated Job Data rows with salary plan, grade, and step values identical to the new row. |
Last Process Dates |
This collapsible group box contains a log of the five wage progression programs. It indicates the last time each of the processes were run and which of the processes was run most recently. |