This chapter provides overviews of Workforce Scorecard, scorecard summary, and delivered key performance indicators (KPIs), lists prerequisites, and discusses how to set up and use Workforce Scorecard.
The Workforce Scorecard is a component of a larger company-wide scorecard that facilitates the measurement and communication of human resources objectives and performance across the enterprise. Following the basic tenets of scorecard theory, KPIs within the Workforce Scorecard are used to evaluate how well employees are carrying out the internal initiatives necessary to serve their customers, how those initiatives are associated with the financial and strategic goals of the organization, and how efficiently and effectively all employees in the organization are performing. Used in this manner as an organizational and communications tool, the Workforce Scorecard supports the shift of the human resources function from an administrative entity to a key strategic partner.
Some benefits of using the Workforce Scorecard are:
Linking human resources KPIs to corporate-wide objectives using an Enterprise Scorecard approach.
Quickly comparing current company practices to internal historical measures and external benchmarks.
Measuring and aligning your human resource initiatives within a business framework.
Accurately determining and tracking the composition and deployment of the workforce.
Enabling easy access to information by distributing reporting results through the internet.
This section discusses:
Integrations
Scorecards and strategy components
Key Performance Indicators
Batch processes
The Workforce Scorecard is part of the Recruiting, Development, Deployment, and Reward business processes.
The Workforce Scorecard works in conjunction with Scorecard and the Workforce Data Mart. The Workforce Scorecard uses Scorecard's tools to provide a current representation of how the company is meeting its human resources objectives. The Workforce Data Mart provides details and analysis of how and why these trends are occurring.
Data flows through the Scorecard application based on a defined frequency. Transactional data is provided to PeopleSoft EPM where it is transformed using the Scorecard analysis tools. The system displays analysis results through the Workforce Data Mart to users who can use this information to analyze trends or take actions as necessary. For example, you can analyze details such as job demographics, personal demographics, and compensation.
See Also
The Workforce Scorecard is a view of your company's human resource objectives and performance. The scorecard's foundation is a strategy tree that is comprised of hierarchical nodes of strategy components.
Strategy components are the elements that make up your strategy, and are the nodes on your strategy tree or tables. Vision, strategic thrusts, and critical success factors are all strategy components, and represent the goals that your organization is trying to achieve. KPIs, which measure how well an organization is achieving those goals, are attached to scorecard strategy components, which are typically critical success factors.
The predefined data components that make up the Workforce Scorecard are delivered separately from the Scorecard application. These components are delivered at the time of installation. After the database is installed at your site, setting up and accessing the Workforce Scorecard involves setting up and populating PeopleSoft EPM, updating several components of the scorecard, and populating the final reporting tables.
Note. Before you attempt to set up the Workforce Scorecard, you should have installed the appropriate components using the installation documentation and moved the appropriate data components to your system database.
The predefined data components, as delivered, are set up to run with a specific business unit, setID, model ID, scenario ID, and so on. All of the appropriate security and object IDs are delivered as sample data. If you install the Workforce Scorecard to a demo database, you can acquaint yourself with the functionality in a demo environment. Using the delivered scorecard is optional, and you can modify it to suit your implementation.
This table lists the field values for this scorecard:
Scorecard ID |
BSC_HRSCORECARD |
SetID |
SHARE |
Business Unit |
CORP1 |
Scenario ID |
ACTUAL02 |
Model |
PRODH |
Strategy Tree |
WS_SCORECARD |
Strategy Components |
HR_CSF1 (organizational effectiveness) HR_CSF2 (compliance) HR_CSF2A (gender composition) HR_CSF2B (age composition) HR_CSF2C (ethnicity composition) HR_CSF3 (staffing) HR_CSF4 (separation) HR_CSF5 (HR readiness) HR_CSF50 (expenses) HR_CSF51 (health and safety) HR_CSF52 (training) HR_CSF53 (compensation) HR_CSF6 (competencies) HR_CSF6A (competency inventory profile) HR_CSF6B (competency investment factor) HR_CSF7 (employee satisfaction) HR_ST1 (HR ST by BU dimension) HR_ST2 (HR ST by department dimension) HR_VISION (corporate vision for HR BSC) |
KPI Trees |
AGE_COMPOSITION, COMPENSATION, ETHNICITY, GENDER_COMPOSITION, SEPARATION, TOTAL_EXPENSE |
KPIs define the data value or calculation, from the PeopleSoft EPM warehouse tables, that is used to determine how well your organization is meeting its critical success factors.
The Workforce Scorecard delivers a set of predefined KPIs that provide executive and middle management with a representation of human resources-related activity. These predefined KPIs have been developed in conjunction with leading human resource and management consultants. The KPIs are linked to a set of critical success factors that cover all facets of human resources activities.
The following illustration is an example of critical success factors for a workforce scorecard:
Workforce Scorecard critical success factors
Using the predefined KPIs as a baseline, human resources and company management can view company performance for these critical success factors by business unit or department. Easy and timely access to this information enables management to track progress toward company goals and to take immediate action when necessary.
You must run the following jobstreams to populate key tables:
KP_ANALYZE
This jobstream populates KP_KPI_CALC_F00 and KP_KPI_ASMT_F00. Run this jobstream to validate the KPI calculation rules, verify end values, and test the KPI assessment rules.
BC_ANALYZE
This jobstream populates KP_KPI_CALC_F00, KP_KPI_ASMT_F00 and BC_ASSESS_F00. Run this jobstream to generate the final scorecard assessments after you validate your setup (by running KP_ANALYZE). If you set up this job to run regularly, the KPI process can aggregate data month-to-month and year-to-date. You must run this process after you populate or update the PeopleSoft EPM warehouse tables (such as during the ETL process) to view current results for your Workforce Scorecard.
See Also
Processing KPIs and Scorecards
The following table contains summary information for the 31 KPIs or categories of KPIs in the Workforce Scorecard that are related to critical success factors.
Note. This table is not an exhaustive list of all the KPIs delivered with the Workforce Scorecard, but only those relating to the Critical Success Factors. A total of 80 predefined KPIs are delivered with the Workforce Scorecard. Some are tied to critical success factors, others are specified as scorecard-related KPIs, and others are used to calculate other KPIs. Be aware that the Competency Inventory Profile is counted as two KPIs because two KPIs are actually defined in the metadata.
Critical Success Factor |
KPI Description |
Dimension (Object Type) |
Perspective |
KPI Calculation Definition |
Organizational Effectiveness |
Revenue Factor |
Business Unit |
Financial |
Total Revenue / Total FTEs |
Organizational Effectiveness |
Expense Factor |
Business Unit |
Financial |
Total Expenses / Total FTEs |
Organizational Effectiveness |
Income Factor |
Business Unit |
Financial |
Total Income / Total FTEs |
Compliance |
Gender Composition Ratios |
Business Unit |
Internal Processes |
Gender / Total Headcount |
Compliance |
Age Composition Ratios |
Business Unit |
Internal Processes |
Age / Total Headcount |
Compliance |
Ethnicity Composition Ratios |
Business Unit |
Internal Processes |
Ethnicity / Total Headcount |
Expenses |
Total Compensation Revenue Ratio |
Department |
Financial |
Total Compensation Expenses / Total Revenue |
Expenses |
Total Compensation Expenses Ratio |
Department |
Financial |
Total Compensation Expenses / Total Expenses |
Expenses |
Employee Compensation Factor |
Department |
Financial |
Total Compensation Expenses / Total Headcount |
Staffing |
Time to Fill Factor |
Business Unit |
Customer |
Total Time to Fill / Total Hires |
Staffing |
Total Accession Ratio |
Business Unit |
Customer |
Total Hires / Total Headcount |
Staffing |
Service Factor |
Business Unit |
Customer |
Length of Service / Total Headcount |
Separation |
Total Separation Ratio |
Business Unit |
Customer |
Total Separations / Total Headcount |
Separation |
Voluntary Separation Ratio |
Business Unit |
Customer |
Total Voluntary Separations / Total Headcount |
Separation |
Separation by High Performers |
Business Unit |
Customer |
Separations where performance rating is high |
Health and safety |
Workers' Compensation Expenses Ratio |
Department |
Internal Processes |
Total Workers' Compensation Expenses / Total Expenses |
HR Readiness |
HR FTE Ratio |
Business Unit |
Internal Processes |
Total FTEs / Total HR FTEs |
HR Readiness |
HR Headcount Investment Factor |
Business Unit |
Internal Processes |
Total HR Expenses / Total Headcount |
HR Readiness |
HR Expenses Ratio |
Business Unit |
Internal Processes |
Total HR Expenses / Total Expenses |
Training |
Training Cost Factor |
Department |
Learning & Growth |
Total Training Expenses / Total Trained Headcount |
Training |
Training Cost Ratio |
Department |
Learning & Growth |
Total Training Expenses / Total Expenses |
Training |
Training Inventory Profile |
Department |
Learning & Growth |
# Trained / Individual Training Course |
Competencies |
Competency Inventory Profile |
Business Unit |
Learning & Growth |
# Skilled / Individual Competency |
Compensation |
Direct Compensation Ratio |
Department |
Financial |
Total Direct Compensation Value / Total Compensation Value |
Compensation |
Cash Compensation Ratio |
Department |
Financial |
Total Cash Compensation Value / Total Compensation Value |
Compensation |
Benefits Compensation Ratio |
Department |
Financial |
Total Benefits Value / Total Compensation Value |
Compensation |
STI Compensation Ratio |
Department |
Financial |
Total STI Value / Total Compensation Value |
Compensation |
Base Compensation Ratio |
Department |
Financial |
Total Base Compensation Value / Total Compensation Value |
Compensation |
Compa-Ratio |
Department |
Financial |
Average (Base Compensation / Grade Midpoint) |
Compensation |
Gap to Market Variance |
Department |
Financial |
Average (Base Currency Amount − Survey Base Currency Amount) / Survey Base Currency Amount |
Employee Satisfaction |
Employee Lost Time Factor |
Department |
Internal Processes |
Days Away from Work/Headcount |
Details about the delivered KPIs are provided in the WFKPIS.PDF file that is located on the PeopleBooks CD. This file provides information on each of the delivered predefined KPIs via summary and detail tables. Use these tables to better understand Workforce Scorecard calculations. You can also use the information in these tables as a basis for altering the scorecard to update KPIs and target rules.
Load the predefined data components that are required for Scorecard by running a DMS script when you install the application.
See PeopleSoft EPM 9.1 Installation Guide on the PeopleSoft My Oracle Support website.
To use the Workforce Scorecard:
Set up PeopleSoft EPM components, including but not limited to:
Business rules.
General options.
Calendars.
Security.
PF and GL business units.
Trees.
Ledgers, templates, and the Ledger Mapper.
Models and scenarios.
Filters and constraints.
Run ETL processes.
Running the ETL processes populates the PeopleSoft EPM warehouse tables with the data needed for the Workforce Scorecard.
Set up Scorecard, including but not limited to:
Adding KPI dimension members.
Adding KPI target rules.
Updating the scorecard owner.
Run the KP_ANALYZE and BC_ANALYZE processes to populate key tables.
View scorecards using the PeopleSoft Business Interface.
See Also
Setting Up the Operational Warehouse - Enriched for EPM Analytical Applications
Setting Up EPM Infrastructure, Business Rules, and Security