ST_VALUE_TAO2 (SQL Table)	Index Back
Grant Valuation Temp Table 2 This temporary table is used in the Grant Valuation AE process.

ST_VALUE_TAO2

(SQL Table)

Grant Valuation Temp Table 2

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 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 ST_VALUATION_DT Date(10) DATE Valuation Date

7 ST_VALUE_REASON Character(1) VARCHAR2(1) NOT NULL Valuation Reason
I=Initial Valuation
M=ReValuation
R=Reprice

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 STOCK_PLAN Character(10) VARCHAR2(10) NOT NULL Stock Plan

11 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.

#	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	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	ST_VALUATION_DT	Date(10)	DATE	Valuation Date
7	ST_VALUE_REASON	Character(1)	VARCHAR2(1) NOT NULL	Valuation Reason I=Initial Valuation M=ReValuation R=Reprice
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	STOCK_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Stock Plan
11	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.