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

ST_GRANT_VEST

(SQL Table)

Grant Vesting Schedule

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

Parent record: ST_GRANT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

2 STOCK_ID Character(10) VARCHAR2(10) NOT NULL Stock ID
Prompt Table: ST_OPT_PLAN_VW2

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

4 VEST_EFFDT Date(10) DATE Vesting effective date.

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

6 VEST_REASON Character(4) VARCHAR2(4) NOT NULL Vesting reason code.
CORR=Correction
INIT=Initial Vesting
MERG=Merger/Acquisition
PERF=Performance Vesting
RFL=Return from Leave
RPRC=Reprice
TER=Termination

7 VEST_SCHED_ID Character(10) VARCHAR2(10) NOT NULL The ID that identifies this vesting schedule.
Prompt Table: ST_VEST_SCHED

8 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

9 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	STOCK_ID	Character(10)	VARCHAR2(10) NOT NULL	Stock ID Prompt Table: ST_OPT_PLAN_VW2
3	GRANT_NBR	Character(10)	VARCHAR2(10) NOT NULL	System assigned grant number used to uniquely identify the grant record. Prompt Table: ST_GRANT
4	VEST_EFFDT	Date(10)	DATE	Vesting effective date.
5	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
6	VEST_REASON	Character(4)	VARCHAR2(4) NOT NULL	Vesting reason code. CORR=Correction INIT=Initial Vesting MERG=Merger/Acquisition PERF=Performance Vesting RFL=Return from Leave RPRC=Reprice TER=Termination
7	VEST_SCHED_ID	Character(10)	VARCHAR2(10) NOT NULL	The ID that identifies this vesting schedule. Prompt Table: ST_VEST_SCHED
8	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
9	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.