Using Workforce Scorecard

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.

Click to jump to parent topicUnderstanding 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:

This section discusses:

Click to jump to top of pageClick to jump to parent topicIntegrations

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

Workforce Rewards Data Mart

Click to jump to top of pageClick to jump to parent topicScorecards and Strategy Components

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

Click to jump to top of pageClick to jump to parent topicKPIs

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.

Click to jump to top of pageClick to jump to parent topicBatch Processes

You must run the following jobstreams to populate key tables:

See Also

Processing KPIs and Scorecards

Click to jump to parent topicWorkforce Scorecard Summary

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

Click to jump to parent topicDelivered KPIs

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.

Click to jump to parent topicPrerequisites

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.

Click to jump to parent topicSetting Up and Using Workforce Scorecard

To use the Workforce Scorecard:

  1. Set up PeopleSoft EPM components, including but not limited to:

  2. Run ETL processes.

    Running the ETL processes populates the PeopleSoft EPM warehouse tables with the data needed for the Workforce Scorecard.

  3. Set up Scorecard, including but not limited to:

  4. Run the KP_ANALYZE and BC_ANALYZE processes to populate key tables.

  5. 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