Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             BNCOVDFT FILE

                       Benefit Coverage Defaults

The Benefits Coverage Defaults defines which benefit options are currently
valid for each employee group.

REFERENCED BY

BN100     BN101     BN102     BN103     BN145     BN215
BN220     BN245     BN31.1    BN31.2    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    HR55.1    PRBN.1

UPDATED BY

BN105     BN15.1    BN17.1    BN17.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

BCD-COMPANY          Numeric 4                                   BN17.1  BN17.2
Company              Contains the company number.

BCD-PLAN-TYPE        Alpha 2                                     BN17.1  BN17.2
Type                 Indicates the default 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

BCD-PLAN-CODE        Alpha 4                                     BN17.1  BN17.2
Plan                 Contains the user-defined code that
                     represents the benefit plan.

BCD-START-DATE       Numeric 8  (yyyymmdd)                       BN17.1  BN17.2
Start Date           Contains the start date for the
                     coverage options.

BCD-GROUP-NAME       Alpha 10                                    BN17.1  BN17.2
Group Name           Contains the employee group for which
                     the coverage option applies.

BCD-COVERAGE-OPT     Numeric 2                                   BN17.1  BN17.2
Coverage Opt         Contains the coverage option used at
                     benefit entry.

BCD-COVERAGE-DFT     Alpha 1                                     BN17.1  BN17.2
Coverage Dft         Indicates whether this is default
                     coverage.
                     Y = Yes
                     N = No

BCD-ACTIVE-FLAG      Alpha 1                                     BN17.1  BN17.2
Status               Indicates if the coverage option is
                     active for the group.
                     A = Active
                     I = Inactive

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

BCD-STATUS           Numeric 1                                   BN105   BN17.1
Status               Contains the employee status.               BN17.2

                     If a Benefits Coverage Default record
                     is added and no employee benefits exists
                     or if BN105 (Plan Update) is updated,
                     the status is updated.

                     When PR140 (Earnings and Deductions
                     Calculation) is run for a payment date,
                     BN105 must also be run to update
                     employee benefits 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

BCD-RET-STATUS       Numeric 1                                   BN105   BN17.1
Retiree Cov Default  Contains the retiree status.                BN17.2
Status
                     When PR180 (Manual Payment Print) is
                     run for a payment date, BN105 must also
                     be run to update employee benefits 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

BCD-COBRA-STATUS     Numeric 1                                   BN105   BN17.1
COBRA Coverage       Contains the COBRA status.                  BN17.2
Default Status
                     When PR180 (Manual Payment Print) is
                     run for a payment date, BN105 must also
                     be run to update employee benefits 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

                         BNCOVDFT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BCDSET1   COMPANY                                                BN100   BN101
          PLAN-TYPE                                              BN102   BN103
          PLAN-CODE                                              BN105   BN145
          COVER-TYPE                                             BN15.1  BN17.1
          START-DATE                                             BN17.2  BN215
          GROUP-NAME                                             BN220   BN245
          COVERAGE-OPT                                           BN31.1  BN31.2
                                                                 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
                                                                 ...

BCDSET2   COMPANY       Subset                                   BN100   BN101
          PLAN-TYPE     Where (ACTIVE-FLAG  = "A" )              BN102   BN103
          PLAN-CODE     And   (COVERAGE-DFT = "Y" )              BN105   BN145
          COVER-TYPE                                             BN17.2  BN245
          START-DATE*                                            BN31.1  BN31.2
          GROUP-NAME                                             BN32.1  BN32.2
          COVERAGE-OPT                                           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

BCDSET3   COMPANY                                                BN17.1
          PLAN-TYPE
          PLAN-CODE
          COVERAGE-OPT
          COVER-TYPE
          START-DATE
          GROUP-NAME

BCDSET4   COMPANY                                                BN100   BN101
          PLAN-TYPE                                              BN102   BN103
          PLAN-CODE                                              BN105   BN145
          COVER-TYPE                                             BN245   BN31.1
          START-DATE*                                            BN31.2  BN32.1
          GROUP-NAME                                             BN32.2  BN32.3
          COVERAGE-OPT                                           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

BCDSET5   COMPANY                                                BN17.1  BN17.2
          PLAN-TYPE
          PLAN-CODE
          COVER-TYPE
          GROUP-NAME
          START-DATE*
          COVERAGE-OPT

                         BNCOVDFT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Bncovopt       BNCOVOPT     Required

                            BCD-COMPANY         -> COP-COMPANY
                            BCD-PLAN-TYPE       -> COP-PLAN-TYPE
                            BCD-PLAN-CODE       -> COP-PLAN-CODE
                            BCD-COVERAGE-OPT    -> COP-COVERAGE-OPT

Persgroup      PERSGROUP    Not Required

                            BCD-COMPANY         -> PRG-COMPANY
                            BCD-GROUP-NAME      -> PRG-GROUP-NAME

Plan           PLAN         Required

                            BCD-COMPANY         -> PLN-COMPANY
                            BCD-PLAN-TYPE       -> PLN-PLAN-TYPE
                            BCD-PLAN-CODE       -> PLN-PLAN-CODE

Prsystem       PRSYSTEM     Required

                            BCD-COMPANY         -> PRS-COMPANY
                            Spaces              -> PRS-PROCESS-LEVEL