ST_PURCHASE_PD

(SQL Table)
Index Back

ESPP Purchase Period Table

This table define the purchase period for contributions for ESPP

  • Parent record: ST_OFFERING_PD
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 STOCK_ID Character(10) VARCHAR2(10) NOT NULL Stock ID

    Prompt Table: STOCK_TBL

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

    Default Value: E

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

    Prompt Table: STOCK_PLAN_TBL

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

    Prompt Table: ST_OFFERING_PD

    5 PERIOD_END_DT Date(10) DATE Period End Date
    6 PERIOD_BEGIN_DT Date(10) DATE Period Begin Date
    7 ESPP_PARTIC_RUN Character(1) VARCHAR2(1) NOT NULL Update Participants