ST_VALUE_TAO3

(SQL Table)
Index Back

Grant Valuation Temp Table 3

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 Company's Stock Identification Symbol
3 GRANT_NBR Character(10) VARCHAR2(10) NOT NULL System assigned grant number used to uniquely identify the grant record.
4 ST_VALUATION_DT Date(10) DATE Valuation Date
5 GRANT_DT Date(10) DATE Grant Date
6 EXPIRATN_DT Date(10) DATE Expiration Date
7 GRANT_PRICE Number(19,6) DECIMAL(18,6) NOT NULL Price an employee pays to exercise the option.
8 GRANT_FMV Number(19,6) DECIMAL(18,6) NOT NULL Grant Fair Market Value
9 SHARES_VALUED Number(19,6) DECIMAL(18,6) NOT NULL Shares Valued
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_VALUE_REASON Character(1) VARCHAR2(1) NOT NULL Valuation Reason
I=Initial Valuation
M=ReValuation
R=Reprice