Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BNBEN


                               BNBEN FILE

REFERENCED BY

BN305     HR511     PA02.1    PA100     PA102     PA13.1
PA13.2    PA502     PA513     PA52.1    PA52.3    PA52.4
PA52.5    PR110     PR113     PR120     PR13.1    PR13.5
PR13.6    PR13.8

UPDATED BY

BS31.1    BS531     HR11.1    PA115

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

BNB-COMPANY            Numeric 4                                 BS31.1
Element: Company Hr

BNB-EMPLOYEE           Numeric 9                                 BS31.1
Element: Employee      Contains the employee number. Each
                       person employed by the company is
                       assigned a unique number. The system
                       uses the employee number to correlate
                       all of the information related to that
                       person.

BNB-PLAN-TYPE          Alpha 2                                   BS31.1
Element: Plan Type

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

BNB-START-DATE         Numeric 8  (yyyymmdd)                     BS31.1
Element: Start Date

BNB-FC                 Alpha 1                                   BS31.1
Element: Fc

BNB-ENROLL-DATE        Numeric 8  (yyyymmdd)
Element: Enroll Date

BNB-COVER-OPT          Numeric 2                                 BS31.1
Element: Cover Opt

BNB-MULT-SALARY        Signed 6.3                                BS31.1
Element: Mult Salary

BNB-COVER-AMT          Signed 11.2                               BS31.1
Element: Cover Amt

BNB-PAY-RATE           Signed 13.4                               BS31.1
Element: Pay Rate

BNB-PCT-AMT-FLAG       Alpha 1                                   BS31.1
Element: Pct Amt Flag

BNB-PRE-AFT-FLAG       Alpha 1                                   BS31.1
Element: Pre Aft Flag

BNB-SMOKER-FLAG        Alpha 1                                   BS31.1
Element: Smoker Flag

BNB-EMP-PRE-CONT       Signed 11.2                               BS31.1
Element: Emp Pre Cont

BNB-EMP-AFT-CONT       Signed 11.2                               BS31.1
Element: Emp Aft Cont

BNB-STOP-DATE          Numeric 8  (yyyymmdd)                     BS31.1
Element: Stop Date

BNB-PEND-EVIDENCE      Alpha 1
Element: Pend Evidence

BNB-YTD-CONT           Signed 13.2
Element: Ytd Cont

BNB-RCD-TYPE           Numeric 2                                 BS31.1
Element: Rcd Type

BNB-PLAN-GROUP         Alpha 20                                  BS31.1
Element: Plan Group

BNB-COP-COV-DESC       Alpha 15                                  BS31.1
Element: Cop Cov Desc

BNB-DEP-COVER-AMT      Signed 11.2                               BS31.1
Element: Dep Cover Amt

BNB-COV-PCT            Signed 5.2                                BS31.1
Element: Cov Pct

BNB-FLEX-COST          Signed 9.2                                BS31.1
Element: Flex Cost

BNB-EMP-COST           Signed 9.2                                BS31.1
Element: Emp Cost

BNB-COMP-COST          Signed 9.2                                BS31.1
Element: Comp Cost

BNB-UPDATE-DATE        Numeric 8  (yyyymmdd)                     BS31.1
Element: Update Date   This field contains the date the record
                       was updated.

BNB-ALPHADATA1         Alpha 1
Element: Alphadata1

BNB-NUMERIC1           Signed 15.4
Element: Numeric1

BNB-DATE1              Numeric 8  (yyyymmdd)
Element: Date1

BNB-PLAN-DESC          Alpha 30                                  BS31.1
Element: Plan Desc

BNB-CURRENCY-CODE      Alpha 5                                   BS31.1
Element: Currency Code This field contains the company base
                       currency code established in Company
                       (GL10.1 ).

BNB-CURR-ND            Numeric 1                                 BS31.1
Element: Acct Nd       The number of decimals assigned to a
                       particular account as determined by the
                       account currency.


BNB-CREATION-DATE      Numeric 8  (yyyymmdd)                     BS31.1
Element: Creation Date This is the date that this line was
                       added to the requisition.

BNB-UPD-DATE           Numeric 8  (yyyymmdd)                     BS31.1
Element: Upd Date

BNB-TIME-STAMP         Numeric 6  (hhmmss)                       BS31.1
Element: Time Stamp    Contains the server time (hour, minute,
                       and second) when the record was last
                       changed.

BNB-USER-ID            Alpha 10  (Lower Case)                    BS31.1
Element: User

BNB-CREATE-TRANS       Alpha 1                                   BS31.1
Element: Create Trans  Y = Yes
                       N = No

BNB-TRAN-REASON        Alpha 10                                  BS31.1
Element: Reason

BNB-MEMBER-ID          Numeric 1                                 BS31.1
Element: Member Id

BNB-BN-TYPE            Alpha 1                                   BS31.1
Element: Bn Type       Load pending employee actions by
                       specific Benefit Types of 1) New Hire,
                       2) Open Enrollment, 3) Life Event.
                       1 = Annual
                       2 = Life Event
                       3 = New Hire

                         BNBEN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BNBSET1   COMPANY                                                BN305   BS31.1
          EMPLOYEE                                               BS531   HR11.1
          PLAN-TYPE                                              HR11.2  HR511
          PLAN-CODE                                              PA02.1  PA100
          START-DATE                                             PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

                         BNBEN FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        BNCOMPANY    Required

                            BNB-COMPANY          -> BNC-COMPANY

Currency       CUCODES      Required

                            BNB-CURRENCY-CODE    -> CUC-CURRENCY-CODE

Employee       EMPLOYEE     Required

                            BNB-COMPANY          -> EMP-COMPANY
                            BNB-EMPLOYEE         -> EMP-EMPLOYEE

Plan           PLAN         Required

                            BNB-COMPANY          -> PLN-COMPANY
                            BNB-PLAN-TYPE        -> PLN-PLAN-TYPE
                            BNB-PLAN-CODE        -> PLN-PLAN-CODE

Reason Code    PCODES       Required
                            When BNB-TRAN-REASON != Spaces

                            "BT"                 -> PCO-TYPE
                            BNB-TRAN-REASON      -> PCO-CODE

                         BNBEN FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Depben         DEPBEN       Delete Restricted

                            BNB-COMPANY          -> DEP-COMPANY
                            BNB-EMPLOYEE         -> DEP-EMPLOYEE
                            BNB-PLAN-TYPE        -> DEP-PLAN-TYPE
                            BNB-PLAN-CODE        -> DEP-PLAN-CODE
                            BNB-START-DATE       -> DEP-EMP-START
                                                    DEP-DEPENDENT
                                                    DEP-START-DATE