Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BNPRMOPT


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

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

PCV-GROUP-NAME         Alpha 10                                  BN15.1  BN17.1
Element: 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
Element: Date          Contains the start date for               BN19.1  BN19.2
                       contribution.

PCV-COVERAGE-OPT       Numeric 2                                 BN15.1  BN17.1
Element: 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
Element: 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
Element: Company ContriIf 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
Element: 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
Element: 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
Element: E Ret Cont    This field is not used.                   BN19.1  BN19.2

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

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

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

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

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

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

PCV-TERM-AGE           Numeric 2                                 BN15.1  BN17.1
Element: Termination AgThis field is not used.                   BN19.1  BN19.2

PCV-PREMIUM-CHG        Numeric 1                                 BN15.1  BN17.1
Element: 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
Element: 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
Element: 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
          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