Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

SPHIST


                              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
Element: Company       The company number represents an
                       established company and is entered on
                       all function codes.

SPH-EMPLOYEE           Numeric 9                                 BN141
Element: 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
Element: 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
Element: 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
Element: Date PurchasedThis 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
Element: Number of SharThis 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
Element: Stock Share PrThis 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