Cost Analysis According to Organizational Criteria

Technical name: 0PABN_C01_Q005

Based on InfoCube: 0PABN_C01 (Benefits)

Use

This query shows employer expense and average employer expense for plan types within benefit areas, broken down by personnel area and subarea, or by any free characteristic(s). It supports the following analyses:

  • Changes in employer expense over a period in time
  • Comparison of expenses for different organizational areas

Free Characteristics

InfoObject

Description

0PLANCATEG

Plan Category

0BEN_PLAN

Plan

0BEN_OPTION

Plan Option

0ORGUNIT

Organizational Unit (hierarchical characteristic)

0MAST_CCTR

Master Cost Center

0CO_MST_AR

Controlling Area for Master Cost Center

0CALMONTH

Calendar Year/Month

0CALQUARTER

Calendar Year/Quarter

Rows

InfoObject

Description

0PERS_AREA

Personnel Area

0PERS_SAREA

Personnel Subarea

Columns

InfoObject

Description

0CALYEAR

Calendar Year

0BEN_AREA

Benefit Area

0PLANTYPE

Plan Type

0C_PABN_001

Employer Expense (0ERCTRB Employer Contributions + 0ERCOST Employer Costs + 0ERCREDIT Employer Credits)

0PARTICIP

Number of Participating Employees

0C_PABN_006

Average Employer Expense (0C_PABN_001 Employer Expense / 0PARTICIP Participating Employees)