ST_OFFERING_PD

(SQL Table)
 Index Back

ESPP Offering Period Table

This tables defines the Employee Stock Purchase Plan Offering Period

  • Parent record: ST_ESPP_PLAN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 STOCK_ID Character(10) VARCHAR2(10) NOT NULL Company's Stock Identification Symbol

    Prompt Table: STOCK_TBL

    2 STOCK_PLAN_TYPE Character(1) VARCHAR2(1) NOT NULL Type of Stock Plan
    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
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: ST_OFFERING_PD.DESCR

    7 STATUS_DT Date(10) DATE Status Date

    Default Value: %date

    8 OFFERING_STATUS Character(1) VARCHAR2(1) NOT NULL Offering Status
    A=Active
    C=Cancelled
    E=Expired

    Default Value: A

    9 PERIOD_BEGIN_DT Date(10) DATE Period Begin Date

    Default Value: %date

    10 PERIOD_END_DT Date(10) DATE Period End Date
    11 OFFERING_ID_PREV Character(10) VARCHAR2(10) NOT NULL Offering ID

    Prompt Table: ST_OFFERING_VW

    12 COMMENTS Long Character CLOB Comment