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

ST_UNVALUE_TAO2

(SQL Table)

Unconfirm Value Temp 2

This temporary table is used in the Unconfirm 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_VALUE_EFFDT Date(10) DATE Value effective date.

5 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

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

#	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_VALUE_EFFDT	Date(10)	DATE	Value effective date.
5	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
6	ST_VALUE_REASON	Character(1)	VARCHAR2(1) NOT NULL	Valuation Reason I=Initial Valuation M=ReValuation R=Reprice