Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BNPLNENR


                             BNPLNENR FILE

REFERENCED BY

BN100     BN101     BN102     BN103     BN105     BN145
BN232     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    BN15.1


UPDATED BY

BS02.1    BS03.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

BPE-COMPANY            Numeric 4                                 BS03.1
Element: Company Hr

BPE-PLAN-TYPE          Alpha 2                                   BS03.1
Element: Plan Type     DB = Defined Benefit
                       DC = Defined Contribution
                       DI = Disability
                       DL = Dependent Life
                       EL = Employee Life
                       HL = Health
                       RS = Spending Account
                       SB = Savings Bond
                       SP = Stock Purchase
                       VA = Vacation

BPE-PLAN-CODE          Alpha 4                                   BS03.1
Element: Plan Code     Contains the user-defined code that
                       represents a benefit plan.

BPE-PROCESS-LEVEL      Alpha 5                                   BS03.1
Element: Process Lev Hr

BPE-GROUP-NAME         Alpha 10                                  BS03.1
Element: Group Name

BPE-PLAN-GROUP         Alpha 20                                  BS03.1
Element: Plan Group

BPE-PROCESS-ORDER      Numeric 2                                 BS02.1  BS03.1
Element: Process Order

BPE-ANNUAL-ENROLL      Alpha 1
Element: Annual Enroll Y = Yes
                       N = No

BPE-LIFE-EVENT         Alpha 1
Element: Life Event    M = Marriage
                       D = Divorce
                       B = Birth
                       A = Adoption

BPE-INQUIRY            Alpha 1
Element: Inquiry       Y = Yes
                       N = No

BPE-CHANGE             Alpha 1
Element: Change        Y = Yes
                       N = No

BPE-HIRE               Alpha 1
Element: Hire          Y = Yes
                       N = No

BPE-EMPLOYEE-COST      Alpha 1                                   BS03.1
Element: Employee Cost E = Employee Only
                       F = Flex Only
                       B = Both Employee and Flex
                       T = Total of Employee and Flex

BPE-COMPANY-COST       Alpha 1                                   BS03.1
Element: Company Cost  Y = Yes
                       N = No

BPE-DEP-BENEFITS       Alpha 1                                   BS03.1
Element: Dep Benefits  Y = Yes
                       N = No

BPE-BENEFICIARY        Alpha 1
Element: Beneficiary   Y = Yes
                       N = No

BPE-CO-PROVIDED        Alpha 1
Element: Co Provided   Y = Yes
                       N = No

BPE-DATE-1             Numeric 8  (yyyymmdd)
Element: Date 1

BPE-DATE-2             Numeric 8  (yyyymmdd)
Element: Date 2

BPE-MISC-1             Alpha 10
Element: Misc 1

BPE-MISC-2             Alpha 10
Element: Misc 2

BPE-CREATE-TRANS       Alpha 1                                   BS03.1
Element: Create Trans  Y = Yes
                       N = No

BPE-DEFAULT-REASON     Alpha 10 Occurs 3 Times                   BS03.1
Element: Reason

BPE-REASON-1           Derived
Element: Reason 1

                         BNPLNENR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BPESET1   COMPANY                                                BN100   BN101
          PROCESS-LEVEL                                          BN102   BN103
          GROUP-NAME                                             BN105   BN145
          PLAN-GROUP                                             BN232   BN245
          PLAN-TYPE                                              BN31.1  BN31.2
          PLAN-CODE                                              BN32.1  BN32.2
                                                                 BN32.3  BN320
                                                                 BN331   BN340
                                                                 BN45.1  BN531
                                                                 BN65.1  BN71.1
                                                                 BN72.1  BS03.1
                                                                 BS09.1  BS10.1
                                                                 BS11.1  BS12.1
                                                                 BS13.1  BS14.1
                                                                 BS15.1  BS32.1

BPESET2   COMPANY                                                BS10.1  BS12.1
          PROCESS-LEVEL
          GROUP-NAME
          PROCESS-ORDER
          PLAN-TYPE
          PLAN-CODE

BPESET3   COMPANY                                                BS03.1  BS13.1
          PROCESS-LEVEL                                          BS14.1  BS15.1
          GROUP-NAME
          PLAN-TYPE
          PLAN-CODE

BPESET4   COMPANY                                                BS02.1
          PROCESS-LEVEL
          PLAN-GROUP
          GROUP-NAME
          PLAN-TYPE
          PLAN-CODE

BPESET5   COMPANY                                                BN15.1
          PLAN-TYPE
          PLAN-CODE
          PROCESS-LEVEL
          GROUP-NAME
          PLAN-GROUP

                         BNPLNENR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Bncompany      BNCOMPANY    Required

                            BPE-COMPANY           -> BNC-COMPANY

Employee Group PERSGROUP    Required

                            BPE-COMPANY           -> PRG-COMPANY
                            BPE-GROUP-NAME        -> PRG-GROUP-NAME

Plan           PLAN         Required

                            BPE-COMPANY           -> PLN-COMPANY
                            BPE-PLAN-TYPE         -> PLN-PLAN-TYPE
                            BPE-PLAN-CODE         -> PLN-PLAN-CODE

Plan Group     BNPLNGROUP   Required

                            BPE-COMPANY           -> BPG-COMPANY
                            BPE-PLAN-GROUP        -> BPG-PLAN-GROUP

Prsystem       PRSYSTEM     Required

                            BPE-COMPANY           -> PRS-COMPANY
                            Spaces                -> PRS-PROCESS-LEVEL

Reason Code    PCODES       Required
                            When BPE-REASON-1 != Zeroes

                            "BT"                  -> PCO-TYPE
                            BPE-DEFAULT-REASON    -> PCO-CODE