ST_RELEASE_VW

(SQL View)
 Index Back

Stock Exercise Release table

Defines the stock exercise release information captured by the option tranaction processing.

SELECT EMPLID , STOCK_ID , GRANT_NBR , EXERCISE_NBR , RELEASE_NBR , RELEASE_DT , SHARES_RELEASED , RELEASE_STATUS FROM PS_ST_EXER_RELEASE WHERE RELEASE_STATUS = 'A'

  • 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 Stock ID
    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 RELEASE_NBR Number(8,0) INTEGER NOT NULL System assigned release number used to uniquely identify the release record.
    6 RELEASE_DT Date(10) DATE The date of this release transaction.
    7 SHARES_RELEASED Signed Number(20,6) DECIMAL(18,6) NOT NULL The number of shares released.
    8 RELEASE_STATUS Character(1) VARCHAR2(1) NOT NULL Status of the release - active or void.
    A=Active
    P=Pending
    V=Void