ST_VEST_SCH_VW

(SQL View)
 Index Back

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_SCHED_ID 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_SCHED_ID Character(10) VARCHAR2(10) NOT NULL The ID that identifies this vesting schedule.