ST_STOK002_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DATETIME_STAMP	DateTime(26)	TIMESTAMP	DateTime Stamp
2	PROCESSINSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	STOCK_ID	Character(10)	VARCHAR2(10) NOT NULL	Stock ID
5	STOCK_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Stock Plan
6	GRANT_NBR	Character(10)	VARCHAR2(10) NOT NULL	System assigned grant number used to uniquely identify the grant record.
7	VEST_DT	Date(10)	DATE	Vesting Date
8	GRANT_PRICE	Number(19,6)	DECIMAL(18,6) NOT NULL	Price an employee pays to exercise the option.
9	SHARES_VESTED	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Number of shares that vest on VEST_DT.
10	SHARES_EXERCISED	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Number of shares exercised.
11	EXPIRATN_DT	Date(10)	DATE	Expiration Date
12	TERM_EXPIRATN_DT	Date(10)	DATE	Expiration date of unexercised shares when emplyee terminates.
13	ST_CANCEL_REASON	Character(4)	VARCHAR2(4) NOT NULL	Reason shares were cancelled. RESC=Employee Rescinded Offer RPRC=Reprice TER=Termination
14	ST_CANCEL_DT	Date(10)	DATE	Cancellation Date
15	VEST_SUSPEND_DT	Date(10)	DATE	The date vesting is suspended when an employee is on leave.
16	EXERCISE_HOLD_DT	Date(10)	DATE	Exercise Hold Date