ST_VEST_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	STOCK_ID	Character(10)	VARCHAR2(10) NOT NULL	Company's Stock Identification Symbol
5	VEST_SCHED_ID	Character(10)	VARCHAR2(10) NOT NULL	The ID that identifies this vesting schedule.
6	VEST_REASON	Character(4)	VARCHAR2(4) NOT NULL	Vesting reason code. CORR=Correction INIT=Initial Vesting MERG=Merger/Acquisition MOD=Modification PERF=Performance Vesting RFL=Return from Leave RPRC=Reprice TER=Termination
7	STOCK_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Stock Plan
8	GRANT_DT	Date(10)	DATE	Grant Date
9	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
10	VEST_EFFDT	Date(10)	DATE	Vesting effective date.
11	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
12	EXPIRE_BASIS_CD	Character(1)	VARCHAR2(1) NOT NULL	This field indicates which date is used as the base to calculate the length of time before an option expires. G=Grant Date H=Grant Date + 1 V=Vest Date W=Vest Date + 1
13	OPTION_LIFE_MM	Number(4,0)	SMALLINT NOT NULL	This field indicates the life of the option in numbers of months.
14	ST_VEST_BASIS_DT	Date(10)	DATE	This date is used to determine the vesting basis.
15	ST_VEST_PERIOD_CNT	Number(2,0)	SMALLINT NOT NULL	Period Count
16	UNEVEN_SHARE_RULE	Character(1)	VARCHAR2(1) NOT NULL	Indicates how uneven shares will be allocated in the vesting period. B=First Vest Period E=Last Vest Period F=First Full Share
17	SQL_ID	Character(30)	VARCHAR2(30) NOT NULL	TL
18	SQL_ID2	Character(30)	VARCHAR2(30) NOT NULL	TL
19	IF_FLAG	Character(1)	VARCHAR2(1) NOT NULL	If flag