VESTHOURS FILE

                         Employee Vesting Hours

The Employee Vesting Hours file contains employee vesting hours in defined
contribution and defined benefit plans. PR199 (Payroll Close) updates this
file; you can override vesting hours by using BN57.1 (Vesting Hours).

REFERENCED BY

BN232     BN237     BN330     BN55.2    HR170     HR70.1

UPDATED BY

BN00.1    BN500     BN57.1    PA115     PR199     HR11.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

VES-COMPANY          Numeric 4                                   BN500   BN57.1
Company              Contains the company number. The number     PR199
                     correlates all information about the
                     company.

VES-EMPLOYEE         Numeric 9                                   BN500   BN57.1
Employee             Contains the employee's number. The         PR199
                     number correlates all information about
                     the employee.

VES-PLAN-TYPE        Alpha 2                                     BN500   BN57.1
Type                 Contains a benefit type for the vesting     PR199
                     hours.

VES-PLAN-CODE        Alpha 4                                     BN500   BN57.1
Plan                 Contains a user-defined code that           PR199
                     represents a benefit plan.

VES-PLAN-YEAR        Numeric 4                                   BN500   BN57.1
Plan Year            Contains the type of year used to           PR199
                     determine the vesting computation
                     period.

VES-VEST-HOURS       Signed 7.2                                  BN500   BN57.1
Vesting Hours        Contains the total number of vesting        PR199
                     hours for the vesting year for the
                     employee. If the value in this field is
                     less than PLN-VEST-HOURS on the Plan
                     file, the vesting year is not included
                     in vesting calculations.

                         VESTHOURS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

VESSET1   COMPANY                                                BN00.1  BN232
          EMPLOYEE                                               BN237   BN330
          PLAN-TYPE                                              BN500   BN55.2
          PLAN-CODE                                              BN57.1  HR11.1
          PLAN-YEAR                                              HR170   HR70.1
                                                                 PA115   PR199

VESSET2   COMPANY                                                BN57.1
          EMPLOYEE
          PLAN-TYPE
          PLAN-CODE
          PLAN-YEAR*

VESSET3   COMPANY                                                HR170   HR70.1
          PLAN-TYPE
          PLAN-CODE
          EMPLOYEE
          PLAN-YEAR

                         VESTHOURS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        BNCOMPANY    Required

                            VES-COMPANY      -> BNC-COMPANY

Company Name   PRSYSTEM     Required

                            VES-COMPANY      -> PRS-COMPANY
                            Spaces           -> PRS-PROCESS-LEVEL

Db Plan        PLAN         Required
                            When VES-PLAN-TYPE = "DB"

                            VES-COMPANY      -> PLN-COMPANY
                            VES-PLAN-TYPE    -> PLN-PLAN-TYPE
                            VES-PLAN-CODE    -> PLN-PLAN-CODE

Dc Plan        PLAN         Required
                            When VES-PLAN-TYPE = "DC"

                            VES-COMPANY      -> PLN-COMPANY
                            VES-PLAN-TYPE    -> PLN-PLAN-TYPE
                            VES-PLAN-CODE    -> PLN-PLAN-CODE

Employee       EMPLOYEE     Required

                            VES-COMPANY      -> EMP-COMPANY
                            VES-EMPLOYEE     -> EMP-EMPLOYEE