ST_EXERCISE_VW3

(SQL View)
 Index Back

Stock Options Exercise table

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

SELECT A.EMPLID , A.STOCK_ID , A.GRANT_NBR , B.EXERCISE_NBR , B.EXERCISE_DT , B.SHARES_EXERCISED , B.EXERCISE_STATUS FROM PS_ST_EXERCISE_VW2 A , PS_ST_GRANT_EXER B WHERE A.EMPLID = B.EMPLID AND A.STOCK_ID = B.STOCK_ID AND A.GRANT_NBR = B.GRANT_NBR

  • 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: ST_GRANT_VW1

    2 STOCK_ID Character(10) VARCHAR2(10) NOT NULL Stock ID

    Default Value: ST_GRANT.STOCK_ID

    Prompt Table: ST_GRANT_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_VW3

    4 EXERCISE_NBR Number(8,0) INTEGER NOT NULL System assigned exercise number used to uniquely identify the exercise record.
    5 EXERCISE_DT Date(10) DATE Exercise Date
    6 SHARES_EXERCISED Signed Number(20,6) DECIMAL(18,6) NOT NULL Number of shares exercised.
    7 EXERCISE_STATUS Character(1) VARCHAR2(1) NOT NULL Holds the information related to exercising stock options.
    A=Active
    P=Pending
    V=Void