ST_ESPP_PARTIC

(SQL Table)
 Index Back

Stock Purchase Participation

Stores Stock Purchase Plan Participation. This table is updated by the Update Participants process.

  • Parent Record Of ST_PARTIC_VW ST_PRTC_RFND_VW ST_PURCH_PARTIC ST_PURCH_VW ST_RSDL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERS_SRCH_GBL

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

    Prompt Table: STOCK_TBL

    4 STOCK_PLAN_TYPE Character(1) VARCHAR2(1) NOT NULL Stock Plan Type
    E=Purchase Plan
    O=Option Plan

    Default Value: E

    5 STOCK_PLAN Character(10) VARCHAR2(10) NOT NULL Stock Plan

    Prompt Table: STOCK_PLAN_TBL

    6 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

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

    Prompt Table: ST_OFFERING_PD

    8 GRANT_DT Date(10) DATE NOT NULL Grant Date

    Prompt Table: ST_OFFER_GRANT

    9 ST_PARTIC_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Participation Override

    Y/N Table Edit

    Default Value: N

    10 ESPP_GATHER_RUN Character(1) VARCHAR2(1) NOT NULL Gather Contributions

    Default Value: N