Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BNCOVOPT


                             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     BN106
BN19.1    BN19.2    BN215     BN230     BN231     BN232
BN233     BN242     BN245     BN31.1    BN31.2    BN32.1
BN32.2    BN32.3    BN320     BN321     BN331     BN51.1
BN51.2    BN53.1    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
Element: Company       Contains the company number.

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

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

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

COP-STUDENT-AGE        Numeric 2                                 BN17.1
Element: 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
Element: Dependent Age If a coverage option provides coverage
                       for dependents, this field contains the
                       dependent's age.

COP-COV-DEPENDENTS     Alpha 1                                   BN17.1
Element: Cov DependentsIndicates 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
Element: Status        Contains the Active flag of the
                       coverage option.
                       A = Active
                       I = Inactive

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

                         BNCOVOPT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

COPSET1   COMPANY                                                BN100   BN101
          PLAN-TYPE                                              BN102   BN103
          PLAN-CODE                                              BN105   BN106
          COVERAGE-OPT                                           BN15.1  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  BN320
                                                                 BN321   BN331
                                                                 BN51.1  BN51.2
                                                                 BN53.1  BN531
                                                                 ...

                         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