Integrating with PeopleSoft Workforce Rewards
In view of the trend in recent years for compensation to exceed 50 percent of overall expenses for large corporations, compensation planning has become a more complex and critical component of the budgeting process. With Planning and Budgeting, you can now integrate job and position data from HRMS as well as headcount and salary data from Workforce Rewards Compensation Planning and Simulation (CPS) Scenario, to enable more sophisticated budgeting of compensation costs.
This is the integration process flow between HRMS, Workforce Rewards, and Planning and Budgeting:
The ETL tool populates the HRMS Warehouse tables in EPM, such as PS_JOB_F00 and PS_POSITION_DATA.
WFR Compensation Strategy uses this data to project future compensation plan expenses.
The CPS module provides tools to plan, review, and analyze the total compensation costs and strategies for your workforce. With Compensation Strategy, you can automate and streamline the performance of these compensation strategy tasks:
Use data extracted from multiple sources.
Define compensation rules for any type of compensation, such as base pay, variable compensation, or benefits compensation.
Use Workforce Simulation (WFS) to create scenarios of your organization's job growth and reduction, or headcount plans, and simulate new employees/positions.
Create and analyze multiple compensation scenarios involving combinations of compensation types, such as base pay, variable compensation, and benefits compensation.
Evaluate the impacts of these scenarios on compensation distribution, costs, and value.
When the CPS scenario is final, the CPS_APPRV engine populates the position budgeting tables in the EPM database (PS_BP_JOB_F00, PS_BP_COMP_F00, PS_BP_POSITION_D00) for Planning and Budgeting with the compensation scenarios data from Workforce Rewards CPS tables (WA_CALC_F00, WA_JOB_S00, and WA_CALC_TGT).
The data from Workforce Rewards includes future (not current) projections of employee, salary, and benefits information.
The data from the EPM database tables is used during data staging to seed planning centers for a position activity scenario in Planning and Budgeting for budget preparation.
As defined on the Data Source page for the position activity scenario, you can use HRMS, WFR, or another activity scenario as your data source.
The EPM database tables used to store the position activity data in Planning and Budgeting are updated while users complete, submit, and approve position budget information.
When the position budget is considered final, it is exported back to the Planning and Budgeting source tables either to be used by another activity scenario or to be exported to HRMS. The master version data is exported into these tables: PS_BP_JOB_F00, PS_BP_POSITION_D00, and PS_BP_COMP_F00.
The final budget information from the position budgeting tables in the EPM database can be exported back to the source HRMS system. You use the ETL tool and maps to transfer the position and employee budget data back to the HRMS source system.
The planning model can stage data from multiple sources for a specific position activity scenario. You can select source data from HRMS, Workforce Rewards, or another activity scenario that was prepared and exported earlier. In preparation for staging job and position data from Workforce Rewards for an activity scenario, you must first define Workforce Rewards as a data source in the planning model.