Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BNCOVDFT


                             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    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    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
Element: Company       Contains the company number.

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

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

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

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

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

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

BCD-COVER-TYPE         Alpha 1                                   BN17.1  BN17.2
Element: 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
Element: 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  BN320
                                                                 BN331   BN340
                                                                 BN45.1  BN531
                                                                 BN65.1  BN71.1
                                                                 BN72.1  BS09.1
                                                                 BS10.1  BS11.1
                                                                 BS12.1  BS13.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  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

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                                           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

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