BNPLNENR FILE

REFERENCED BY

BN100     BN101     BN102     BN103     BN105     BN145
BN245     BN31.1    BN31.2    BN32.1    BN32.2    BN32.3
BN320     BN331     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
Company              The company number represents an
                     established company and is entered on
                     all function codes.

BPE-PLAN-TYPE        Alpha 2                                     BS03.1
Type

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

BPE-PROCESS-LEVEL    Alpha 5                                     BS03.1
Process Level        This field contains the process level,
                     which is the reporting hierarchy below
                     company.

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

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

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

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

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

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

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

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

BPE-EMPLOYEE-COST    Alpha 1                                     BS03.1
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
Company Cost         Y = Yes
                     N = No

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

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

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

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

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

BPE-MISC-1           Alpha 10
Misc 1

BPE-MISC-2           Alpha 10
Misc 2

                         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                                             BN245   BN31.1
          PLAN-TYPE                                              BN31.2  BN32.1
          PLAN-CODE                                              BN32.2  BN32.3
                                                                 BN320   BN331
                                                                 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       Duplicates                               BN15.1
          PLAN-TYPE
          PLAN-CODE

                         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