Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            BNCOVERAGE FILE

                            Benefit Coverage

The Benefit Coverage file contains coverage parameters for benefit plans with
a coverage type of Coverage Amount.

REFERENCED BY

BN100     BN101     BN102     BN103     BN145     BN150
BN220     BN232     BN242     BN245     BN31.1    BN31.2
BN32.1    BN32.2    BN32.3    BN331     BN45.1    BN531
BN532     BN65.1    BN71.1    BN72.1    BS09.1    BS10.1
BS11.1    BS12.1    BS13.1    BS14.1    BS15.1    BS32.1
HR13.2    HR13.3    HR13.4    HR55.1    PRBN.1    BN215

UPDATED BY

BN02.1    BN02.2    BN02.3    BN02.4    BN02.5    BN105
BN15.1    BN17.3

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

CVR-COMPANY          Numeric 4                                   BN17.3
Company              Contains the company number.

CVR-PLAN-TYPE        Alpha 2                                     BN17.3
Type                 Contains the plan type.
                     HL = Health
                     DN = Dental
                     DI = Disability
                     EL = Employee Life
                     DL = Dependent Life
                     DC = Defined Contribution
                     DB = Defined Benefit
                     VA = Vacation
                     RS = Spending Account
                     SB = Savings Bond
                     SP = Stock Purchase

CVR-PLAN-CODE        Alpha 4                                     BN17.3
Plan                 Contains the user-defined code that
                     represents a benefit plan.

CVR-GROUP-NAME       Alpha 10                                    BN17.3
Group Name           Contains the employee group for which
                     the coverage record applies.

                     If the group is blank, the system will
                     use this coverage record for all
                     employees who do not qualify for
                     coverage for a specific group.

CVR-START-DATE       Numeric 8  (yyyymmdd)                       BN17.3
Start Date           Contains the date the coverage
                     parameters begin.

CVR-CALC-TYPE        Alpha 1                                     BN17.3
Calculation Type     Defines how the coverage amount will be
                     determined for the plan.
                     F = Flat Amount
                     M = Multiple Salary
                     P = Percent
                     S = Supplemental
                     X = Custom Calculation

CVR-LIFE-ADD-FLG     Alpha 1                                     BN17.3
Covered Individual   Contains a value that determines who is
                     covered under the plan.

                     Employee is not a valid value for
                     Dependent Life plans. Spouse, Dependent,
                     and Both Spouse and Dependent are not
                     valid values for Employee Life plans.
                     E = Employee
                     S = Spouse
                     D = Dependent
                     B = Both Spouse and Dependent

CVR-STUDENT-AGE      Numeric 2                                   BN17.3
Student Age          Contains the age coverage terminates
                     for dependents who are flagged as
                     students. If the dependent is a student,
                     this age  overrides the dependent age.

CVR-DEP-AGE          Numeric 2                                   BN17.3
Dependent Age        If the plan covers dependents or
                     spouses and dependents, this field
                     contains the age dependent coverage
                     terminates for dependents if the
                     dependent is not flagged as a student.

CVR-FLAT-AMT-1       Signed 11.2                                 BN17.3
Flat Amt 1           For a plan with a calculation type of
                     flat amount, this is the flat amount of
                     coverage.  If a plan covers both spouses
                     and dependents, this is the spouse
                     coverage amount.

CVR-FLAT-AMT-2       Signed 11.2                                 BN17.3
Flat Amt 2           If the calculation type is flat amount
                     and the plan covers both spouses and
                     dependents, this is the dependent
                     coverage amount.

CVR-INCREMENTS       Signed 11.4                                 BN17.3
Increments           If the coverage calculation type is
                     supplemental, this field defines the
                     increments of coverage an employee may
                     elect.  Coverage under this plan will be
                     a multiple of this amount.

CVR-MULT-SALARY      Signed 5.3                                  BN17.3
Multiple of Salary   If the coverage calculation type is a
                     multiple of salary, this field defines
                     the valid multiples the employee may
                     elect.  Coverage under this plan will be
                     a multiple of this increment.

CVR-SALARY-PCT       Signed 5.2                                  BN17.3
Percent of Salary    If the coverage calculation type is a
                     percent, this the percent of the
                     employee's salary which will be used to
                     calculate coverage.

CVR-SALARY-TYPE      Alpha 2                                     BN17.3
Salary Type          If the coverage calculation type is a
                     percent of salary, a multiple of salary,
                     or if the coverage limit is a multiple
                     of salary, this field defines which
                     field is used to define the salary to be
                     used in calculations.
                     EM = HR11 Salary
                     B1 = Benefit Salary 1
                     B2 = Benefit Salary 2
                     B3 = Benefit Salary 3
                     B4 = Benefit Salary 4
                     B5 = Benefit Salary 5
                     E1 = HR11 and Ben Sal 1
                     E2 = HR11 and Ben Sal 2
                     E3 = HR11 and Ben Sal 3
                     E4 = HR11 and Ben Sal 4
                     E5 = HR11 and Ben Sal 5
                     X = User Exist

CVR-SALARY-DATE      Numeric 4  (mmdd)                           BN17.3
Salary Date          If the coverage is based on the
                     employee's salary, and the salary is
                     determined on a specific month and day,
                     this field contains the date the salary
                     is determined.

CVR-SAL-FIRST-MO     Alpha 1                                     BN17.3
Sal First Mo         If coverage is based on salary, and the
                     salary should be the salary in effect on
                     the first of the month for which a
                     benefit is created, the salary will be
                     flagged as first of month.

                     The As Of date is defined in the Salary
                     Date and Salary Year fields. The Flex
                     Calc date is the same as the date on
                     which flex dollars are calculated.
                     C = Current
                     M = First of Month
                     A = As Of Date
                     F = Flex Calc Date

CVR-ROUND-METH       Alpha 1                                     BN17.3
Rounding Method      If coverage is based on salary, this
                     field defines how the salary amount
                     should be rounded.
                     H = High
                     L = Low
                     N = No Rounding
                     R = Normal Rounding

CVR-BEF-AFT-FLAG     Alpha 1                                     BN17.3
Before/After         If the coverage amount is based on
                     salary this field defines whether the
                     salary amount should be rounded before
                     the coverage amount is calculated, or if
                     the coverage amount should be rounded
                     after the calculation is done.
                     B = Before
                     A = After

CVR-ROUND-TO         Signed 9.4                                  BN17.3
Round To             If the salary amount is rounded, this
                     defines to what place the amount is
                     rounded.

CVR-MIN-COVER        Signed 11.2                                 BN17.3
Min Cover            If a plan has a minimum coverage
                     amount, the minimum is contained in this
                     field. If the plan is a multiple of
                     salary or a percent, and the calculated
                     coverage amount is less than the
                     minimum, the minimum will be used. If
                     the plan is a supplemental plan and the
                     elected amount is less than the minimum,
                     the system will generate an error.

CVR-MAX-COVER        Signed 11.2                                 BN17.3
Maximum              If the plan has a maximum coverage
                     amount, the maximum is specified in this
                     field. If the plan is a multiple of
                     salary or a percent, and the calculated
                     amount is greater than the maximum, the
                     maximum amount will be used.  If the
                     plan is a supplemental plan, and the
                     employee elects more than the maximum,
                     the system will generate an error.

CVR-MIN-MULTIPLE     Signed 5.2                                  BN17.3  BS14.1
Min Multiple         If the plan is a multiple of salary, or
                     if the plan has a minimum which is
                     specified a multiple of salary, this is
                     the minimum multiple.

CVR-MAX-MULTIPLE     Signed 5.2                                  BN17.3
Max Multiple         If the plan is a multiple of salary or
                     if there is a limit defined as a
                     multiple of salary, this field defines
                     the maximum multiple.

CVR-RATE-TABLE       Alpha 4                                     BN17.3
Rate Table           If the plan specifies a reduction of
                     coverage at specific ages, this is the
                     rate table used to define the coverage
                     reduction parameters.

                     The table is defined in the Rate Table
                     Header file which uses the Coverage
                     Start Date and the Rate Table fields to
                     connect the records.

CVR-AGE-DATE         Numeric 4  (mmdd)                           BN17.3
Age Date             If the plan has a coverage reduction
                     table based on age, and the age is
                     determined on a specific date, the
                     employee or spouse's age on this date is
                     calculated.

CVR-AGE-FIRST-MO     Alpha 1                                     BN17.3
Age First Mo         If the plan has a coverage reduction at
                     specific ages, and the employee or
                     spouse's age should be calculated for
                     the first of each month, first of month
                     will be yes.
                     C = Current
                     M = First of Month
                     A = As of Date
                     F = Flex Calc Date

CVR-COV-ROUND-METH   Alpha 1                                     BN17.3
Cov Round Meth       If the coverage amount is to be
                     rounded, this defines coverage amount
                     should be rounded.
                     H = High
                     L = Low
                     N = No Rounding
                     R = Normal Rounding

CVR-COV-ROUND-TO     Signed 9.4                                  BN17.3
Cov Round To         If the coverage amounts are to be
                     rounded, this defines to what place the
                     amount is rounded.

CVR-DEFAULT-COVER    Alpha 1                                     BN17.3
Default Cover        Indicates whether this is default
                     coverage. If this is default coverage,
                     the coverage will default on all benefit
                     entry forms and all updates when a
                     benefit is automatically added.
                     Y = Yes
                     N = No

CVR-DEFAULT-AMT      Signed 11.2                                 BN17.3
Default Amt          Contains the default coverage for
                     employees who do not elect a coverage
                     amount. This is used for supplemental
                     plans only.

CVR-DEFAULT-MULT     Signed 5.2                                  BN17.3
Default Mult         If the default coverage flag is Yes,
                     and if the plan coverage is a multiple
                     of the salary, this field contains the
                     salary multiple.

CVR-COVERAGE-CHG     Numeric 1                                   BN02.5
Coverage Chg         Indicates that the coverage is changed.

                     If the coverage is Non Updated, BN105
                     (Plan Update) must be run before PR140
                     (Earnings and Deductions Calculation) is
                     run.
                     0 = Non Updated
                     1 = Updated

CVR-SALARY-YEAR      Numeric 4                                   BN17.3
Salary Year          Contains the year if salary
                     calculations are based on a specific
                     year.

CVR-AGE-YEAR         Numeric 4                                   BN17.3
Age Year             Contains the year if age calculations
                     are based on an age.

CVR-BENEFIT-PCT      Signed 5.2                                  BN17.3  BN65.1
Benefit Pct          If coverage is limited to a percent of
                     coverage under another benefit, this is
                     the percent limit.

CVR-BN-PLAN-TYPE     Alpha 2                                     BN17.3
Bn Plan Type         If coverage is limited to a percent of
                     coverage under another benefit, this
                     field contains the plan upon which
                     coverage limits are placed.
                     DB = Defined Benefit
                     DC = Defined Contribution
                     DI = Disability
                     DL = Dependent Life
                     DN = Dental
                     EL = Employee Life
                     HL = Health
                     RS = Spending Account
                     SB = Savings Bond
                     SP = Stock Purchase
                     VA = Vacation

CVR-BN-PLAN-CODE     Alpha 4                                     BN17.3
Bn Plan Code         If coverage is limited to a percent of
                     coverage under another benefit, this
                     field contains the plan code upon which
                     coverage limits are placed.

CVR-COVER-TYPE       Alpha 1                                     BN17.3
Cover Type           Indicates the coverage is for
                     employees, retirees, or COBRA
                     participants for each premium record.
                     E = Employees
                     R = Retirees
                     C = COBRA

CVR-STATUS           Numeric 1                                   BN02.1  BN02.2
Status               Contains the coverage status.               BN02.3  BN02.4
                                                                 BN02.5  BN105
                     When PR180 (Manual Payment Print) is        BN17.3
                     run for a payment date, BN105 must also
                     be run to update employee coverage
                     records if a record of
                     - New Group, New Date;
                     - Existing Group, New Date; or
                     - Change Existing Record
                     exists for any date before or on the
                     payment date.
                     0 = New Group New Date
                     1 = Existing Group New Date
                     2 = Change Existing Record
                     3 = Updated

CVR-RET-STATUS       Numeric 1                                   BN02.1  BN02.2
Retiree Premium      Indicates the retiree's coverage status.    BN02.3  BN02.4
Status               0 = New Group New Date                      BN02.5  BN105
                     1 = Existing Group New Date                 BN17.3
                     2 = Change Existing Record
                     3 = Updated

CVR-COBRA-STATUS     Numeric 1                                   BN02.1  BN02.2
Cobra Status         Contains the COBRA participant's status.    BN02.3  BN02.4
                     0 = New Group New Date                      BN02.5  BN105
                     1 = Existing Group New Date                 BN17.3
                     2 = Change Existing Record
                     3 = Updated

CVR-COVER-FREQ       Alpha 2
Cover Freq           This field is not used.
                     AN = Annual
                     MO = Monthly
                     SM = Semi-monthly
                     BW = Bi-weekly
                     WK = Weekly

                         BNCOVERAGE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CVRSET1   COMPANY                                                BN02.5  BN100
          PLAN-TYPE                                              BN101   BN102
          PLAN-CODE                                              BN103   BN105
          COVER-TYPE                                             BN145   BN15.1
          START-DATE                                             BN150   BN17.3
          GROUP-NAME                                             BN220   BN232
                                                                 BN242   BN245
                                                                 BN31.1  BN31.2
                                                                 BN32.1  BN32.2
                                                                 BN32.3  BN331
                                                                 BN45.1  BN531
                                                                 BN532   BN65.1
                                                                 BN71.1  BN72.1
                                                                 BS09.1  BS10.1
                                                                 BS11.1  BS12.1
                                                                 ...

CVRSET2   COMPANY                                                BN100   BN101
          PLAN-TYPE                                              BN102   BN103
          PLAN-CODE                                              BN105   BN145
          COVER-TYPE                                             BN215   BN245
          START-DATE*                                            BN31.1  BN31.2
          GROUP-NAME                                             BN32.1  BN32.2
                                                                 BN32.3  BN331
                                                                 BN45.1  BN531
                                                                 BN65.1  BN71.1
                                                                 BN72.1  BS09.1
                                                                 BS10.1  BS11.1
                                                                 BS12.1  BS13.1
                                                                 BS14.1  BS15.1
                                                                 BS32.1

CVRSET3   COMPANY       KeyChange                                BN02.1  BN02.2
          COVER-TYPE                                             BN02.3  BN02.4
          RATE-TABLE                                             BN02.5
          START-DATE
          PLAN-TYPE
          PLAN-CODE
          GROUP-NAME

CVRSET4   COMPANY                                                BN17.3
          PLAN-TYPE
          PLAN-CODE
          COVER-TYPE
          GROUP-NAME
          START-DATE*

                         BNCOVERAGE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Cov Limit Plan PLAN         Not Required

                            CVR-COMPANY         -> PLN-COMPANY
                            CVR-BN-PLAN-TYPE    -> PLN-PLAN-TYPE
                            CVR-BN-PLAN-CODE    -> PLN-PLAN-CODE

Coverage 0     PLAN         Required
                            When CVR-COVERAGE-TYPE = "0 "

                            CVR-COMPANY         -> PLN-COMPANY
                            CVR-PLAN-TYPE       -> PLN-PLAN-TYPE
                            CVR-PLAN-CODE       -> PLN-PLAN-CODE

Coverage 1     PLAN         Required
                            When CVR-COVERAGE-TYPE = "1 "

                            CVR-COMPANY         -> PLN-COMPANY
                            CVR-PLAN-TYPE       -> PLN-PLAN-TYPE
                            CVR-PLAN-CODE       -> PLN-PLAN-CODE

Coverage 2     PLAN         Required
                            When CVR-COVERAGE-TYPE = "2 "

                            CVR-COMPANY         -> PLN-COMPANY
                            CVR-PLAN-TYPE       -> PLN-PLAN-TYPE
                            CVR-PLAN-CODE       -> PLN-PLAN-CODE

Coverage User  PLAN         Required
                            When CVR-COVERAGE-TYPE = "X "

                            CVR-COMPANY         -> PLN-COMPANY
                            CVR-PLAN-TYPE       -> PLN-PLAN-TYPE
                            CVR-PLAN-CODE       -> PLN-PLAN-CODE

Persgroup      PERSGROUP    Not Required

                            CVR-COMPANY         -> PRG-COMPANY
                            CVR-GROUP-NAME      -> PRG-GROUP-NAME

Plan           PLAN         Required

                            CVR-COMPANY         -> PLN-COMPANY
                            CVR-PLAN-TYPE       -> PLN-PLAN-TYPE
                            CVR-PLAN-CODE       -> PLN-PLAN-CODE

Prsystem       PRSYSTEM     Required

                            CVR-COMPANY         -> PRS-COMPANY
                            Spaces              -> PRS-PROCESS-LEVEL

Ratetblhdr     RATETBLHDR   Required

                            CVR-COMPANY         -> RTH-COMPANY
                            CVR-RATE-TABLE      -> RTH-TABLE-CODE
                            CVR-START-DATE      -> RTH-START-DATE