BNBEN FILE

UPDATED BY

BS31.1    BS531     HR11.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

BNB-COMPANY          Numeric 4                                   BS31.1
Company              The company number represents an
                     established company and is entered on
                     all function codes.

BNB-EMPLOYEE         Numeric 9                                   BS31.1
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
Type

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

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

BNB-FC               Alpha 1                                     BS31.1
Fc

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

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

BNB-MULT-SALARY      Signed 5.3                                  BS31.1
Multiple of Salary

BNB-COVER-AMT        Signed 11.2                                 BS31.1
Flat Amount

BNB-PAY-RATE         Signed 13.4                                 BS31.1
Rate of Pay

BNB-PCT-AMT-FLAG     Alpha 1                                     BS31.1
Percent or Amount
Indicator

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

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

BNB-EMP-PRE-CONT     Signed 7.2                                  BS31.1
Employee Pre Tax
Contribution

BNB-EMP-AFT-CONT     Signed 7.2                                  BS31.1
Employee After Tax
Contrib

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

BNB-PEND-EVIDENCE    Alpha 1
Pend Evidence

BNB-YTD-CONT         Signed 11.2
Ytd Cont

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

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

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

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

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

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

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

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

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

BNB-ALPHADATA1       Alpha 1
Alphadata1

BNB-NUMERIC1         Signed 15.4
Numeric1

BNB-DATE1            Numeric 8  (yyyymmdd)
Date1

BNB-PLAN-DESC        Alpha 30                                    BS31.1
Plan Description

                         BNBEN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BNBSET1   COMPANY                                                BS31.1  BS531
          EMPLOYEE                                               HR11.1
          PLAN-TYPE
          PLAN-CODE
          START-DATE

BNBSET2   COMPANY
          PLAN-TYPE
          PLAN-CODE
          EMPLOYEE
          START-DATE*

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

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

                         BNBEN FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        BNCOMPANY    Required

                            BNB-COMPANY       -> BNC-COMPANY  (BNCSET1)

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

                         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