SPHIST – Stock Purchase Plan History
- System
- Benefits (BN)
- Prefix
SPH- Primary key
COMPANY,EMPLOYEE,PLAN-CODE,START-DATE,DATE-PURCH- Fields
- 7
- Updated by
- 2 programs
- Referenced by
- 4 programs
SPHIST is the Stock Purchase Plan History table in Lawson Benefits (prefix SPH). It is indexed by COMPANY, EMPLOYEE, PLAN-CODE, START-DATE, DATE-PURCH (SPHSET1). It is related 1:1 to BENEFIT, BNCOMPANY, PRSYSTEM, EMPLOYEE and PLAN. It is updated by BN141 and BN430 and referenced by BN232, BN531, BN61.1 and BN61.2. The table has 7 fields, 1 index and 5 documented relations.
About SPHIST
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.
Fields (7)
Column = COBOL field name without the SPH- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
SPH-COMPANY PKCOMPANY | Numeric 4 | The company number represents an established company and is entered on all function codes. | BN141 |
SPH-EMPLOYEE PKEMPLOYEE | Numeric 9 | An employee number is assigned to each person employed by the company. It is used to correlate all information related to the employee. | BN141 |
SPH-PLAN-CODE PKPLAN_CODE | Alpha 4 | 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." | BN141 |
SPH-START-DATE PKSTART_DATE | Numeric 8 (yyyymmdd) | This is the benefit start date for the employee's stock purchase plan. It must match BEN-START-DATE. | BN141 |
SPH-DATE-PURCH PKDATE_PURCH | Numeric 8 (yyyymmdd) | This is the date the stock was purchased. This is the date purchased entered on BN141 (Stock Purchase Update) when run in update. | BN141 |
SPH-NBR-SHARESNBR_SHARES | Numeric 4 | This is the number of shares of stock purchased each time BN141 (Stock Purchase Update) is run in update mode. | BN141 |
SPH-SHARE-PRICESHARE_PRICE | Signed 11.2 | 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. | BN141 |
Indexes (1)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
SPHSET1 | COMPANY, EMPLOYEE, PLAN-CODE, START-DATE, DATE-PURCH | Primary | BN141, BN232, BN430, BN531, BN61.1, BN61.2 |
Relations
One to one (5) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| 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 |