Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             BNCOVOPT FILE

                        Benefit Coverage Options

The Benefit Coverage Options file defines the coverage options available for
a plan; for  example, single,  family, and so on. The Benefits Coverage
Options file is linked to the Benefits Coverage Defaults file, which further
defines valid  coverage options by date and by employee group.

Each coverage option is one record in this file.

REFERENCED BY

BN100     BN101     BN102     BN103     BN105     BN19.1
BN19.2    BN215     BN230     BN231     BN232     BN233
BN242     BN245     BN31.1    BN31.2    BN32.1    BN32.2
BN32.3    BN321     BN331     BN51.1    BN51.2    BN531
BN532     BN65.1    BN71.1    BN72.1    BN77.1    BS10.1
BS13.1    BS14.1    BS15.1    BS32.1    HCVO.1    HR13.2
HR13.3    HR13.4    HR170     HR70.1

UPDATED BY

BN15.1    BN17.1    BS04.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

COP-COMPANY          Numeric 4                                   BN17.1  BS04.1
Company              Contains the company number.

COP-PLAN-TYPE        Alpha 2                                     BN17.1  BS04.1
Type                 Indicates the benefits coverage 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

COP-PLAN-CODE        Alpha 4                                     BN17.1  BS04.1
Plan                 Contains the user-defined code that
                     represents a benefit plan.

COP-COVERAGE-OPT     Numeric 2                                   BN17.1  BS04.1
Coverage Opt         Contains the coverage option used when
                     benefits are entered.

COP-COV-DESC         Alpha 15  (Lower Case)                      BN17.1
Cov Desc             Contains a user-defined description of
                     the coverage option.

COP-STUDENT-AGE      Numeric 2                                   BN17.1
Student Age          If a coverage option provides coverage
                     for dependents and if the employee has a
                     dependent who is a student, this field
                     contains the student's age.

COP-DEP-AGE          Numeric 2                                   BN17.1
Dependent Age        If a coverage option provides coverage
                     for dependents, this field contains the
                     dependent's age.

COP-COV-DEPENDENTS   Alpha 1                                     BN17.1
Cov Dependents       Indicates whether the spouse,
                     dependents, spouse and dependents, or
                     neither are covered for this coverage
                     option.
                     S = Spouse
                     D = Dependents
                     B = Spouse and Deps
                     N = None

COP-ACTIVE-FLAG      Alpha 1                                     BN17.1
Status               Contains the Active flag of the
                     coverage option.
                     A = Active
                     I = Inactive

COP-NBR-DEPENDENTS   Numeric 2                                   BN17.1  BS04.1
Nbr Dependents

                         BNCOVOPT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

COPSET1   COMPANY                                                BN100   BN101
          PLAN-TYPE                                              BN102   BN103
          PLAN-CODE                                              BN105   BN15.1
          COVERAGE-OPT                                           BN17.1  BN17.2
                                                                 BN19.1  BN19.2
                                                                 BN215   BN230
                                                                 BN231   BN232
                                                                 BN233   BN242
                                                                 BN245   BN31.1
                                                                 BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 BN321   BN331
                                                                 BN51.1  BN51.2
                                                                 BN531   BN532
                                                                 BN65.1  BN71.1
                                                                 ...

                         BNCOVOPT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Plan           PLAN         Required

                            COP-COMPANY      -> PLN-COMPANY
                            COP-PLAN-TYPE    -> PLN-PLAN-TYPE
                            COP-PLAN-CODE    -> PLN-PLAN-CODE

Prsystem       PRSYSTEM     Required

                            COP-COMPANY      -> PRS-COMPANY
                            Spaces           -> PRS-PROCESS-LEVEL