DEPBEN FILE

UPDATED BY

BS30.1    BS31.1    BS531     HR13.1    HR513

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

DEP-EMPLOYEE         Numeric 9                                   BS30.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.

DEP-DEPENDENT        Numeric 4                                   BS30.1
Dependent Number

DEP-PLAN-TYPE        Alpha 2                                     BS30.1
Type

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

DEP-EMP-START        Numeric 8  (yyyymmdd)                       BS30.1
Emp Start

DEP-START-DATE       Numeric 8  (yyyymmdd)                       BS30.1
Start Date

DEP-STOP-DATE        Numeric 8  (yyyymmdd)                       BS30.1
Stop Date

DEP-FC               Alpha 1                                     BS30.1
Fc

                         DEPBEN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

DEPSET1   COMPANY                                                BS30.1  BS31.1
          EMPLOYEE                                               BS531   HR13.1
          DEPENDENT                                              HR513
          PLAN-TYPE
          PLAN-CODE
          EMP-START
          START-DATE

DEPSET2   COMPANY
          PLAN-TYPE
          PLAN-CODE
          START-DATE
          EMP-START
          EMPLOYEE
          DEPENDENT

DEPSET3   COMPANY
          EMPLOYEE
          PLAN-TYPE
          PLAN-CODE
          EMP-START
          DEPENDENT
          START-DATE

DEPSET4   COMPANY
          EMPLOYEE
          DEPENDENT
          PLAN-TYPE
          PLAN-CODE
          EMP-START
          START-DATE*

                         DEPBEN FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Bnben          BNBEN        Required

                            DEP-COMPANY      -> BNB-COMPANY  (BNBSET1)
                            DEP-EMPLOYEE     -> BNB-EMPLOYEE
                            DEP-PLAN-TYPE    -> BNB-PLAN-TYPE
                            DEP-PLAN-CODE    -> BNB-PLAN-CODE
                            DEP-EMP-START    -> BNB-START-DATE

Company        PRSYSTEM     Required

                            DEP-COMPANY      -> PRS-COMPANY
                            Spaces           -> PRS-PROCESS-LEVEL

Dependent      EMDEPEND     Required

                            DEP-COMPANY      -> EMD-COMPANY
                            DEP-EMPLOYEE     -> EMD-EMPLOYEE
                            DEP-DEPENDENT    -> EMD-SEQ-NBR

Employee       EMPLOYEE     Required

                            DEP-COMPANY      -> EMP-COMPANY
                            DEP-EMPLOYEE     -> EMP-EMPLOYEE

Plan           PLAN         Required

                            DEP-COMPANY      -> PLN-COMPANY
                            DEP-PLAN-TYPE    -> PLN-PLAN-TYPE
                            DEP-PLAN-CODE    -> PLN-PLAN-CODE