Compensation Analysis

Technical Name: 0PACM_C01

Use

This InfoCube contains all the transaction data from the source system(s) on employees’ compensation. The data is transferred to the InfoCube via the Payments InfoSource (0HR_PA_CM_2).

A number of structures or templates are provided with the InfoCube in the standard system. These structures contain the key figures in combination with certain calculation rules. The templates give you swift and easy access to frequently used evaluation structures. The results are displayed as either absolute or percentage values.

InfoSources

0HR_PA_CM_2: Payments

The InfoSource reads the data from the Master Data table and writes it in the InfoCube as a characteristic. Therefore, you must ensure that master data is loaded and activated before the InfoSources.

Characteristics

InfoObject

Description

0EMPLOYEE

Employee

0PERSON

Person

0CO_MST_AR

Controlling Area of Master Cost Center

0MAST_CCTR

Master Cost Center

0HRPOSITION

Position

0JOB

Job

0ORGUNIT

Organizational unit

0PAYRL_AREA

Payroll Area

0PAYSCALEAR

Pay Scale Area

PAYSCALEGR

Pay Scale Group

0PAYSCALELV

Pay Scale Level

0PAYSCALETY

Pay Scale Type

0PERS_AREA

Personnel Area

0PERS_SAREA

Personnel Subarea

0EMPLGROUP

Employee Group

0EMPLSGROUP

Employee Subgroup

0EMPLSTATUS

Employment Status

0GENDER

Gender

0NATION

Nationality

0PERSLANGU

Language

0AGE

Age in Years

0COUNTRY_ID

Country Grouping

0COUNTRY

Country

0COUNTY_CDE

County Code

0REGION

Region (state, province, county)

0COMP_CODE

Company Code

0POSTAL_CD

Postal Code

0ESGFORCAP

Employee Subgroup Grouping for Collective Agreement Provisions

PAYPCT_CHA

Capacity Utilization Level %

0SRVCLEN

Length of Service (in Years)

0SALARYAR

Salary Area

0SALARYGR

Salary Group

0SALARYLV

Salary Level

0SALARYTY

Salary Structure

0CMPSALDV

Salary Divisions in Pay Grades

Time Characteristics

InfoObject

Description

0CALDAY

Calendar Day

0CALMONTH

Calendar Year/Month

0CALQUARTER

Calendar Year/Quarter

0CALYEAR

Calendar Year

0CALMONTH2

Calendar Month

0CALQUART1

Calendar Quarter

Key Figures

InfoObject

Description

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)

0SALLVMAX

Pay grade level maximum

0SALLVMIN

Pay grade level minimum

0PAYLVAMT

Pay scale level amount

0SALGRMAX

Pay grade maximum

0SALGRMIN

Pay grade minimum

0ANSALARY

Annual salary

0CMPBONUS

Bonus payment

0FTEANSAL

Annual salary FTE

0SALGRMAX_C

Pay grade maximum (cumulated)

0SALGRMIN_C

Pay grade minimum (cumulated)

0SALLVMAX_C

Pay grade level maximum (cumulated)

0SALLVMIN_C

Pay grade level minimum (cumulated)

Calculated Key Figures

InfoObject

Description

Formula/Restriction

0PACM_C01_CK0007

Amount over pay grade maximum (cumulated)

'Annual salary FTE' - 'Maximum group (cumulated)'

0PACM_C01_CK0010

Amount over pay grade level maximum (cumulated)

'Annual salary FTE' - 'Maximum level (cumulated)'

0PACM_C01_CK0009

Amount over pay grade midpoint (cumulated)

‘Annual salary’ – ‘Midpoint’ (cumulated)

0PACM_C01_CK0012

Amount over pay grade level midpoint (cumulated)

‘Annual salary’ – ‘Midpoint pay grade level’ (cumulated)

0PACM_C01_CK0008

Amount below pay grade level midpoint (cumulated)

'Minimum group (cumulated)' - 'Annual salary FTE'

0PACM_C01_CK0011

Amount below pay grade level midpoint (cumulated)

'Minimum level (cumulated)' - 'Annual salary FTE'

0PACM_C01_CK0003

Pay grade midpoint (cumulated)

(‘Maximum group (cumulated)’ + ‘Minimum group (cumulated)’)/2

0PACM_C01_CK0004

Pay grade level midpoint (cumulated)

(‘Maximum level (cumulated)’ + ‘Minimum level (cumulated)’)/2

Units

InfoObject

Description

0CURRENCY

Currency