ST_VEST_DEFN (SQL Table)	Index Back
Vesting Schedule Defn This table contains the vesting template vesting frequencies. It is a child record to ST_VEST_TBL.

ST_VEST_DEFN

(SQL Table)

Vesting Schedule Defn

This table contains the vesting template vesting frequencies. It is a child record to ST_VEST_TBL.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 VEST_SCHED_ID Character(10) VARCHAR2(10) NOT NULL The ID that identifies this vesting schedule.

2 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
Default Value: 1

3 VEST_MONTHS Number(3,0) SMALLINT NOT NULL The number of months in one vesting period.
Default Value: 0

4 VEST_PERCENT Number(7,3) DECIMAL(6,3) NOT NULL This field is used to contain the number which represents a percentage of the total stock to vest.

5 VEST_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Vesting Frequency
A=Annually
M=Monthly
Q=Quarterly
S=Semi-Annual
V=Vesting Date
Default Value: V

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	VEST_SCHED_ID	Character(10)	VARCHAR2(10) NOT NULL	The ID that identifies this vesting schedule.
2	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence Default Value: 1
3	VEST_MONTHS	Number(3,0)	SMALLINT NOT NULL	The number of months in one vesting period. Default Value: 0
4	VEST_PERCENT	Number(7,3)	DECIMAL(6,3) NOT NULL	This field is used to contain the number which represents a percentage of the total stock to vest.
5	VEST_FREQUENCY	Character(1)	VARCHAR2(1) NOT NULL	Vesting Frequency A=Annually M=Monthly Q=Quarterly S=Semi-Annual V=Vesting Date Default Value: V