Setting Up Base Benefits Core Tables

This chapter provides an overview of the Base Benefits core tables and explains how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding the Base Benefits Core Tables

Before you can begin building your benefit programs and entering your benefit plan information, there are some core tables that must be set up first. This chapter covers setting up those core tables.

Click to jump to top of pageClick to jump to parent topicSetting Up the Provider Table

A benefit provider is a vendor. A benefit provider is the entity that sponsors the benefit plan that your company offers your employees. For example, if your company offers a Blue Cross/Blue Shield health insurance plan, Blue Cross/Blue Shield is the provider. If your organization has a self-funded medical plan but uses a third-party administrator (TPA) to handle administrative functions such as eligibility and claims, the TPA can be considered a vendor.

You use the Provider/Vendor Table to set up an ID for each vendor.

In order to include a benefit provider in the HIPAA (Health Insurance Portability and Accountability Act) EDI File Creation process, you must specify the vendor's Federal Employer Identification Number (FEIN).

Warning! If your organization uses PeopleSoft Enterprise Payroll for North America and PeopleSoft Enterprise Payables to pay a benefit vendor, add the vendor using the Payables Vendor Table, not the Base Benefits Vendor Table.

See Also

Setting Up Vendors

PeopleSoft Enterprise Payables 8.9 PeopleBook

Click to jump to top of pageClick to jump to parent topicSetting Up the Dependent Relationship Table

You define the relationships—for example, son, daughter, grandmother, grandfather, nephew, or niece—that qualify as dependents according to your organization’s rules. You cannot enroll dependents in benefits if their relationships are not defined. For example, if you had not defined grandmother as an allowable dependent type, you couldn’t enter an employee’s grandmother as a dependent.

Beneficiary relationships are not tracked because they do not have the same legal ramifications as dependents.

Click to jump to top of pageClick to jump to parent topicPage Used to Set Up Dependent Relationships

Page Name

Object Name

Navigation

Usage

Dep. Relationship (dependent relationship)

DEPBEN_TYPE_TBL

Set Up HRMS, Product Related, Base Benefits, Dependent Relationships Table, Dep. Relationship

Tie relationships (spouse, son, daughter, and so on) to covered person types.

Click to jump to top of pageClick to jump to parent topicDefining Dependent Relationships

Access the Dep. Relationship page.

Relationship to Employee

The system displays the relationship that you selected to access the page.

Effective date

Enter the date on which the dependent status of this relationship goes into effect.

Status

Select whether the dependent relationship is Active or Inactive.

If the status is Inactive, the relationship is no longer considered a valid dependent relationship.

Covered Person Type

Select the covered person type you are using to define the relationship.

The delivered Translate Table values are:

  • Employee

  • Spouse

  • Child

  • Other Qualified Dependent

  • Domestic Partner

  • Non-qualified Dependent

Age Limit Flag

When the COBRA process for over-aged dependents is run, the system uses this flag to indicate which dependent roles should have the over-age rules applied.

Click to jump to top of pageClick to jump to parent topicSetting Up Coverage Codes

Coverage codes define who can be covered by a benefit.

You define and manage coverage codes for your benefit programs with the Coverage Code table. You will attach these coverage codes to your benefit plan options on the Benefit Program table.

PeopleSoft delivers seven basic coverage codes for which you define a minimum and maximum allowable for each eligible covered person type. These delivered coverage codes are described in this table:

Delivered Coverage Code

Employee Minimum / Maximum

Spouse Minimum / Maximum

Domestic Partner Minimum / Maximum

Other Qualified Dependent or Child Minimum / Maximum

Other Nonqualified Dependent Minimum / Maximum

1

Employee Only

1 / 1

not allowed

not allowed

not allowed

not allowed

2

Employee + Spouse

1 / 1

1 / 1

not allowed

not allowed

not allowed

3

Employee + Dependents

1 / 1

not allowed

not allowed

1 / 99

not allowed

4

Family

1 / 1

1 / 1

not allowed

1 / 99

not allowed

5

Domestic Partner Adult

not allowed

not allowed

1 / 1

not allowed

not allowed

6

Domestic Partner Child(ren)

not allowed

not allowed

not allowed

not allowed

1 / 99

7

Domestic Partner Adult + Child(ren)

not allowed

not allowed

1 / 1

not allowed

1 / 99

You can also define coverage codes to validate enrollments against a total number of eligible covered person types, for example, a coverage code that allows enrollment of the employee plus one dependent. The dependent can be either a spouse or a child. The system will sum the allowable covered person types defined for the coverage code rather than look at the minimum and maximum defined for each individual covered person type.

Click to jump to top of pageClick to jump to parent topicPage Used to Set Up Coverage Codes

Page Name

Object Name

Navigation

Usage

Coverage Code Tbl (coverage code table)

COVRG_CD_TBL

Set Up HRMS, Product Related, Base Benefits, Plan Attributes, Health Coverage Codes, Coverage Code Tbl

Define coverage codes.

Click to jump to top of pageClick to jump to parent topicEntering Coverage Code Information

Access the Coverage Code Tbl page.

COBRA Coverage Set

This is a two character code that is used to group coverage codes together for COBRA eligibility purposes. When an individual experiences a COBRA event, the system must adjust the range of coverage codes available to each qualified beneficiary. By restricting itself to a specific set of coverage codes, COBRA processing is able to more accurately determine which benefit options to present to a participant who is eligible for COBRA coverage. If COBRA coverage sets are not established, then COBRA processing may encounter multiple equivalent coverage codes, and eligibility determination may fail.

Total Covered Persons

Select this check box to activate the total covered person types functionality for this coverage code.

Total Minimum Covered andTotal Maximum Covered

These fields are only visible when the Total Covered Persons check box is selected.

Enter the allowable minimum and maximum covered persons. Include the employee in this count.

Allowable Covered Person Types

Covered Person Type

Select the type of person for which you are setting parameters.

Note. The coverage code controls for covered person type are used in PeopleSoft Enterprise Benefits Administration.

See Specifying Basic Rules for Event Classes.

Minimum Number Covered

Enter the minimum number of covered persons allowed.

If you have selected the Total Covered Persons check box, this field is not editable.

Maximum Number Covered

Enter the maximum number of covered person allowed.

If there is no limit to the number for this coverage code, enter 99.

If you have selected the Total Covered Persons check box, this field is not editable.

Click to jump to top of pageClick to jump to parent topicSetting Up Coverage Group Codes

Life insurance and accidental death and dismemberment (AD/D) plans use coverage group codes to establish the maximum lifetime coverage allowed.

For example, if you define a coverage group code with a 500,000 USD maximum, then enter that coverage group code for a supplemental life plan and a group life plan, and associate both benefit plans with a benefit program. If you were to enroll an employee in both of those plans, the system would ensure that the employee's total coverage by both plans does not exceed 500,000 USD.

If the total coverage for a participant exceeds the coverage maximum, the system will reduce the total coverage to meet the coverage maximum. As the system processes the deduction, it accumulates the coverage amounts and will begin reducing coverage when the coverage group maximum is reached. The system processes plans in order of deduction priority, and if more than one plan has the same priority, it processes in increasing plan type order.

Note. Payroll uses the effective date to determine which coverage maximum to use for a particular processing cycle, according to the pay period end date.

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

Page Name

Object Name

Navigation

Usage

Coverage Group Tbl (coverage group table)

COVERAGE_GROUP_TBL

Set Up HRMS, Product Related, Base Benefits, Plan Attributes, Life and AD/D Coverage Groups, Coverage Group Tbl

Define a coverage group code that sets the maximum total life and AD/D coverage for a group of life and AD/D benefit plans.

Click to jump to top of pageClick to jump to parent topicEntering Coverage Group Code Information

Access the Coverage Group Tbl page.

Effective Date

Enter the effective date for the coverage maximum.

Payroll uses the effective date to determine which coverage maximum to use for a particular processing cycle, according to the pay period end date.

Coverage Maximum

Enter the maximum total life and AD/D coverage.

This amount applies to all the life and AD/D benefit plans that you associate with the coverage group code and that you associate with one benefit program.

You connect a life or AD/D plan with a coverage group code using the Life and AD/D Plan Table.

Click to jump to top of pageClick to jump to parent topicSetting Up FEGLI Codes

Define codes for your Federal Employee Group Life Insurance (FEGLI) plans.

Click to jump to top of pageClick to jump to parent topicPages Used to Set Up FEGLI Codes

Page Name

Object Name

Navigation

Usage

FEGLI Code Table

GVT_FEGLI_TBL

Set Up HRMS, Product Related, Base Benefits, Plan Attributes, FEGLI Code Table, FEGLI Code Table

Define FEGLI codes.

Click to jump to top of pageClick to jump to parent topicEntering FEGLI Code Information

Access the FEGLI Code Table page.

Click to jump to top of pageClick to jump to parent topicSetting Up the Service Step Table

When you set up savings plans you can define your organization's employer match according to the employee's years of service. The Service Step Table defines the different intervals, tax classification, and the amount of match.

You can also define deduction classifications based on either a percentage of the employee’s gross salary or a percentage of the employee’s contribution amount.

Click to jump to top of pageClick to jump to parent topicPage Used to Set Up the Service Step Table

Page Name

Object Name

Navigation

Usage

Service Step Table

SERVICE_STEP_TABLE

Set Up HRMS, Product Related, Base Benefits, Rates and Rules, Service Step Table, Service Step Table

Link the rate of employer matching contributions to an employee’s length of service.

Click to jump to top of pageClick to jump to parent topicEntering Service Step Table Information

Access the Service Step Table page.

After Months of Service

Enter the number of months the employee must be employed to receive the employer match.

Deduction Class

Enter the tax classification for this match.

Up to % of Employee's Earnings (up to percent of employee's earnings)

Enter the maximum amount of the employer match contribution percentage.

% of Employee Investment (percent of employee investment)

Enter the percentage amount of the employee contribution that the employer will match.

Example of Before- and After-Tax Matching

Let's say you have a 401(k) plan that's set up to match:

Here's how you set this up:

Deduction Class

Up to % of Employee Earnings

% of Employee Investment

Before

3

50

Before

6

100

After

2

25

After

4

50

After

6

100

Example of After Months of Service Rewards

This example shows how to use the After Months of Service field to create multiple service steps to reward employees for staying with the company.

After Months of Service

Deduction Class

Up to % of Employee Earnings

% of Employee Investment

0

Before

3

50

0

Before

6

100

0

After

2

25

0

After

4

50

0

After

6

100

24

Before

10

100

24

After

2

50

24

After

4

75

24

After

6

100

Click to jump to top of pageClick to jump to parent topicSetting Up Rates and Premium Limits

Your benefit system relies on rates to calculate the cost of benefits. You can create rate tables based on:

In addition to these rates tables, you may want to limit the amount an employee pays towards the premium. On each rate table, you have the option of setting a limit on the employee portion of the premium.

Understanding Employee Premium Limits

You can define limits on the employee’s portion of a benefit premium by specifying a percent of gross limit on the Calculation Rules Table.

For example, current legislation in Hawaii requires that employers charge no more than 1.5% of an employee’s gross wages for medical coverage. Only the employee’s personal coverage is subject to this limit.

If the rate table indicates the employer pays part of the premium, then any premium in excess of this final employee deduction amount (in this case, 1.5% of gross wages) is redirected (added) to the employer-paid portion of the premium. If the employer does not pay part of the premium, then no redirection takes place.

If the calculation rule associated with the benefit plan specifies a percent of gross limit, then the system calculates the premium as follows:

Lesser of [(EE Premium Amount Subject to Limit) or (Gross Pay × Limit %)] plus (Total EE Premium Amount − EE Premium Amount Subject to Limit)

Suppose that a monthly-paid employee is enrolled in family medical coverage, which has a flat rate of 300 USD per month. The amount of the employee’s portion is 125 USD. The following example shows how to apply a 1.0% of gross pay limit to the employee-only coverage:

Total EE Premium Amount = 300 USD

EE Premium Amount Subject to Limit = 125 USD

Limit = 1.0% of Gross Pay

Gross Pay = 10,000 USD

The deduction is calculated as:

[Lesser of (125 or (10,000 × .01))] + (300 − 125)

= [Lesser of (125 or 100)] + (175)

= (100) + (175)

= 275 USD

The amount of the employee premium in excess of the limited deduction is 25 USD (300 - 275). This excess amount is added to the employer-paid premium.

Here’s another example. Instead of the employee’s single-coverage portion of the premium being a flat amount of 125 USD, let’s define this as 30% of the premium amount:

Total EE Premium Amount = 300 USD

EE Premium Amount Subject to Limit = 30%

Limit = 1.0% of Gross Pay

Gross Pay = 10,000 USD

The deduction is calculated as:

[Lesser of (300 × 30%) or (10,000 × .01))] + (300 − 125)

= [Lesser of (90 or 100)] + (175)

= (90) + (175)

= 265 USD

In this case, 35 USD (300 - 265) is added to the employer-paid premium.

Warning! PeopleSoft delivers a set of rates with an ID of IRS. PeopleSoft Enterprise Payroll for North America uses these IRS rates to calculate imputed income. The IRS table ID set should not be changed.

Click to jump to top of pageClick to jump to parent topicCommon Elements Used by Rates and Premium Limits

Premium Pay Frequency

Define how you quote the cost of benefit rates.

If the employee’s pay frequency differs from the premium frequency, the system annualizes the coverage rates and divides by employee pay frequency to determine the pay period rate.

Rate per Unit

  • For a flat rate, select None.

  • For a rate that applies to each $100 of coverage, select Per Hundred.

  • For a rate that applies to each $1,000 of coverage, select Per Thousand.

Specify Limit

Click to display the Amount To Limit page and set employee premium limits.

Click to jump to top of pageClick to jump to parent topicPages Used to Define Rates and Premium Limits

Page Name

Object Name

Navigation

Usage

Age-Graded Rate

AGE_RATE_TABLE

Set Up HRMS, Product Related, Base Benefits, Rates and Rules, Age-Graded Rate Table, Age-Graded Rate

Define rates that are based on age, gender, and smoking habits.

Salary Rate Table

BAS_SALARY_RATE

Set Up HRMS, Product Related, Base Benefits, Rates and Rules, Salary Rate Table, Salary Rate Table

Define rates that are based on a percentage of salary.

Service Rate Table

SERVICE_RATE_TABLE

Set Up HRMS, Product Related, Base Benefits, Rates and Rules, Service Rate Table, Service Rate Table

Define rates that are based on length of service.

Flat Rate Table

BAS_FLAT_RATE_TBL

Set Up HRMS, Product Related, Base Benefits, Rates and Rules, Flat Rate Table, Flat Rate Table

Define rates that are based on a specific dollar amount.

Age Graded Rate - Amount to Limit

AGE_RATE_LMT

Click Specify Limit on the Age-Graded Rate page.

Define the portion of the employee rate that is subject to the percent of gross pay limit defined on the Calculation Rule page.

Salary Rate - Amount to Limit

BAS_SAL_RATE_LMT

Click Specify Limit on the Salary Rate Table page.

Set limits for base salary rates.

Service Rate - Amount to Limit

SERVICE_RATE_LMT

Click Specify Limiton the Service Rate Table page.

Set limits for length of service rates.

Flat Rate - Amount to Limit

BAS_FLAT_RATE_LMT

Click Specify Limit on the Flat Rate Table page.

Set limits for flat-amount rates.

Click to jump to top of pageClick to jump to parent topicDefining Age-Graded Rates

Access the Age-Graded Rate page.

Coverage/Price

Define rates for a specified gender, age range, and smoking habit.

The system calculates the employee portion of the premium based on the total rate and employer portion.

Note. We deliver a set of rates with an ID of IRS. PeopleSoft Enterprise Payroll for North America uses these IRS rates to calculate imputed income. This table should not be changed.

Click to jump to top of pageClick to jump to parent topicDefining Salary Rates

Access the Salary Rate Table page.

Employee Portion

Automatically calculated based on the total rate and employer portion.

Click to jump to top of pageClick to jump to parent topicDefining Service Rates

Access the Service Rate Table page.

Employee Portion

Automatically calculated based on the total rate and employer portion.

Click to jump to top of pageClick to jump to parent topicDefining Flat Rate Tables

Access the Flat Rate Table page.

Total

Enter the total cost of the coverage.

Include any administrative fee that you may charge.

Employee

Automatically calculated from the total and employer amounts.

Provider

The system automatically assigns theTotal amount to the provider.

If you include an administrative fee in the total, override the provider amount with what you actually pay the provider.

The Provider amount is only informational; you can use it for reports of provider payments.

Click to jump to top of pageClick to jump to parent topicDefining Employee Premium Limits

Access the Amount to Limit page.

Rate Limit Code

Defines the portion of the employee rate that is subject to the percent of gross pay limit defined on the Calculation Rule page. You can select:

  • All: Select this option when the entire employee rate is subject to the limit.

  • Flat Amount: Select this option to enter the amount that is subject to the limit.

  • Not Applicable: Select this option when the entire employee rate is subject to the limit.

  • Percent of Rate: Select this option to enter the percentage amount of the employee rate that is subject to the limit. This percentage amount cannot be greater than 100.

Click to jump to top of pageClick to jump to parent topicSetting Up Annual Benefits Base Rates

Some benefits, such as life and disability insurance, can be based upon the employee’s actual compensation rate or an annual benefits base rate (ABBR) that you define for the employee.

You can define and use an unlimited number of annual benefits base rates.

Click to jump to top of pageClick to jump to parent topicPage Used to Set Up ABBR Types

Page Name

Object Name

Navigation

Usage

ABBR Type

ABBR_TYPE

Set Up HRMS, Product Related, Base Benefits, Rates and Rules, Annl Benef Base Rt Type Tbl, ABBR Type

Define annual benefits base rates.

Click to jump to top of pageClick to jump to parent topicDefining Annual Benefits Base Rates

Access the ABBR Type page.

Click to jump to top of pageClick to jump to parent topicSetting Up Calculation Rules

You use calculation rules to define how deductions are calculated for each benefit plan. Calculation rules apply to the premium and the amount of coverage. When determining calculation rules, you need to understand:

Compensation Base Versus Annual Benefits Base Rate

Calculation rules use an employee’s earnings as part of the definitions. If you are going to base the employee’s earnings on an amount other than the employee’s regular compensation rate, you need to enter an amount in the Annual Benefits Base Rate field on the Compensation page of the Job Data component.

See Increasing the Workforce.

Note. If a calculation rule specifies that the ABBR should be used, but the employee has not been assigned an ABBR, the system will use the employee’s regular compensation rate instead.

(USF) Compensation Base

The compensation base is set through the Personnel Action Request (PAR) process. You can:

The system uses the regular adjusted compensation amount for benefit processing. The exception to this rule is FEGLI plans: you can have the system use a different base rate when processing FEGLI plans by overriding the FEGLI base. The FEGLI base mirrors the quoted total pay until it is overridden.

See (USF) Hiring Employees.

Salary As-Of Dates

If the premium or coverage is based on employee salary, you can specify the salary as of:

If you use Multiple Jobs functionality, you must also tell the system which jobs to use when calculating the employee’s earnings.

The calculation possibilities with as-of rates are:

Premium

Coverage

Calculation

Current

Current

As now

As-of

Current

See Example #1

As-of

As-of

See Example #2

Current

As-of

Invalid

Example #1: Employer Pays Increased Premium

An employee belongs to a life insurance plan that uses the premium as of January 1, current year and coverage as of the current date. The system uses the benefit base for the calculation.

Employee

Effective Date

Salary

Benefit Base

Ann Jeffrey

January 1, 2000

10,000

12,000

 

April 1, 2000

15,000

15,000

 

January 1, 2001

17,500

18,000

Table

Effective Date

Rate

Per

Life (employee)

January 1, 2000

1.00

Thousand

Life (employer)

January 1, 2000

2.00

Thousand

The employee gets a raise, so coverage increases during the year; however, until the next January 1, the system calculates the employee premium as if the coverage did not increase. The employer pays the difference between the employee deduction and the actual cost. This affects imputed income.

Pay End Date

Coverage

Employee Amount

Employer Amount

January 1, 2000

12,000

12.00

24.00

February 28, 2000

12,000

12.00

24.00

March 31, 2000

12,000

12.00

33.00

April 30, 2000

15,000

12.00

33.00

May 31,2000

15,000

12.00

33.00

Example #2: Coverage and Premium Remain the Same

Another employee belongs to a life insurance plan that uses the premium as of January 1, current year and coverage as of January 1, current year.

Employee

Effective Date

Salary

Benefit Base

Jim Henry

January 1, 2000

10,000

12,000

 

April 1, 2000

15,000

15,000

 

January 1, 2001

17,500

18,000

Table

Effective Date

Rate

Per

Life (employee)

January 1, 2000

1.00

Thousand

Life (employer)

January 1, 2000

2.00

Thousand

There is no change in Jim Henry’s coverage or premium until the new year.

Pay End Date

Coverage

Employee Amount

Employer Amount

January 31, 2000

12,000

12.00

24.00

February 28, 2000

12,000

12.00

24.00

March 31, 2000

12,000

12.00

24.00

April 30, 2000

15,000

12.00

24.00

May 31, 2000

15,000

12.00

24.00

Click to jump to top of pageClick to jump to parent topicPage Used to Set Up Calculation Rules

Page Name

Object Name

Navigation

Usage

Calculation Rules

CALC_RULES_TABLE

Set Up HRMS, Product Related, Base Benefits, Rates and Rules, Calculation Rules Table, Calculation Rules

Specify salary, age and service as of dates, as well as coverage, calculation, and rounding options for the calculation rule.

Click to jump to top of pageClick to jump to parent topicDefining Calculation Rules

Access the Calculation Rules page.

Effective Date

Must be the same as or prior to the effective dates of the one or more benefit program and benefit plan combinations that you associate the calculation rules with.

Combine Salary for Multi Jobs

Select to activate the grouping method for multiple jobs.

Consider Active Jobs Only

If you selected Combine Salary for Multi Jobs, select this option to have the system only look at jobs with a status of Active in the Job Data components.

Group Method

If you selected Combine Salary for Multi Jobs, select the grouping method to use when calculating premium and coverage amounts. Choose from:

  • All Flagged: All flagged jobs, regardless of benefit record number, are included in the calculation.

  • Flagged BR: All flagged jobs within the current benefit record number are included in the calculation.

  • Primary: Only the primary job within the current benefit record number is included in the calculation.

Premium Calculation

Select the employee salary that will be used for the premium calculation. Choose from:

  • Cur/Chk Dt (current/check date): Indicates that PeopleSoft Payroll uses the pay end date to calculate premiums.

  • Last Yr On (last year on): Indicates a specific date last year. You must enter the month and day.

  • This Yr On (this year on): Indicates a specific date this year. You must enter the month and day.

Coverage Calculation

Select the employee salary that will be used for the coverage calculation.

Age As Of

Used to calculate rates for life plans that you associate with age-graded rates. If you don’t use the Age-Graded Rate Table, leave this field blank.

Service As Of

Used to calculate rates for plans that you base on years of service. If you don’t use the Service Rate Table, leave this field blank.

Age Source

Designate whose personal information that you want to use. Choose from Dependent, Employee, or Spouse.

The system only uses dependent age and demographic information for Dependent Life plans that are designated as Sum of Dependent Coverage. A Flat Amount or Factor Plus Base Dependent Life plan typically has a premium that is based not on the number or demographics of the dependents covered, but on the coverage amount. Flat Amount and Factor Plus Base Dependent Life plans should therefore only use employee or spouse demographics.

If the system cannot locate a birth date for a dependent or spouse, it generates a warning that a birth date was not located and uses the employee’s age instead, while still retaining the dependent’s sex and smoker status.

Coverage Minimum

Enter the minimum amount of coverage an employee can receive for individual plans with this set of calculation rules. The system does not round over or under these amounts.

Coverage Maximum

Enter the maximum amount of coverage an employee can receive for individual plans with this set of calculation rules. The system does not round this amount.

If you use the Coverage Group Table to define a coverage group maximum for one or more life and AD/D plans that you link with this set of calculation rules, the system may force a lower minimum for the employee than the one that you enter here because the system calculates the coverage group maximum last.

If you are using calculation rules for general credits and if you enter a coverage maximum, PeopleSoft Enterprise Benefits Administration will limit employee salary to that coverage maximum before calculating credits. If you do not want to limit the salary, leave the Coverage Maximum field blank.

Maximum Benefit Base

Enter an amount to limit the portion of an employee’s salary that is used to calculate the premium and coverage amounts.

This field is no longer used for the 401(a)(17) limit, which is now defined on the Limit table.

Add Flat Amount Option

If you have set up a benefit plan where coverage is based upon a Factor x Benefit Base + Flat Amount, select how you want the flat amount applied. You can choose from:

  • After Fctr (after factor): Arranges the equation as (Factor × Salary) + (Flat amount).

  • Before Fctr (before factor): Arranges the equation as(Factor) × (Salary + Flat Amount).

Max Deduction % of Gross Pay (maximum deduction percentage of gross pay)

If you have employees in Hawaii, state laws mandate that employers charge no more than 1.5% of gross wages for employee-only coverage.

Use this field to establish a calculation rule with the maximum deduction percent of gross pay set to a value of 1.5 or lower. This rule will be attached to the cost row of the benefit plan coverage code associated with employee-only coverage.

This deduction calculation is performed when:

  • The Pay Calculation process is being run.

  • The plan type is Health.

  • The coverage code is Employee Only.

  • The calculation rule ID is defined.

  • The values for maximum percent of gross pay, deductions, and gross pay are all greater than zero.

The maximum deduction percent of gross pay calculation looks like this:

Deduction = (Max Percent of Gross Pay) × (Federal Taxable Gross Pay) ÷ 100.

The smaller deduction appears on the paycheck.

Source for Benefits Base

Designate the rate of pay used to make calculations. Select either:

  • Annual Rate to use the regular compensation base entered on the Job Data - Compensation page.

  • Annual Benefits Base Rate to use the ABBR entered on the ABBR Update page.

    ABBRs are defined on the ABBR Type Table.

Note. For federal users, ABBR corresponds to the Total Pay field on the Expected Pay page of the PAR Compensation Data component.

Round Up On

Enter the amount to round up on.

Round to Multiple of

Enter the multiple that you want to round to.

For example, if the benefits base rate for an employee is 46,746 USD and you enter 1,000 in the Round to Multiple of field and 500 in the Round Up On field, the system calculates and rounds coverage for the employee as follows:

46746 ÷ 1000 = 46, with a remainder of 746.

746 is greater than 500, so 46 + 1 = 47.

47 × 1000 = 47,000 coverage amount.

Round Benefits Base

Rounds the benefit base according to the rules set up in the Round Up On and Round to Multiple of fields before performing any other calculation.

Use this option when pay is equal to the benefits base with no flat amount added.

Round Factored Benefits Base Before Adding Flat Amount

Rounds the factored benefits base according to the rules set up in the Round Up On and Round to Multiple of fields before adding a flat amount.

Displayed only if you select After Fctr in the Add Flat Amount Option field.

Round Final Calculated Covrg (round final calculated coverage)

Select to round the final coverage amount according to the rules set up in the Round Up On and Round to Multiple of fields.

Click to jump to top of pageClick to jump to parent topicSetting Up Deduction Codes

The Base Benefits business process in Human Resources is designed to work with PeopleSoft Enterprise Payroll for North America and PeopleSoft Enterprise Payroll Interface. Calculating deductions accurately is an important payroll function.

To set up benefit deductions:

The Deduction Table component enables you to select a plan type, enter a deduction code, and set up the deduction processing rules that enable you to specify processing details such as deduction priorities, deduction tax classifications, deduction pay period schedules, and other special payroll process indicators. The Benefit Program Table component enables you to set up the deduction calculation rules, actual rates, rules, and routines used to determine the cost of the deduction. To calculate benefit deductions, payroll uses both the deduction processing rules from the Deduction Table component and deduction calculation rules from the Benefit Program Table.

Note. To set up the Benefit Program Table, you must enter deduction codes. Deduction codes are set up on the Deduction Table component through either Payroll for North America or Payroll Interface. However, if you are not using a PeopleSoft payroll application to calculate deductions, you can set up dummy deduction codes using other pages in Human Resources.

Designing a Deduction Strategy

When setting up deduction you need to make some basic decisions about your strategy before you set up deduction rules, and these decisions depend in part upon how you want to report deductions to employees.

Here’s a quick reference that shows the basic benefit deduction pay stub reporting options and how to make them happen:

You Want To Report

Do This

Result on Pay Stubs

The amount for each benefit plan.

Define a deduction code for each benefit plan.

Itemized descriptions and deduction amounts appear for each chosen plan type.

One total for a plan type.

Define a deduction code for a specific plan type.

 

One total for all deductions.

Modify your pay check print program to print the total deduction for several plan type series.

For example, you might print the total deductions for all health and life plan type series, while still showing a separate deduction for a savings plan, like 401(k).

You must modify your system because you can’t automatically “roll up” to a higher level than plan type.

The total deduction of all plan types you modify appears.

Click to jump to top of pageClick to jump to parent topicPage Used to Set Up Deduction Codes

Page Name

Object Name

Navigation

Usage

Deduction Table - Setup

DEDUCTION_TABLE1

Set Up HRMS, Product Related, Payroll for North America, Deductions, Deduction Table, Setup

Set Up HRMS, Product Related, Payroll Interface, Deductions, Deduction Table, Setup

Define deduction processing, including priority, tax effect, and schedules.

Click to jump to top of pageClick to jump to parent topicCreating Deduction Codes

Access the Deduction Table - Setup page.

To create a deduction code, enter the effective date and the long description.

If you are using Payroll for North America or Payroll Interface, refer to the documentation for those products for information on how to set up the Deduction Table component (DEDUCTION_TABLE).

See PeopleSoft Enterprise Payroll for North America 8.9 PeopleBook

See PeopleSoft Enterprise Payroll Interface 8.9 PeopleBook

Click to jump to top of pageClick to jump to parent topicSetting Up Special Accumulators

Sometimes it is necessary to define an employee’s earnings based on specific types of earnings rather than total gross earnings. Special accumulators act like a bucket accumulating only the earning types you want included when determining the employee’s earnings.

Special accumulators are used during deduction calculations and limit testing. You might have a benefit deduction that you base on an earnings amount other than total gross.

For example, you might use a special accumulator to identify all the separate earnings to include when accumulating employee earnings for 401(k) deductions.

Typically, you want to define a special accumulator for qualified savings plans, such as 401(k) that are subject to limit testing.

You first name the special accumulator using the Special Accumulator Table. The next step is to tie specific earnings types to that special accumulator.

Click to jump to top of pageClick to jump to parent topicPages Used to Set Up Special Accumulators

Page Name

Object Name

Navigation

Usage

Special Accumulator Table

SPCL_EARNS_TABLE

Set Up HRMS, Product Related, Payroll for North America, Compensation and Earnings, Special Accumulator Table, Special Accumulator Table

Define special accumulator codes.

Click to jump to top of pageClick to jump to parent topicEntering Special Accumulators

Access the Special Accumulator Table page.

Click to jump to top of pageClick to jump to parent topicSetting Up Limits for Qualified Savings Plans

Certain qualified benefit savings plans may be subject to government regulations.

This section provides overviews of limits and discusses how to:

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

Limits are tied to deduction codes. When your payroll department runs the pay calculation process, the system checks to see whether a deduction has any limits associated with it. If it does, the system runs the testing calculations and makes the limit adjustments to every affected employee’s records. If a deduction cannot be taken, it is reported with the appropriate reason-not-taken code.

Click to jump to top of pageClick to jump to parent topicUnderstanding 401 Limit

The 401 limit is designed to eliminate the tax advantage highly compensated employees have by participating in qualified plans. This limit sets up a maximum cap on the employee’s annual earnings during the calculation of the employee’s contribution. When calculating the employee annual earnings, the 401 limit is applied against the Special Accumulator field defined on the Savings Plan tables, not on the Special Accumulator field on the Limit Table.

Click to jump to top of pageClick to jump to parent topicUnderstanding 402 Limit

The 402 limit imposes a flat dollar annual limit on the amount an employee can contribute as an elective deferral.

Click to jump to top of pageClick to jump to parent topicUnderstanding 403 Limit

The 403 limit defines the parameters that extend the maximum amount of the elective deferrals that an employee (with 15 or more years of service) in a qualifying organization can contribute to the 403(b) savings plans. In addition to the 403 limit, 403(b) savings plans are also subject to 401, 402, and 415 limits.

To calculate this amount:

  1. Multiply the employee’s eligible earnings by 20%.

  2. Multiply the figure by the employee’s total years of service.

  3. Subtract the prior year’s pretax contributions.

Click to jump to top of pageClick to jump to parent topicUnderstanding 415 Limit

The 415 limit restricts the total amount an employee can contribute to defined savings plans. 401(k) plans are the most common type of defined savings plans to fall under Section 415, but other types include profit-sharing, money purchase pensions, stock bonuses, thrift savings, and target benefit plans.

Employee year-to-date contributions cannot exceed either:

If, for a given payroll, the employee’s contribution exceeds the limits, the contribution must be reduced to fall within the limits.

Click to jump to top of pageClick to jump to parent topicUnderstanding 415Z Limit

This is identical to the 415 limit with the exception that it applies to 403(b) plans only.

Click to jump to top of pageClick to jump to parent topicUnderstanding 457 Limit

Section 457 plans are deferred compensation plans offered by state and local governments and employers that are exempt from federal income tax. The amount deferred annually by an employee cannot exceed a specific flat amount or 100% of the employee’s taxable income, whichever is less.

Note. Section 457 plans are not qualified plans and are not subject to the tax code's nondiscrimination and related requirements. However, they are subject to deferral limits and mandatory distribution rules that apply to qualified plans.

Click to jump to top of pageClick to jump to parent topicUnderstanding Limit Extensions

Employees, who meet specific eligibility criteria and elect the applicable option, can increase their elective deferrals in savings plans subject to certain limits. The increase is handled with limit extensions, where, in general, the sum of the limit table amount and the extension amount are used instead of the limit table amount. Limit extensions are stored on the Savings Management (SAVINGS_MGT_EE) record.

The limit extensions are:

See Also

Managing Savings Plans

Click to jump to top of pageClick to jump to parent topicCommon Elements Used to Define Limits

Rollover Allowed

Select if you want any contribution amount that exceeds the limit to roll over to another plan type or tax class. The actual destination of the excess funds is defined on the Savings Plan Table.

Maximum Benefit Base

The amount you enter in this field is determined by IRS regulations. It determines the maximum cap on the employee’s annual earnings during the calculation of the employee’s contribution.

Maximum Yearly Deduction

Enter the flat cap on yearly contributions.

Special Accumulator

Used to determine which year-to-date and current employee earnings are eligible for limit testing.

Max Percent of Accumulator (maximum percentage of accumulator)

Enter the percentage amount to use when calculating the maximum amount the employee can contribute.

Deductions Subject to Limit

Select the deduction codes for any and all benefit plans that fall under the specified limit. This list should be as comprehensive as possible. Both general deductions and benefit plans may be specified.

To associate a limit to a deduction enter the plan type, benefit plan, general deduction code, and deduction class.

A single plan type may require more than one deduction classification. You may have to insert rows for after-tax, before-tax, nontaxable benefit, and nontaxable pre-tax benefit classifications for a single 401(k) plan.

Deductions Which Add to Spcl Accum (deductions which add to the special accumulator)

Enter deductions to add to the special accumulator. These are the taxable benefits that the IRS stipulates may be included in the calculation of the limits.

The system increases the employee’s eligible earnings by the total year-to-date plus the current amount of the taxable benefits you enter here before calculating the employee’s current limit.

To add a deduction to a special accumulator, enter the plan type, benefit plan, general deduction code, and deduction class.

Deductions Which Subtract From Spcl Accum (deductions which subtract from the special accumulator)

Enter the deductions that subtract from the special accumulator. These are deductions that the IRS stipulates must be excluded from the calculation of the limits. (Ordinarily, these are before-tax deductions, but you may encounter exceptions.)

The system reduces the employee’s eligible earnings by the total year-to-date plus current amount of the deductions you enter here before calculating the employee’s current limit.

For each taxable benefit, fill in the plan type, benefit plan, deduction code, and deduction class.

Click to jump to top of pageClick to jump to parent topicPage Used to Define Limits

Page Name

Object Name

Navigation

Usage

Limit Table

LIMIT_TBL1

Set Up HRMS, Product Related, Base Benefits, Rates and Rules, Limit Table, Limit Table

Identify the rules that apply to the 401, 402, 403, 415, and 457 limits.

Click to jump to top of pageClick to jump to parent topicSetting Up 401(a) Limits

Access the Limit Table page for 401(a) limits.

Click to jump to top of pageClick to jump to parent topicSetting Up 402(g) Limits

Access the Limit Table page for 402(g) limits.

Click to jump to top of pageClick to jump to parent topicSetting Up 403(b) Limits

Access the Limit Table page for 403(b) limits.

403(b) Service Prorated By

Select the proration method to use for the 403(b) service year calculation in the Projection process. This information is taken from the employee’s job record.

Alternative Limits Parameters and 402(g) Limits and Cap Expansions

All of these fields are determined by IRS regulations. Enter the current approved standards.

Click to jump to top of pageClick to jump to parent topicSetting Up 457 Limits

Access the Limit Table page for 457 limits.

Max Annual 457 Catch Up (maximum annual 457 catch up)

Section 457 plans have a catch-up rule. Within three years of retirement, a participant may increase the amount contributed to the savings plan. This field is determined by IRS regulations.

Click to jump to top of pageClick to jump to parent topicSetting Up Leave and Vacation Buy/Sell Earnings

Earnings types are the various ways in which an employee might receive income. The benefit-related earnings that most concern earnings types are leave plans and vacation buy/sell plans.

To have the system process these earnings during the payroll process, you’ll use the Earnings Table to create these codes. The Earnings Table stores the business rules that define how to calculate employee earnings.

Click to jump to top of pageClick to jump to parent topicSetting Up Payroll Information for Leave Accruals

This section assumes that your payroll department uses Payroll for North America. If your organization uses another payroll accounting system, you’ll need to ensure that the proper information is provided to the system for the correct processing of leave accruals. Follow these basic steps, making appropriate choices from your options.

  1. On the Earnings Table - Special Process page enter the leave plan type for the leave plan you’re defining in the Leave Plan Accrual group box.

  2. Select the appropriate Add To Accrual Balance check box.

    The Add To Accrual Balance selection is important during the PeopleSoft Payroll Confirm process. It enables you to indicate where the accrued hours will be posted as unprocessed data on the employee’s Leave Accruals pages.

    You can choose to add hours to the Taken, Service Hours, Adjusted, Bought, or Sold accumulators.

    The Leave Accrual process retrieves data from these sections to calculate the leave accrual award and the resulting leave accrual balance.

  3. Select Taken when you want these hours to reduce the accrual balance (as in taken vacation hours or sick hours—but not regular hours).

    Select Service Hours when the associated leave plans accrue a leave balance based upon the number of hours worked, and the hours for this earnings code should be considered in the accrual calculation.

    Select Adjusted to define a special Earnings Type that adjusts accrual balances by adding to or subtracting from employee accrual balances.

    Select Bought or Sold only when you are using this earning as the Vacation Buy or Vacation Sell earning.

See Also

Managing Leave Plans

Click to jump to top of pageClick to jump to parent topicSetting Up Vacation Buy and Sell Earnings

Organizations typically allow employees to buy or sell vacation once, at the beginning of a plan year, based on vacation buy and sell earnings, deduction, and benefit plan rules.

To set up vacation buy/sell earnings:

  1. Access the Earnings Table - Special Process page.

  2. For Vacation Buy plans, select Bought in the Add to Accrual Balance group box.

  3. For Vacation Sell plans, select Sold in the Add to Accrual Balance group box.

See Also

Managing Vacation Buy/Sell Plans