ST_PARTIC_VW

(SQL View)
 Index Back

Purch Pd/Manual Contrib Vw

Union of the purchase period participation records and the manual contributions which have been entered for people for which there are no participation rows.

SELECT DISTINCT B.OPRID , A.EMPLID , A.EMPL_RCD , A.STOCK_ID , A.STOCK_PLAN_TYPE , A.STOCK_PLAN , A.OFFERING_ID , A.PERIOD_END_DT , B.NAME FROM PS_ST_PURCH_PARTIC A , PS_PERS_SRCH_ST_PR B WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD

  • Parent record: ST_ESPP_PARTIC

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERS_SRCH_GBL

    3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    4 STOCK_ID Character(10) VARCHAR2(10) NOT NULL Stock ID

    Prompt Table: STOCK_TBL

    5 STOCK_PLAN_TYPE Character(1) VARCHAR2(1) NOT NULL Stock Plan Type
    E=Purchase Plan
    O=Option Plan
    6 STOCK_PLAN Character(10) VARCHAR2(10) NOT NULL Stock Plan

    Prompt Table: STOCK_PLAN_TBL

    7 OFFERING_ID Character(10) VARCHAR2(10) NOT NULL Offering ID

    Prompt Table: ST_OFFERING_PD

    8 PERIOD_END_DT Date(10) DATE Period End Date

    Prompt Table: ST_PURCHASE_PD

    9 NAME Character(50) VARCHAR2(50) NOT NULL Name