SPHIST FILE

                      Stock Purchase Plan History

The Stock Purchase Plan History file contains history about an employee's
stock purchases such as the date of purchase, the number of shares purchased,
and the price per share.

REFERENCED BY

BN232     BN531     BN61.1    BN61.2

UPDATED BY

BN141     BN430

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

SPH-COMPANY          Numeric 4                                   BN141
Company              The company number represents an
                     established company and is entered on
                     all function codes.

SPH-EMPLOYEE         Numeric 9                                   BN141
Employee             An employee number is assigned to each
                     person employed by the company.  It is
                     used to correlate all information
                     related to the employee.

SPH-PLAN-CODE        Alpha 4                                     BN141
Plan                 The field contains a user-defined code
                     which represents a specific plan.  This
                     is used when the PLN-PLAN-TYPE type is
                     equal to "SP."

SPH-START-DATE       Numeric 8  (yyyymmdd)                       BN141
Start Date           This is the benefit start date for the
                     employee's stock purchase plan.  It must
                     match BEN-START-DATE.

SPH-DATE-PURCH       Numeric 8  (yyyymmdd)                       BN141
Date Purchased       This is the date the stock was
                     purchased.  This is the date purchased
                     entered on BN141 (Stock Purchase Update)
                     when run in update.

SPH-NBR-SHARES       Numeric 4                                   BN141
Number of Shares     This is the number of shares of stock
                     purchased each time BN141 (Stock
                     Purchase Update) is run in update mode.

SPH-SHARE-PRICE      Signed 11.2                                 BN141
Stock Share Price    This is the cost per share of stock.
                     This cost per share is used to determine
                     how many shares of stock the employee
                     could purchase based on the account
                     balance.  It is entered on BN141 (Stock
                     Purchase Update) when it is run in
                     update mode.

                         SPHIST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SPHSET1   COMPANY                                                BN141   BN232
          EMPLOYEE                                               BN430   BN531
          PLAN-CODE                                              BN61.1  BN61.2
          START-DATE
          DATE-PURCH

                         SPHIST FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Benefit        BENEFIT      Required

                            SPH-COMPANY       -> BEN-COMPANY
                            "SP"              -> BEN-PLAN-TYPE
                            SPH-EMPLOYEE      -> BEN-EMPLOYEE
                            SPH-START-DATE    -> BEN-START-DATE
                            SPH-PLAN-CODE     -> BEN-PLAN-CODE

Company        BNCOMPANY    Required

                            SPH-COMPANY       -> BNC-COMPANY

Company Name   PRSYSTEM     Required

                            SPH-COMPANY       -> PRS-COMPANY
                            Spaces            -> PRS-PROCESS-LEVEL

Employee       EMPLOYEE     Required

                            SPH-COMPANY       -> EMP-COMPANY
                            SPH-EMPLOYEE      -> EMP-EMPLOYEE

Plan           PLAN         Required

                            SPH-COMPANY       -> PLN-COMPANY
                            "SP"              -> PLN-PLAN-TYPE
                            SPH-PLAN-CODE     -> PLN-PLAN-CODE