BNSIMDTL FILE

                       Benefit Simulation Detail

The Benefit Simulation Detail file contains information for simulating
employee benefit deductions and pay.

REFERENCED BY

BN66.1

UPDATED BY

BN00.1    BN65.1    PA115

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

BSD-COMPANY          Numeric 4                                   BN65.1
Company              Contains the company number.

BSD-EMPLOYEE         Numeric 9                                   BN65.1
Employee             Contains the employee number.

BSD-PLAN-TYPE        Alpha 2                                     BN65.1
Type                 Contains the plan type that identifies
                     the type of benefit.
                     HL = Health
                     DN = Dental
                     DI = Disability
                     EL = Life
                     DL = Dependent Life
                     DC = Defined Contribution
                     DB = Defined Benefit
                     VA = Vacation
                     RS = Spending Account
                     SB = Savings Bond
                     SP = Stock Purchase

BSD-PLAN-CODE        Alpha 4                                     BN65.1
Plan                 Contains the user-defined code used to
                     represent a specific benefit plan.

BSD-DESC             Alpha 30  (Lower Case)                      BN65.1
Description          Contains the benefit plan description.

BSD-COV-OPTION       Numeric 2                                   BN65.1
Coverage Option      This field contains the selected
                     coverage option of the benefit plan.

BSD-COVER-AMT        Signed 11.2                                 BN65.1
Flat Amount          This field contains the benefit
                     coverage amount.

BSD-EMP-PRE-CONT     Signed 7.2                                  BN65.1  BN65.2
Employee Pre Tax     This field contains the employee
Contribution         pre-tax contribution.

BSD-EMP-AFT-CONT     Signed 7.2                                  BN65.1
Employee After Tax   This field contains the employee
Contrib              after-tax contribution.

BSD-OPTION-COST      Signed 11.2                                 BN65.1
Option Cost          Contains the total cost of the
                     simulated benefit.

BSD-FLEX-FLAG        Alpha 1                                     BN65.1
Flex Deduction       This field flags the benefit as a flex
                     plan or a non-flex plan.

                         BNSIMDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BSDSET1   COMPANY                                                BN00.1  BN65.1
          EMPLOYEE                                               BN65.2  BN66.1
          PLAN-TYPE                                              PA115
          PLAN-CODE

                         BNSIMDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        BNCOMPANY    Required

                            BSD-COMPANY      -> BNC-COMPANY

Company Name   PRSYSTEM     Required

                            BSD-COMPANY      -> PRS-COMPANY
                            Spaces           -> PRS-PROCESS-LEVEL

Employee       EMPLOYEE     Required

                            BSD-COMPANY      -> EMP-COMPANY
                            BSD-EMPLOYEE     -> EMP-EMPLOYEE

Plan           PLAN         Required
                            When BSD-PLAN-CODE != Spaces

                            BSD-COMPANY      -> PLN-COMPANY
                            BSD-PLAN-TYPE    -> PLN-PLAN-TYPE
                            BSD-PLAN-CODE    -> PLN-PLAN-CODE

Sim Header     BNSIMHDR     Required

                            BSD-COMPANY      -> BSH-COMPANY
                            BSD-EMPLOYEE     -> BSH-EMPLOYEE