STOCK_IDSTOCK_PLAN_TYPEE=Purchase Plan
O=Option Plan
Default Value: E
STOCK_PLANOFFERING_IDPERIOD_END_DTPERIOD_BEGIN_DTST_OFFR_VAL_DTL(SQL Table) |
Index Back |
|---|---|
ESPP Offering ValuationThis record stores Stock Purchase Offering Valuation details for both the sinlge and multiple valuation types. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | STOCK_ID |
Character(10) | VARCHAR2(10) NOT NULL | Stock ID |
| 2 | STOCK_PLAN_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Stock Plan Type
E=Purchase Plan O=Option Plan Default Value: E |
| 3 | STOCK_PLAN |
Character(10) | VARCHAR2(10) NOT NULL | Stock Plan |
| 4 | OFFERING_ID |
Character(10) | VARCHAR2(10) NOT NULL | Offering ID |
| 5 | PERIOD_END_DT |
Date(10) | DATE | Period End Date |
| 6 | PERIOD_BEGIN_DT |
Date(10) | DATE | Period Begin Date |
| 7 | ST_VALUE_PER_SHARE | Number(16,6) | DECIMAL(15,6) NOT NULL | Value Per Share |
| 8 | GRANT_FMV | Number(19,6) | DECIMAL(18,6) NOT NULL | Grant Fair Market Value |
| 9 | GRANT_PRICE | Number(19,6) | DECIMAL(18,6) NOT NULL | Price an employee pays to exercise the option. |
| 10 | ST_EXPECTED_LIFE | Number(10,6) | DECIMAL(9,6) NOT NULL | Expected Life Years a Stock Option or Offering Period has from grant to exercise/purchase date. |
| 11 | ST_VOLATILITY | Number(8,6) | DECIMAL(7,6) NOT NULL | Volatility |
| 12 | ST_INTEREST_RATE | Number(9,6) | DECIMAL(8,6) NOT NULL | Risk-Free Interest Rate |
| 13 | ST_DIVIDEND_RATE | Number(9,6) | DECIMAL(8,6) NOT NULL | Expected Dividend Rate |