ST_EXER_DISP_VW

(SQL View)
 Index Back

Stock Exercise Disposition Vw

ST_EXER_DISP_VW is a view of the stock exercise disposition table (ST_EXER_DISPOSN) for unvoided dispositions.

SELECT A.EMPLID , A.STOCK_ID , A.GRANT_NBR , B.EXERCISE_NBR , B.DISPOSITION_NBR , A.ST_OPTION_TYPE , B.DISPOSITION_DT , B.DISPOSITION_TYPE , B.DISPOSITION_SRC , B.SHARES_DISPOSED , B.DISPOSITION_PRICE , B.DISPOSITION_STATUS , B.DISQUAL_DISPOSN , B.ST_ORD_INCOME FROM PS_ST_GRANT A , PS_ST_EXER_DISPOSN B WHERE %Join(COMMON_KEYS, ST_GRANT A, ST_EXER_DISPOSN B) AND A.GRANT_STATUS = 'A' AND B.DISPOSITION_STATUS <> 'V'

  • Parent record: ST_GRANT_EXER

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 STOCK_ID Character(10) VARCHAR2(10) NOT NULL Company's Stock Identification Symbol
    3 GRANT_NBR Character(10) VARCHAR2(10) NOT NULL System assigned grant number used to uniquely identify the grant record.
    4 EXERCISE_NBR Number(8,0) INTEGER NOT NULL System assigned exercise number used to uniquely identify the exercise record.
    5 DISPOSITION_NBR Number(8,0) INTEGER NOT NULL System assigned disposition number used to uniquely identify the disposition record.
    6 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
    7 DISPOSITION_DT Date(10) DATE NOT NULL The date of the disposition.
    8 DISPOSITION_TYPE Character(1) VARCHAR2(1) NOT NULL Type of disposition - sale or transfer.
    S=Sale
    T=Transfer

    Default Value: S

    9 DISPOSITION_SRC Character(1) VARCHAR2(1) NOT NULL Disposition Source
    A=Administrator
    S=Self Service
    T=Third Party

    Default Value: A

    10 SHARES_DISPOSED Signed Number(20,6) DECIMAL(18,6) NOT NULL Number of shares disposed.
    11 DISPOSITION_PRICE Number(19,6) DECIMAL(18,6) NOT NULL The share price at time of disposition.
    12 DISPOSITION_STATUS Character(1) VARCHAR2(1) NOT NULL Staus of disposition - active, pending for survey, void
    C=Confirmed
    P=Pending
    V=Void

    Default Value: P

    13 DISQUAL_DISPOSN Character(1) VARCHAR2(1) NOT NULL Indicates whether or not this is a disqualifying disposition based on governing body rules.
    N=No
    Y=Yes

    Default Value: N

    14 ST_ORD_INCOME Signed Number(20,6) DECIMAL(18,6) NOT NULL Ordinary Income