Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BNBEN


                               BNBEN FILE

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

BNB-FC                 Alpha 1
Element: Fc

BNB-COMPANY            Numeric 4
Element: Company

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

BNB-EMPLOYEE           Numeric 9
Element: Employee

BNB-PLAN-TYPE          Alpha 2
Element: Plan Type

BNB-PLAN-CODE          Alpha 4
Element: Plan Code

BNB-COVER-OPT          Numeric 2
Element: Cover Opt

BNB-MULT-SALARY        Signed 5.3
Element: Mult Salary

BNB-COVER-AMT          Signed 11.2
Element: Cover Amt

BNB-PAY-RATE           Signed 13.4
Element: Pay Rate

BNB-PCT-AMT-FLAG       Alpha 1
Element: Pct Amt Flag  A = Amount
                       P = Percent

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

BNB-PRE-AFT-FLAG       Alpha 1
Element: Pre Aft Flag  A = After-tax
                       P = Pre-tax
                       B = Both

BNB-SMOKER-FLAG        Alpha 1
Element: Smoker Flag   Y = Yes
                       N = No

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

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

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

BNB-PEND-EVIDENCE      Alpha 1
Element: Pend Evidence A = Approved
                       P = Pending
                       N = No

BNB-YTD-CONT           Signed 11.2
Element: Ytd Cont

BNB-RECORD-TYPE        Numeric 2
Element: Record Type   This field identifies the type of
                       record defined.

                       Valid values are:
                       S=Summary
                       D=Detail

BNB-PLAN-GROUP         Alpha 20
Element: Plan Group

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

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

BNB-COV-PCT            Signed 5.2
Element: Cov Pct

BNB-FLEX-COST          Signed 9.2
Element: Flex Cost

BNB-EMP-COST           Signed 9.2
Element: Emp Cost

BNB-COMP-COST          Signed 9.2
Element: Comp Cost

BNB-UPDATE-DATE        Numeric 8  (yyyymmdd)
Element: Update Date

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
Element: Plan Desc

                         BNBEN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BNBSET1   COMPANY
          EMPLOYEE
          PLAN-TYPE
          PLAN-CODE
          START-DATE