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 |
BN141 | BN430 |
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. |
|
||
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. |
|
||
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." |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SPHSET1 |
COMPANY EMPLOYEE PLAN-CODE START-DATE DATE-PURCH |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Benefit | BENEFIT |
Required
| |||||||||||||||
Company | BNCOMPANY |
Required
| |||||||||||||||
Company Name | PRSYSTEM |
Required
| |||||||||||||||
Employee | EMPLOYEE |
Required
| |||||||||||||||
Plan | PLAN |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.