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
|
