Grouping Employees

This chapter provides an overview of grouping and discusses how to:

Click to jump to parent topicUnderstanding Grouping

A pension plan can include unique provisions for different subsets of your employee population. There might be different rules for:

A critical step in implementing your plan rules is applying the rules to the appropriate groups. Use custom statements to specify criteria to define each group. The group definitions can be shared among plans and function results.

You can set up group precedence to establish a method for handling situations when an employee falls into more than one group. The precedence is specific to each function result, so you can set up different precedence orders for different areas of your plan.

Periodic processing can use group definitions to determine which employees to process in a particular job.

Groups are extremely important to implementing your plan rules. Group membership controls which rules are used at every step of the calculation. Consider the following examples, which illustrate the power of this feature.

Time-Based Grouping

When you grandfather rules, you set up time-based groups to identify employees who qualify for the grandfathered benefit. For example, in 1970 you changed your plan rules from five-year cliff vesting to seven-year step vesting:

Group Criteria

Vesting Definition

Hire date is before 1970

Better of five-year cliff vesting and seven-year step vesting

Hire date is 1970 and after

Seven-year step vesting

Grouping with Benefit Eligibility

You only want to calculate the reduced benefit amount for employees who are eligible for early retirement:

Group Criteria

Benefit Formula Definition

Early retirement eligibility is yes

Unreduced benefit times early retirement factor

Note. There's no group for employees who are not eligible. Those employees will bypass this function result. Therefore, you need to be very careful that no other function result down the line looks for the missing results.

Grouping with Service

Your cash balance account credits vary with service:

Group Criteria

Cash Balance Definition

Service is less than 10 years

Credit 5 percent of salary

Service is greater than 10 years

Credit 6 percent of salary

Grouping with Vesting

Vested employees use different break-in-service rules from unvested employees:

Group Criteria

Service & Break Definition

Vesting equals 0 percent

Use rule of parity to determine if prior service is restored.

Vesting greater than 0 percent

Always restore previous service.

Grouping Based on Job

You negotiate different unreduced early retirement criteria with different unions:

Group Criteria

Benefit Eligibility Definition

Union Code = 81

Age 60 or 30 years of service

Union Code = 82

Age 60

Grouping Based on Employee Type

Full-time employees use elapsed time service. Part-time employees use hours counting service:

Group Criteria

Service Definition

Employee Status is F

Elapsed time service

Employee Status is P

Hours counting service

Grouping Based on Calculation Reason

Death benefits have a different (reduced) set of optional forms from regular retirement benefits:

Group Criteria

Optional Forms Definition

Calc Reason Code is termination or disability

Full set of optional forms

Calc Reason Code is death

No joint and survivor forms allowed

Calculate social security benefits differently for old age retirement and disability retirement:

Group Criteria

Social Security Definition

Calc Reason Code is disability

Calculate social security disability benefits.

Calc Reason Code is not disability

Calculate social security old age benefits.

Grouping Based on Payee

Qualified Domestic Relations Order (QDRO) calculations are based on an amount entered into the system by the administrator. The calculation then runs the early and late retirement factors and optional forms of payment functions to apply any early retirement reduction and produce optional form choices. These two functions, therefore, may need QDRO-specific definitions:

Group Criteria

Optional Forms of Payment Definition

Regular employees

Full set of optional forms

QDRO alternate payees

No forms with survivor benefits

 

Group Criteria

Early and Late Retirement Factors Definition

Regular employees

6 percent reduction for each early year between employee's age 65 and 60

Note. Employee ID is used to kick off the calculation.

QDRO alternate payees

6 percent reduction for each early between the original employee's age 65 and 60

Note. QDRO ID is used to kick off the calculation.

The original employee is the former spouse.

Click to jump to parent topicUsing Time-Sensitive Grouping Based on Eligibility

This section provides overview of eligibility and eligibility-based groups and discusses setting up eligibility-based groups.

Click to jump to top of pageClick to jump to parent topicUnderstanding Eligibility

The plan eligibility function produces a timeline of eligible and ineligible periods. Service typically accrues only during periods of eligibility. Cash balance accounts and employee contributory accounts typically accumulate both credits and interest during periods of eligibility, but only accumulate interest during periods of ineligibility.

Click to jump to top of pageClick to jump to parent topicUnderstanding Eligibility-Based Groups

Following are some examples that use eligibility history as grouping criteria.

Service

Service only accrues while an employee meets plan eligibility criteria:

Group Criteria

Service Definition

Eligible

Plan service rules

Ineligible

No service accrues

Elapsed time and hours equivalence service accrue based on an employee's action and reason history. If you fail to establish eligible and ineligible definitions, employees continue to accrue service for time worked while ineligible. For example, an hourly employee who used to be salaried could continue to accrue service under the salaried plan. This may be desirable for vesting service, but is likely undesirable in other situations.

Hours counting service accrues based on consolidated hours. If the consolidated hours definition already distinguishes between hours worked while eligible and hours worked while ineligible, you may not need to create separate eligible and ineligible definitions for this service type.

Cash Balance Accounts

Accounts earn interest at all times, but only get additional earnings-based credits during periods of eligibility:

Group Criteria

Cash Balance Definition

Eligible

Cash balance credit of 4 percent of salary and interest

Ineligible

Interest only

If the consolidated earnings definition excludes ineligible earnings, you may not need to set up eligible and ineligible groups for cash balance accounts.

If the consolidated contributions definition only includes eligible contributions, you may not need to set up eligible and ineligible groups for employee accounts.

Consolidated Earnings

The final average earnings (FAE) function only uses earnings from periods when an employee met the plan's eligibility requirements. Because FAE uses the consolidated earnings result, you restrict earnings at the consolidation level:

Group Criteria

Consolidated Earnings Definition

Eligible

Plan earnings definition

Ineligible

Zero earnings

Note. In this scenario, you would set the FAE definition to ignore zeros. Otherwise, you might lower the average by picking up zeros from periods of ineligibility.

Click to jump to top of pageClick to jump to parent topicSetting Up Eligibility-Based Groups

When employees change jobs within a company, they often move into and out of pension plan eligibility. When you run a calculation for such an employee, service accrual may stop during the period of ineligibility and resume if the employee becomes eligible again. For a cash balance plan, account credits probably stop, but interest continues during the period of ineligibility. You may also want to exclude earnings from the consolidated earnings history to prevent the final average earnings function from using the ineligible earnings.

All of these scenarios demand that you set up different definitions for eligible and ineligible periods. As employees move in and out of eligibility, the system will automatically use the appropriate definition for the eligible and ineligible periods. To apply these eligible and ineligible definitions, you need eligible and ineligible groups.

Note. PeopleSoft delivers two group custom statements: PA_ELIG and PA_INELIG. When you select Eligible or Ineligible, the system uses these statements to append the eligible or ineligible criteria to your group. Do not modify these statements.

See Also

Setting Up Function Results

Click to jump to parent topicUsing Groups for Periodic Processing

Periodic processes are processes that you run on a regular basis to maintain your pension data. Consolidations run only as periodic processes, and other functions which store history also run in periodic mode.

You can run periodic processes for:

When you use a group custom statement, the system evaluates every employee in the system against the criteria to determine whom to process. This is a very slow process, and PeopleSoft does not recommend that you use it on a regular basis. Instead, use predefined employee lists, which process those employees on the list without needing to evaluate any other employees.

Note. List processing is much more efficient than group processing. A group that you define to include all employees belonging to Plan A takes exponentially longer to process than a list that includes the same employees. It is well worth your while to use SQRs to create and maintain lists for periodic processing. For example, to process all employees who are paid monthly, do not create a group with this criteria. Instead, create an SQR that selects employees who are paid monthly and creates a calculation group list consisting of those employees. Run that SQR again before each periodic processing run in order to keep your list up to date.

Click to jump to parent topicDefining a Group

You define a group on the Custom Statement page. You access a group on the Group Definition page. The statement type is always G (Group Function Definition).

When you set up group custom statements, you enter the requirements in Boolean If clauses. You do not need the Then portion of the If-Then statement. When an employee meets the conditions, a yes value is assumed.

You can base groups on any criteria that the database tracks. This might include:

See Also

Using Custom Statements and Spouse Eligibility Statements

Click to jump to parent topicSetting Up Group Precedence

To set up grouping precedence, use the Group Precedence (GROUP_PRECEDENCE) component.

This section provides an overview of group precedence, list the page used to set up group precedence, and discusses how to define group precedence.

Click to jump to top of pageClick to jump to parent topicUnderstanding Group Precedence

When you set up a function result, you associate groups with the definitions that they use. Implicit in this organization is the requirement that each employee only belong to a single group. If an employee meets the criteria for multiple groups, you need a way to determine which group affiliation takes precedence.

The Function Result page includes a precedence order field; however, you can only see one row of data at a time, so setting up the precedence order can involve a lot of scrolling.

A more convenient way to set your precedence order is to use the Group Precedence page. This page displays all the groups used in a function result in a convenient summary format that enables you to easily review all the groups and their precedences. This page is always keyed to a specific effective-dated row within a function result.

Click to jump to top of pageClick to jump to parent topicPage Used to Set Up Group Precedence

Page Name

Definition Name

Navigation

Usage

Group Precedence

PA_GROUP_PRECEDNCE

Set Up HRMS, Product Related, Pension, Pension Plan Implementation, Group Precedence, Group Precedence

Set precedence order for groups.

Click to jump to top of pageClick to jump to parent topicDefining Group Precedence

Access the Group Precedence page (Set Up HRMS, Product Related, Pension, Pension Plan Implementation, Group Precedence, Group Precedence).

Group

The page displays the group information from the Function Result page.

Precedence Order

This establishes which group to use for an employee who meets the conditions for multiple groups.

A group with a lower number has precedence over a group with a higher number. For example, employees who simultaneously fall into groups with precedence orders 1 and 2 use the definitions for the group with precedence 1.

See Also

Setting Up Function Results