ST_OFFR_VAL_DTL (SQL Table)	Index Back
ESPP Offering Valuation This record stores Stock Purchase Offering Valuation details for both the sinlge and multiple valuation types.

ST_OFFR_VAL_DTL

(SQL Table)

ESPP Offering Valuation

This 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 Company's Stock Identification Symbol

2 STOCK_PLAN_TYPE Character(1) VARCHAR2(1) NOT NULL Type of Stock Plan
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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	STOCK_ID	Character(10)	VARCHAR2(10) NOT NULL	Company's Stock Identification Symbol
2	STOCK_PLAN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Type of Stock Plan 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