ST_VALUE_TAO7

(SQL Table)
Index Back

Grant Valuation Temp Table 7

This temporary table is used in the Grant Valuation AE process.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 STOCK_ID Character(10) VARCHAR2(10) NOT NULL Stock ID
3 GRANT_NBR Character(10) VARCHAR2(10) NOT NULL System assigned grant number used to uniquely identify the grant record.
4 GRANT_DT Date(10) DATE Grant Date
5 GRANT_PRICE Number(19,6) DECIMAL(18,6) NOT NULL Price an employee pays to exercise the option.
6 GRANT_FMV Number(19,6) DECIMAL(18,6) NOT NULL Grant Fair Market Value
7 ST_ASSET_PRICE Number(19,6) DECIMAL(18,6) NOT NULL Asset Price - typically equal to the Grant Price or Offering Begin Date's Discounted Price.
8 SHARES_VALUED Number(19,6) DECIMAL(18,6) NOT NULL Shares Valued
9 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.
10 ST_VALUATION_ID Character(10) VARCHAR2(10) NOT NULL Valuation ID
11 ST_VOLATILITY_TYPE Character(1) VARCHAR2(1) NOT NULL Volatility Type
H=High
L=Low
M=Mean
12 ST_VOLATILITY Number(8,6) DECIMAL(7,6) NOT NULL Volatility
13 ST_VOLATILITY_LOW Number(8,6) DECIMAL(7,6) NOT NULL Low Volatility
14 ST_VOLATILITY_MEAN Number(8,6) DECIMAL(7,6) NOT NULL Mean Volatility
15 ST_VOLATILITY_HIGH Number(8,6) DECIMAL(7,6) NOT NULL High Volatility
16 ST_DIVIDEND_RATE Number(9,6) DECIMAL(8,6) NOT NULL Expected Dividend Rate
17 ST_INTEREST_RATE Number(9,6) DECIMAL(8,6) NOT NULL Risk-Free Interest Rate
18 ST_INTEREST_TYPE Character(1) VARCHAR2(1) NOT NULL Risk-Free Interest Rate Type - Simple or Compound
C=Compounded
S=Simple
19 ST_VALUE_PER_SHARE Number(16,6) DECIMAL(15,6) NOT NULL Value Per Share