ST_REPURCH_VW2

(SQL View)
Index Back

Grant Repurchase Process


SELECT A.EMPLID , A.STOCK_ID , A.GRANT_NBR , B.REPURCHASE_NBR , B.REPURCHASE_DT , B.SHARES_REPURCHASED , B.REPURCHASE_STATUS FROM PS_ST_GRANT A , PS_ST_GRNT_REPURCH B WHERE A.EMPLID = B.EMPLID AND A.STOCK_ID = B.STOCK_ID AND A.GRANT_NBR = B.GRANT_NBR AND A.GRANT_STATUS = 'A' AND A.EXER_BFR_VEST = '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 REPURCHASE_NBR Number(8,0) INTEGER NOT NULL Unique system assigned number used to identify the repurchase.
    5 REPURCHASE_DT Date(10) DATE Date share were repurchased.
    6 SHARES_REPURCHASED Signed Number(20,6) DECIMAL(18,6) NOT NULL Number of shares repurchased.
    7 REPURCHASE_STATUS Character(1) VARCHAR2(1) NOT NULL Status of the repurchase - active or void.
    A=Active
    V=Void