Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms

BN02


BN02.1 - Age Rate Table

**Form Purpose
Use Age Rate Table (BN02.1) to define contribution amounts based on age.

**Processing Effect
The application calculates the contribution using either an amount or percent.

**More Information
When you assign a rate table to a benefit plan's contribution record, the
rate table's start date must match the start date of the contribution record.

You can use age rate tables for employee, COBRA participant, and retiree
contributions.

You can assign age rate tables to contributions in the following forms:

- BN18.2 (Options Amount Range),

- BN18.3 (Flat Contribution), and

- BN18.4 (Salary or Coverage Rate Table).




Updated Files

    BNCOVERAGE - The Premium Option file is updated to indicate premium changes

    PREMIUM    - The Benefit Plan Premium file is accessed by this program.

    RATETBLDTL - The Rate Table Detail file is accessed by this program.

    RATETBLHDR - The Rate Table Header file is used to verify rate table codes.


Referenced Files

    BENEFIT    - The Employee Benefit file contains employee benefit records
                 for all benefit types.

                 The Benefits file is accessed to verify the plans.

    BNCOMPANY  - The Benefit Company Parameters file is used to verify company
                 information.

    BNPRMOPT   - The Premium Option file is updated to indicate premium changes.

    FLEXDOLLAR - The Flex Dollars file is used to verify flex dollar records.

    PARTBEN    - The COBRA Participant Benefits file ensures records are not
                 deleted if COBRA participant benefits exist.

    PRSYSTEM   - The HR Company and Process Levels file is used to verify
                 company information.


BN02.2 - Salary Rate Table

**Form Purpose
Use Salary Rate Table (BN02.2) to define contribution amounts based on salary.

The application calculates the contribution using either an amount or percent.

When you assign a rate table to a benefit plan's contribution record, the
rate table's start date must match the start date of the contribution record.

Salary rate tables are not valid for COBRA participant and retiree
contributions.

You can assign salary rate tables to contributions in the following forms:

- BN18.2 (Options Amount Range),

- BN18.3 (Flat Contribution), and

- BN18.4 (Salary or Coverage Rate Table).




Updated Files

    BNCOVERAGE - The Premium Option file is updated to indicate premium changes.

    PREMIUM    - The Premium file is updated to indicate a rate change.

    RATETBLDTL - The Rate Table Detail file is updated.

    RATETBLHDR - The Rate Table Header file is used to determine the rate table
                 and retrieve rate information.


Referenced Files

    BENEFIT    - The Employee Benefit file contains employee benefit records
                 for all benefit types.

                 The Benefit file is accessed to verify the plans.

    BNCOMPANY  - The Benefit Company file is accessed to verify the benefit
                 company.

    BNPRMOPT   - The Premium Option file is updated to indicate premium changes.

    FLEXDOLLAR - The Flex Dollars file is used to verify flex dollar records.

    PARTBEN    - The COBRA Participant Benefits file ensures records are not
                 deleted if COBRA participant benefits exist.

    PRSYSTEM   - The HR Company and Process Levels file is used to verify the
                 company.


BN02.3 - Service Rate Table

**Form Purpose
Use Service Rate Table (BN02.3) to define contribution amounts based on years
of service.

**Processing Effect
The application calculates the contribution using either an amount or percent.

**More Information
When you assign a rate table to a benefit plan's contribution record, the
rate table's start date must match the start date of the contribution record.

Service rate tables are not valid for COBRA participant and retiree
contributions.

You can assign service rate tables to contributions in the following forms:

- BN18.2 (Options Amount Range),

- BN18.3 (Flat Contribution), and

- BN18.4 (Salary or Coverage Rate Table).




Updated Files

    BNCOVERAGE - The Premium Option file is updated to indicate premium changes.

    PREMIUM    - The Benefit Plan Premium file is updated to indicate a rate
                 change.

    RATETBLDTL - The Rate Table Detail file is updated.

    RATETBLHDR - The Rate Table Header file is used to verify the rate table
                 and to retrieve table information.


Referenced Files

    BENEFIT    - The Employee Benefit file contains employee benefit records
                 for all benefit types.

                 The Employee Benefit file is accessed to verify the plans.

    BNCOMPANY  - The Benefit Company file is accessed to verify the benefit
                 company.

    BNPRMOPT   - The Premium Options file is updated to indicate premium
                 changes.

    FLEXDOLLAR - The Flex Dollars file is used to verify flex dollar records.

    PARTBEN    - The COBRA Participant Benefits file ensures records are not
                 deleted if COBRA participant benefits exist.

    PRSYSTEM   - The HR Company and Process Levels file is used to verify the
                 company.


BN02.4 - Credits Rate Table

**Form Purpose
Use Credits Rate Table (BN02.4) to define the number of flex credits
employees receive based on their number of dependents or their lifestyle
points.

**More Information
When you assign a rate table to a flex dollar record, the rate table's start
date must match the start date of the flex dollar record.

An employee's number of dependents and lifestyle points are defined in the
Benefits form tab of HR11.1 (Employee).

You assign credit rate tables to flex plans in the Dependents Credits and
Lifestyle Credits subforms of BN08.1 (Flex Credits).




Updated Files

    BNCOVERAGE - The Premium Option file is updated to indicate premium changes.

    PREMIUM    - The Premium file is updated to indicate a rate change.

    RATETBLDTL - The Rate Table Detail file is updated.

    RATETBLHDR - The Rate Table Header file is used to determine the rate table
                 and retrieve rate information.


Referenced Files

    BENEFIT    - The Employee Benefit file contains employee benefit records
                 for all benefit types.

                 The Benefit file is accessed to verify the plans.

    BNCOMPANY  - The Benefit Company file is accessed to verify the benefit
                 company.

    BNPRMOPT   - The Premium Option file is updated to indicate premium changes.

    FLEXDOLLAR - The Flex Dollars file is used to verify flex dollar records.

    PARTBEN    - The COBRA Participant Benefits file ensures records are not
                 deleted if COBRA participant benefits exist.

    PRSYSTEM   - The HR Company and Process Levels file is used to verify the
                 company.


BN02.5 - Coverage Reduction Table

**Form Purpose
Use Coverage Reduction Table (BN02.5) to define how coverage reduces as plan
participants get older.

**Processing Effect
If the plan specifies both a percent and an amount reduction, the application
uses the greater of the two.

**More Information
When you assign a rate table to a benefit plan's coverage record, the rate
table's start date must match the start date of the coverage record.

You assign coverage reduction tables to coverage records in the Coverage
Limits subform of BN17.3 (Coverage Amounts).




Updated Files

    BNCOVERAGE - The Premium Option file is updated to indicate premium changes.

    PREMIUM    - The Premium file is accessed to retrieve premium information.

    RATETBLDTL - The Rate Table Detail file is updated.

    RATETBLHDR - The Rate Table Header file is used to determine the rate table
                 and retrieve rate information.


Referenced Files

    BENEFIT    - The Employee Benefit file contains employee benefit records
                 for all benefit types.

                 The Benefit file is accessed to verify the plans.

    BNCOMPANY  - The Benefit Company file is accessed to verify the benefit
                 company.

    BNPRMOPT   - The Premium Option file is accessed to verify the premium.

    FLEXDOLLAR - The Flex Dollars file is used to verify flex dollar records.

    PARTBEN    - The COBRA Participant Benefits file ensures records are not
                 deleted if COBRA participant benefits exist.

    PLAN       - The Plan file is accessed to retrieve plan codes and to
                 determine if a plan is a flex plan.

    PRSYSTEM   - The HR Company and Process Levels file is used to verify the
                 company.


INVOKED Programs

    IFCU
    IFSG