SPHIST

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.
UPDATED BY
BN141 BN232 BN430 BN531 BN61.1 BN61.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SPH-COMPANY
Element: Company Hr
Numeric 4
The company number represents an established company and is entered on all function codes.
BN141
SPH-EMPLOYEE
Element: Employee
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
Element: Plan 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
Element: 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
Element: 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
Element: Nbr 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-PRICE
Element: Share 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


SPHIST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SPHSET1 COMPANY
EMPLOYEE
PLAN-CODE
START-DATE
DATE-PURCH
BN141 BN232
BN430 BN531
BN61.1 BN61.2


SPHIST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 11:10:11 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.