ST_DISPOSN_VW

(SQL View)
 Index Back

Stock Purchase Dispositions

Display Dispositions that are linked to a particular purchase.

SELECT A.STOCK_ID , A.DISPOSITION_NBR ,A.STOCK_PLAN ,A.OFFERING_ID ,A.PERIOD_END_DT ,A.PROCESS_GROUP ,A.EMPLID ,A.DISPOSITION_DT ,A.DISPOSITION_STATUS ,A.DISPOSITION_TYPE ,A.DISPOSITION_SRC FROM PS_ST_ESPP_DISPOSN A WHERE A.DISPOSITION_NBR <> 0

  • Parent record: ST_ESPP_PURCH

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 STOCK_ID Character(10) VARCHAR2(10) NOT NULL Stock ID
    2 DISPOSITION_NBR Number(8,0) INTEGER NOT NULL System assigned disposition number used to uniquely identify the disposition record.
    3 STOCK_PLAN Character(10) VARCHAR2(10) NOT NULL Stock Plan
    4 OFFERING_ID Character(10) VARCHAR2(10) NOT NULL Offering ID
    5 PERIOD_END_DT Date(10) DATE Period End Date
    6 PROCESS_GROUP Character(10) VARCHAR2(10) NOT NULL Process Group
    7 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    8 DISPOSITION_DT Date(10) DATE The date of the disposition.
    9 DISPOSITION_STATUS Character(1) VARCHAR2(1) NOT NULL Staus of disposition - active, pending for survey, void
    C=Confirmed
    P=Pending
    V=Void
    10 DISPOSITION_TYPE Character(1) VARCHAR2(1) NOT NULL Type of disposition - sale or transfer.
    S=Sale
    T=Transfer
    11 DISPOSITION_SRC Character(1) VARCHAR2(1) NOT NULL Disposition Source
    A=Administrator
    S=Self Service
    T=Third Party