VESTSCHDDT FILE

                        Vesting Schedule Detail

The Vesting Schedule Detail file contains the information required for a
vesting schedule.

BN03.1 (Vesting Schedule) is the primary program that updates this file.

REFERENCED BY

BN203     BN232     BN237     BN55.2    BN57.1    HR170
HR70.1

UPDATED BY

BN00.1    BN03.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

VSD-COMPANY          Numeric 4                                   BN03.1
Company              Contains the company number. The number
                     correlates all information about the
                     company.

VSD-VEST-SCHED       Alpha 2                                     BN03.1
Schedule             Contains the code that represents the
                     vesting schedule.

VSD-SERV-YEARS       Numeric 2                                   BN03.1
Years of Service     Contains the number of years of service
                     required for each level of vesting.

VSD-PCT-VESTED       Signed 5.2                                  BN03.1
Percent Vested       Contains the percent of employee
                     vesting for one year of service.

                         VESTSCHDDT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

VSDSET1   COMPANY                                                BN00.1  BN03.1
          VEST-SCHED                                             BN203
          SERV-YEARS

VSDSET2   COMPANY                                                BN232   BN237
          VEST-SCHED                                             BN55.2  BN57.1
          SERV-YEARS*                                            HR170   HR70.1

                         VESTSCHDDT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        BNCOMPANY    Required

                            VSD-COMPANY       -> BNC-COMPANY

Vest Schedule  VESTSCHDHD   Required

                            VSD-COMPANY       -> VSH-COMPANY
                            VSD-VEST-SCHED    -> VSH-VEST-SCHED