Headcount and Personnel Actions

Technical Name: 0PA_C01

Use

The Headcount and Personnel Actions InfoCube (0PA_C01) contains all of the transaction data on headcount and personnel actions that has been uploaded from the source system(s). The data in this InfoCube is extracted from the Employee (0HR_PA_0) and Personnel Actions (0HR_PA_1) InfoSources.

The Employee InfoSource delivers all employee data per month. Update rules, however, are used to read characteristics and key figures for the end of the period (in this case, the end of the month). Example: If several cost center changes have occurred within one month, the cost center that is valid at the end of the month is updated.

You can use the InfoSet technology for HR Master Data (characteristics 0EMPLOYEE and 0PERSON) to perform headcount reports for a specific day. For further information about InfoSet technology, see the documentation on the SAP Business Information Warehouse (at http://help.sap.com ® SAP NetWeaver ® SAP Business Information Warehouse ® Release SAP BW 3.2 Content under Business Information Warehouse ®Administrator Workbench ® Modeling ® InfoProviders ® InfoSet).

The InfoCube includes the following general key figures: Number of Employees (0HDCNT_LAST), Number of Personnel Actions (0ACTION_CNT), and Headcount FTE (0HDCNT_FTE). The standard system also includes restricted key figures which only take specific personnel action types (such as Hiring, Leaving) into account, for example, or which show entries or leavers FTE, or which show the number of full-time and part-time staff. The system includes the following time dimensions for evaluations: "Calendar Day", "Calendar Year/Month", "Calendar Year/Quarter", and "Calendar Year".

You can evaluate these key figures according to various attributes, for example:

·        Personal data (such as nationality, gender, and language)

·        Organizational data (such as personnel area, employee group, and organizational unit)

Several structures containing key figures and/or specific calculation rules are provided with the InfoCube. These structures provide you with quick and easy access to frequently required evaluations, such as to determine the leaving rate, or to compare the headcount of the current and previous years (with absolute and percentage differences).

InfoSources

0HR_PA_0: Employees

0HR_PA_1: Personnel Actions

Characteristics

InfoObject

Description

0EMPLOYEE

Employee

0PERSON

Person

0ACTIONTYPE

Action Type

0ACTIONREAS

Action Reason

0PERS_AREA

Personnel Area

0PERS_SAREA

Personnel Subarea

0AGE_RANGE

Age Range

0COUNTY_CDE

County Code

0GENDER

Gender

0COUNTRY

Country Key

0AGE

Age in Years

0NATION

Nationality

0POSTAL_CD

Postal Code

0REGION

Region

0PERSLANGU

Language

0CO_MST_AR

Controlling Area of Master Cost Center

0MAST_CCTR

Master Cost Center

0ORGUNIT

Organizational Unit

0HRPOSITION

Position

0JOB

Job

0PAYPCT_CHA

Capacity Utilization Level in %

0EMPLSTATUS

Employment Status

0SRVCLEN

Length of Service

0COMP_CODE

Company Code

0EMPLGROUP

Employee Group

0EMPLSGROUP

Employee Subgroup

0PAYRL_AREA

Payroll Area

0SALARYGR

Pay Grade

0SALARYAR

Pay Grade Area

0SALARYTY

Pay Grade Type

0SALARYLV

Pay Grade Level

0ESGFORCAP

Employee Subgroup Grouping for Collective Agreement Provisions

0COUNTRY_ID

Country Grouping

0PAYSCALETY

Pay Scale Type

0PAYSCALEAR

Pay Scale Area

0PAYSCALEGR

Pay Scale Group

0PAYSCALELV

Pay Scale Level

0CNTRCTTYPE

Contract Type

The Age Range (0AGE_RANGE) and Age in Years (0AGE) characteristics are calculated characteristics.

·        The Age Range characteristic contains an employee's age based on date of birth and the period from the appropriate InfoSource. The ranges are already determined by the update rules.

Note that you must manually create the texts for this characteristic as follows:

Age range (AGE_RANGE)

Short text (TXTSH)

0

Unavailable

1

< 20

2

20 - 29

3

30 - 39

4

40 - 49

5

50 - 59

6

60 - 69

7

і 70

·        The Age in Years characteristic contains an employee's age at the end of a period. You can define an age hierarchy according to the specific requirements of your enterprise, and then display the age structure of your enterprise, for example. To enable you to perform age-based calculations, the system includes the 0AGE_KYF key figure.

The age characteristics are calculated using update rules at the end of a period. The period depends on the InfoSource from which it is taken. For example, the end of the period can be at the end of a calendar day or month.

A person can have multiple assignments as an employee. To make a distinction between employment relationships (employees = 0EMPLOYEE) and real people (0PERSON), the person is an attribute of the employee.

If hierarchies exist for the Organizational Unit (0ORGUNIT) and Master Cost Center (0MAST_CCTR) InfoObjects, you can activate them using the Properties function. This allows you to depict hierarchical, multi-level aggregations.

Time Characteristics

In the update rules, numerous fields are read from the master data tables at the end of the period (usually the last day of the month) and written to the InfoCube as characteristics. For this reason, it is necessary that the master data is loaded and activated before the InfoSources.

InfoObject

Description

0CALYEAR

Calendar Year

0CALDAY

Calendar Day

0CALMONTH

Calendar Year/Month

0CALQUARTER

Calendar Year/Quarter

0CALMONTH2

Calendar Month

0CALQUART1

Calendar Quarter

Key Figures

InfoObject

Description

0ACTION_CNT

Number of Actions

0HDCNT_LAST

Number of Employees

0AGE_KYF

Age in Years

0PAYPCT

Capacity Utilization Level in Percent

0HDCNT_FTE

Headcount FTE

0SRVCLENKYF

Length of Service (in Years)

Restricted Key Figures

Restricted key figures are derived from InfoCube key figures by filtering one or more InfoCube characteristics. This results, for example, in the Number of Entries (0R_PA_001) and Number of Leavers (0R_PA_002) restricted key figures.

InfoObject

Description

Formula/Restriction

0R_PA_003

Entries FTE

Headcount FTE restricted to the Hiring action type

0R_PA_001

Number of Entries

Number of personnel actions restricted to the Hiring action type

0R_PA_006

Number of Part-Time Staff

Number of employees with capacity utilization level Ј 99 %

0R_PA_005

Number of Full-Time Staff

Number of employees with capacity utilization level = 100 %

0R_PA_002

Number of Leavers

Number of personnel actions restricted to the Leaving action type

0R_PA_004

Leavers FTE

Headcount FTE restricted to the Leaving action type

Structures

InfoObject

Description

0QT_PA_001

Comparison of Previous Year/Current Year

0QT_PA_022

Comparison of Last Month in Previous Year/Current Month

0QT_PA_009

Comparison of Last 4 Quarters

0QT_PA_010

Average of Last 4 Quarters

0QT_PA_011

Percentage Breakdown of Headcount FTE

0QT_PA_012

Average 4 Quarters Previous Year

0QT_PA_023

Average 4 Quarters Previous Year (Reference: End of Quarter)

0QT_PA_013

4-Quarter Comparison Previous Year

0QT_PA_014

12 Month Average Previous Year

0QT_PA_015

12-Month Comparison Previous Year

0QT_PA_006

Employees’ Average Age

0QT_PA_018

Average Length of Service

0QT_PA_017

Entry Rate

0QT_PA_003

Net Entry Rate

0QT_PA_016

Leaving Rate

0QT_PA_005

Percentage Breakdown of Employees

0QT_PA_008

Percentage Breakdown of Entries

0QT_PA_007

Percentage Breakdown of Leavers