ST_RELEASE_VW2

(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 , A.EXERCISE_NBR , A.EXERCISE_DT , A.STOCK_PLAN , B.ST_OPTION_TYPE , B.GRANT_PRICE , A.SHARES_EXERCISED , A.EXERCISE_STATUS FROM PS_ST_GRANT_EXER A , PS_ST_GRANT B WHERE A.EMPLID = B.EMPLID AND A.STOCK_ID = B.STOCK_ID AND A.GRANT_NBR = B.GRANT_NBR AND A.EXERCISE_STATUS = 'A' AND A.RESTRICTD_EXERCISE = 'Y'

  • 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 STOCK_PLAN Character(10) VARCHAR2(10) NOT NULL Stock Plan
    7 ST_OPTION_TYPE Character(4) VARCHAR2(4) NOT NULL Option Type
    ISAR=ISO-Stock Appreciation Right
    ISO=Incentive Stock Option
    NQ=Non-Qualified
    NSAR=NQ-Stock Appreciation Right
    RSA=Restricted Stock Award
    8 GRANT_PRICE Number(19,6) DECIMAL(18,6) NOT NULL Price an employee pays to exercise the option.
    9 SHARES_EXERCISED Signed Number(20,6) DECIMAL(18,6) NOT NULL Number of shares exercised.
    10 EXERCISE_STATUS Character(1) VARCHAR2(1) NOT NULL Holds the information related to exercising stock options.
    A=Active
    P=Pending
    V=Void