Participation Analysis According to Benefits Criteria

Technical name: 0PABN_C01_Q008

Based on InfoCube: 0PABN_C01 (Benefits)

Use

This query shows the number of participating and eligible employees, and percentage participation for plans within a benefit area. These key figures are broken down by a combination of first and second program grouping, or by any free characteristic(s).

The query can be used to analyze the popularity of individual plans among different groups of employees, for example.

Free Characteristics

InfoObject

Description

0PLANCATEG

Plan Category

0BEN_PLAN

Benefit 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

0PARTICIP

Number of Participating Employees

0ELIGIBLE

Number of Eligible Employees

0C_PABN_008

Percentage Participation (0PARTICIP Number Of Participating Employees / 0ELIGIBLE Number Of Eligible Employees)