ST_EXERCISE_VW

(SQL View)
 Index Back

Stock Options Exercise table

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

SELECT EMPLID , STOCK_ID , GRANT_NBR , EXERCISE_NBR , STOCK_PLAN , EXERCISE_DT , SHARES_EXERCISED , EXERCISE_STATUS FROM PS_ST_GRANT_EXER WHERE EXERCISE_STATUS = 'A' AND RESTRICTD_EXERCISE = 'N' AND EXERCISE_METHOD <> 'SAR'

  • 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.

    Default Value: 0

    5 STOCK_PLAN Character(10) VARCHAR2(10) NOT NULL Stock Plan

    Default Value: ST_GRANT.STOCK_PLAN

    6 EXERCISE_DT Date(10) DATE NOT NULL Exercise Date

    Default Value: %date

    7 SHARES_EXERCISED Signed Number(20,6) DECIMAL(18,6) NOT NULL Number of shares exercised.
    8 EXERCISE_STATUS Character(1) VARCHAR2(1) NOT NULL Holds the information related to exercising stock options.
    A=Active
    P=Pending
    V=Void

    Default Value: A