Employees Above Pay Grade Midpoint

Technical Name: 0PACM_C01_Q0004

Based on the InfoCube: 0PACM_C01 (Compensation analysis)

Use

This query displays all employees, according to pay grade, whose annual salary for the current year is above the pay grade midpoint.

Personal and organizational data is used for evaluations.

Filter

InfoObject

Description of InfoObject
(and Restriction of Calculation Formula)

0CMPSALDV

Salary Divisions in Pay Grade (Third DivisionAbove the Maximum)

Free Characteristics

InfoObject

Description

0EMPLOYEE

Employee

0EMPLSTATUS

Employment Status

0AGE

Age in Years

0SRVCLEN

Length of Service

0PERS_AREA

Personnel Area

0PERS_SAREA

Personnel Subarea

0EMPLGROUP

Employee Group

0EMPLSGROUP

Employee Subgroup

0JOB

Job

0ORGUNIT

Organizational unit

0MAST_CCTR

Master Cost Center

0SALARYAR

Pay Grade Region

0SALARYTY

Pay Grade Structure

0SALARYLV

Pay Grade Level

0COUNTRY_ID

Country Grouping

Rows

InfoObject

Description of InfoObject
(and Restriction of Calculation Formula)

0SALARYGR

Pay Grade

Columns

InfoObject

Description of InfoObject
(and Restriction of Calculation Formula)

0CALYEAR

Calendar Year (Current Calendar Year)

0HDCNT_LAST

Number of Employees

0FTEANSAL

Annual salary FTE

0PACM_C01_CK0003

Pay Grade Midpoint

0PACM_C01_CK0009

Amount over pay grade midpoint (cumulated)