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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#SPH-COMPANY PK
COMPANY		Numeric 4The company number represents an established company and is entered on all function codes.BN141
#SPH-EMPLOYEE PK
EMPLOYEE		Numeric 9An 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 PK
PLAN_CODE		Alpha 4The 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 PK
START_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 PK
DATE_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-SHARES
NBR_SHARES		Numeric 4This is the number of shares of stock purchased each time BN141 (Stock Purchase Update) is run in update mode.BN141
#SPH-SHARE-PRICE
SHARE_PRICE		Signed 11.2This 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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
SPHSET1
  1. COMPANY
  2. EMPLOYEE
  3. PLAN-CODE
  4. START-DATE
  5. DATE-PURCH
PrimaryBN141, BN232, BN430, BN531, BN61.1, BN61.2

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
BENEFITBNCOMPANYPRSYSTEMEMPLOYEEPLANSPHIST

One to one (5) — lookups and parents

RelationTableRulesConditionField map
BenefitBENEFITRequired
SPH-COMPANY→BEN-COMPANY
"SP"→BEN-PLAN-TYPE
SPH-EMPLOYEE→BEN-EMPLOYEE
SPH-START-DATE→BEN-START-DATE
SPH-PLAN-CODE→BEN-PLAN-CODE
CompanyBNCOMPANYRequired
SPH-COMPANY→BNC-COMPANY
Company NamePRSYSTEMRequired
SPH-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequired
SPH-COMPANY→EMP-COMPANY
SPH-EMPLOYEE→EMP-EMPLOYEE
PlanPLANRequired
SPH-COMPANY→PLN-COMPANY
"SP"→PLN-PLAN-TYPE
SPH-PLAN-CODE→PLN-PLAN-CODE

Programs

Updated by (2)

Referenced by (4)