Cost Analysis According to Benefits Criteria

Technical name: 0PABN_C01_Q006

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 the first and second program groupings of employees, or by any free characteristic(s). It supports the following analyses:

  • Changes in employer expense for plan types over a period in time
  • Distribution of plan types amongst different groups of employees

Free Characteristics

InfoObject

Description

0PLANCATEG

Plan Category

0BEN_PLAN

Plan

0BEN_OPTION

Plan Option

0DEPCVRG

Dependent Coverage

0HICOMP

Highly Compensated Employees

0EECTRBGRP

Employee Contribution Grouping

0ERCTRBGRP

Employer Contribution Grouping

0COVERGRP

Coverage Grouping

0COSTGRP

Cost Grouping

0ELIGGRP

Eligibility Grouping

0CREDITGRP

Credit Grouping

0CALMONTH

Calendar Year/Month

0CALQUARTER

Calendar Year/Quarter

Rows

InfoObject

Description

0PRGRM_GRP1

First Program Grouping

0PRGRM_GRP2

Second Program Grouping

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)