Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BNCOVERAGE


                            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    BN320     BN331     BN340
BN45.1    BN53.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
Element: Company       Contains the company number.

CVR-PLAN-TYPE          Alpha 2                                   BN17.3
Element: 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
Element: Plan          Contains the user-defined code that
                       represents a benefit plan.

CVR-GROUP-NAME         Alpha 10                                  BN17.3
Element: 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
Element: Date          Contains the date the coverage
                       parameters begin.

CVR-CALC-TYPE          Alpha 1                                   BN17.3
Element: Calculation TyDefines 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
Element: Covered IndiviContains 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
Element: 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
Element: 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  BN320
Element: 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  BN320
Element: 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
Element: 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
Element: Multiple of SaIf 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
Element: Percent of SalIf 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
Element: 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
Element: 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
Element: 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
Element: Rounding MethoIf 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: Cov Round MethIf 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: Salary Year   Contains the year if salary
                       calculations are based on a specific
                       year.

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

CVR-BENEFIT-PCT        Signed 5.2                                BN17.3  BN65.1
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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  BN320
                                                                 BN331   BN340
                                                                 BN45.1  BN53.1
                                                                 BN531   BN532
                                                                 BN65.1  BN71.1
                                                                 BN72.1  BS09.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  BN320
                                                                 BN331   BN340
                                                                 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 PLN-COVERAGE-TYPE = "0 "

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

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

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

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

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

Coverage User  PLAN         Required
                            When PLN-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