ST_RELEASE_VW3

(SQL View)
 Index Back

Stock Exercise Release table

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

SELECT A.EMPLID , A.STOCK_ID , A.GRANT_NBR , A.EXERCISE_NBR , B.RELEASE_NBR , B.RELEASE_DT , B.SHARES_RELEASED , B.RELEASE_STATUS FROM PS_ST_RELEASE_VW2 A , PS_ST_EXER_RELEASE B WHERE A.EMPLID = B.EMPLID AND A.STOCK_ID = B.STOCK_ID AND A.GRANT_NBR = B.GRANT_NBR AND A.EXERCISE_NBR = B.EXERCISE_NBR

  • 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