ST_GRNT_VST_DTL (SQL Table)	Index Back
Grant Vesting Schedule Defines the grant vesting information used by the option tranaction processing.

ST_GRNT_VST_DTL

(SQL Table)

Grant Vesting Schedule

Defines the grant vesting information used by the option tranaction processing.

# 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 Stock ID

3 GRANT_NBR Character(10) VARCHAR2(10) NOT NULL System assigned grant number used to uniquely identify the grant record.

4 VEST_EFFDT Date(10) DATE Vesting effective date.
Default Value: ST_GRANT_VEST.VEST_EFFDT

5 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
Default Value: ST_GRANT_VEST.SEQ_NUM

6 VEST_DT Date(10) DATE NOT NULL Vesting Date

7 SHARES_VESTED Signed Number(20,6) DECIMAL(18,6) NOT NULL Number of shares that vest on VEST_DT.

8 EXPIRATN_DT Date(10) DATE NOT NULL Expiration Date

9 TERM_EXPIRATN_DT Date(10) DATE Expiration date of unexercised shares when emplyee terminates.

#	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	Stock ID
3	GRANT_NBR	Character(10)	VARCHAR2(10) NOT NULL	System assigned grant number used to uniquely identify the grant record.
4	VEST_EFFDT	Date(10)	DATE	Vesting effective date. Default Value: ST_GRANT_VEST.VEST_EFFDT
5	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence Default Value: ST_GRANT_VEST.SEQ_NUM
6	VEST_DT	Date(10)	DATE NOT NULL	Vesting Date
7	SHARES_VESTED	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Number of shares that vest on VEST_DT.
8	EXPIRATN_DT	Date(10)	DATE NOT NULL	Expiration Date
9	TERM_EXPIRATN_DT	Date(10)	DATE	Expiration date of unexercised shares when emplyee terminates.