ST_GRNT_VEST_VW (SQL View)	Index Back
Current Grant Vesting Schedule ST_GRNT_VEST_VW is a view of ST_GRANT_VEST for current row.

ST_GRNT_VEST_VW

(SQL View)

Current Grant Vesting Schedule

ST_GRNT_VEST_VW is a view of ST_GRANT_VEST for current row.

SELECT A.EMPLID , A.STOCK_ID , A.GRANT_NBR , A.VEST_EFFDT , A.SEQ_NUM , A.VEST_REASON , A.VEST_SCHED_ID , A.LASTUPDOPRID , A.LASTUPDDTTM FROM PS_ST_GRANT_VEST A WHERE A.VEST_EFFDT = ( SELECT MAX(VEST_EFFDT) FROM PS_ST_GRANT_VEST B WHERE %Join(COMMON_KEYS, ST_GRANT_VEST A, ST_GRANT_VEST B, VEST_EFFDT, SEQ_NUM)) AND A.SEQ_NUM = ( SELECT MAX(SEQ_NUM) FROM PS_ST_GRANT_VEST B WHERE %Join(COMMON_KEYS, ST_GRANT_VEST A, ST_GRANT_VEST B, SEQ_NUM))

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 Company's Stock Identification Symbol
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
MOD=Modification
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	Company's Stock Identification Symbol 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 MOD=Modification 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.