Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             BNPRMOPT FILE

                        Benefit Premium Options

REFERENCED BY

BN02.1    BN02.2    BN02.3    BN02.4    BN02.5    BN100
BN101     BN102     BN103     BN105     BN215     BN245
BN31.1    BN31.2    BN32.1    BN32.2    BN32.3    BN531
BN65.1    BN71.1    BN72.1    BS13.1    BS14.1    BS15.1
BS32.1    HR55.1    PR197

UPDATED BY

BN15.1    BN17.1    BN18.1    BN18.2    BN18.3    BN18.4
BN18.5    BN18.6    BN18.7    BN19.1    BN19.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PCV-COMPANY          Numeric 4                                   BN15.1  BN17.1
Company              Contains the company number.                BN19.1  BN19.2

PCV-PLAN-TYPE        Alpha 2                                     BN15.1  BN17.1
Type                 Contains the plan type that identifies      BN19.1  BN19.2
                     the type of benefit.
                     HL = Health
                     DN = Dental
                     DI = Disability
                     EL = Life
                     DL = Dependent Life
                     DC = Defined Contribution
                     DB = Defined Benefit
                     VA = Vacation
                     RS = Spending Account
                     SB = Savings Bond
                     SP = Stock Purchase

PCV-PLAN-CODE        Alpha 4                                     BN15.1  BN17.1
Plan                 Contains the user-defined code that         BN19.1  BN19.2
                     represents a benefit plan.

PCV-GROUP-NAME       Alpha 10                                    BN15.1  BN17.1
Group Name           Contains the group that uses the            BN19.1  BN19.2
                     contribution record. This field may
                     contain spaces.

PCV-START-DATE       Numeric 8  (yyyymmdd)                       BN15.1  BN17.1
Start Date           Contains the start date for                 BN19.1  BN19.2
                     contribution.

PCV-COVERAGE-OPT     Numeric 2                                   BN15.1  BN17.1
Coverage Opt         Contains the coverage option with which     BN19.1  BN19.2
                     the contributions are associated.

PCV-EMP-CONT         Signed 7.2                                  BN15.1  BN17.1
Emp Cont             If the contribution type is the same as     BN19.1  BN19.2
                     the option amount, this is the employee     PR197
                     contribution.

PCV-COMP-CONT        Signed 7.2                                  BN15.1  BN17.1
Company Contribution If the contribution type is the same as     BN19.1  BN19.2
                     the option amount, this field contains
                     the company contribution.

PCV-FLEX-CONT        Signed 7.2                                  BN15.1  BN17.1
Flex Cont            If the contribution type is the same as     BN19.1  BN19.2
                     the option amount, this field contains
                     the flex credit contribution.

PCV-RATE-TABLE       Alpha 4                                     BN15.1  BN17.1
Rate Table           If the contribution type is the same as     BN19.1  BN19.2
                     the options amount range, this field
                     contains the rate table used for the
                     contribution.

PCV-E-RET-CONT       Signed 7.2                                  BN15.1  BN17.1
E Ret Cont           This field is not used.                     BN19.1  BN19.2

PCV-E-CO-CONT        Signed 7.2                                  BN15.1  BN17.1
E Co Cont            This field is not used.                     BN19.1  BN19.2

PCV-R-RET-CONT       Signed 7.2                                  BN15.1  BN17.1
R Ret Cont           This field is not used.                     BN19.1  BN19.2

PCV-R-CO-CONT        Signed 7.2                                  BN15.1  BN17.1
R Co Cont            This field is not used.                     BN19.1  BN19.2

PCV-COBRA-CONT       Signed 7.2                                  BN15.1  BN17.1
Cobra Cont           This field is not used.                     BN19.1  BN19.2

PCV-EARLY-RET-AGE    Numeric 2                                   BN15.1  BN17.1
Early Ret Age        This field is not used.                     BN19.1  BN19.2

PCV-REG-RET-AGE      Numeric 2                                   BN15.1  BN17.1
Reg Ret Age          This field is not used.                     BN19.1  BN19.2

PCV-TERM-AGE         Numeric 2                                   BN15.1  BN17.1
Termination Age      This field is not used.                     BN19.1  BN19.2

PCV-PREMIUM-CHG      Numeric 1                                   BN15.1  BN17.1
Premium Chg          This field is not used.                     BN19.1  BN19.2
                     0 = Not Updated
                     1 = Updated

PCV-ACTIVE-FLAG      Alpha 1                                     BN15.1  BN17.1
Status               Indicates if the option contribution is     BN19.1  BN19.2
                     active or inactive.
                     A = Active
                     I = Inactive

PCV-COVER-TYPE       Alpha 1                                     BN15.1  BN17.1
Cover Type           For each record, indicates if the           BN19.1  BN19.2
                     contribution type is for employees,
                     retirees, COBRA participants.
                     E = Employee
                     C = COBRA Participant
                     R = Retiree

                         BNPRMOPT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PCVSET1   COMPANY                                                BN02.1  BN02.2
          PLAN-TYPE                                              BN02.3  BN02.4
          PLAN-CODE                                              BN02.5  BN100
          COVER-TYPE                                             BN101   BN102
          START-DATE                                             BN103   BN105
          GROUP-NAME                                             BN15.1  BN17.1
          COVERAGE-OPT                                           BN18.1  BN18.2
                                                                 BN18.3  BN18.4
                                                                 BN18.5  BN18.6
                                                                 BN18.7  BN19.1
                                                                 BN19.2  BN215
                                                                 BN245   BN31.1
                                                                 BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 BN531   BN65.1
                                                                 ...

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

                         BNPRMOPT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Bncovopt       BNCOVOPT     Required

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

Company Name   PRSYSTEM     Required

                            PCV-COMPANY         -> PRS-COMPANY
                            Spaces              -> PRS-PROCESS-LEVEL

Persgroup      PERSGROUP    Not Required

                            PCV-COMPANY         -> PRG-COMPANY
                            PCV-GROUP-NAME      -> PRG-GROUP-NAME

Plan           PLAN         Required

                            PCV-COMPANY         -> PLN-COMPANY
                            PCV-PLAN-TYPE       -> PLN-PLAN-TYPE
                            PCV-PLAN-CODE       -> PLN-PLAN-CODE

Prsystem       PRSYSTEM     Required

                            PCV-COMPANY         -> PRS-COMPANY
                            Spaces              -> PRS-PROCESS-LEVEL

Ratetblhdr     RATETBLHDR   Not Required

                            PCV-COMPANY         -> RTH-COMPANY
                            PCV-RATE-TABLE      -> RTH-TABLE-CODE
                            PCV-START-DATE      -> RTH-START-DATE

                         BNPRMOPT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Premium        PREMIUM      Required

                            PCV-COMPANY         -> PRE-COMPANY
                            PCV-PLAN-TYPE       -> PRE-PLAN-TYPE
                            PCV-PLAN-CODE       -> PRE-PLAN-CODE
                                                   PRE-COVER-TYPE
                                                   PRE-START-DATE
                                                   PRE-GROUP-NAME

Ratetbldtl     RATETBLDTL

                            PCV-COMPANY         -> RTD-COMPANY
                            PCV-RATE-TABLE      -> RTD-TABLE-CODE
                            PCV-START-DATE      -> RTD-START-DATE
                                                   RTD-BEG-AGE-YR-SAL
                                                   RTD-SMOKER