ST_OPTION_PARMS

(SQL Table)
 Index Back

Stock Option Type Record

This table contains information related to the various types of options defined.

  • Parent record: ST_OPTION_PLAN

    • # 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: O

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

    Prompt Table: STOCK_PLAN_TBL

    4 EFFDT Date(10) DATE Effective Date

    Default Value: ST_OPTION_PLAN.EFFDT

    5 OPTION_PARMS_ID Character(10) VARCHAR2(10) NOT NULL The identifier associated with the parms for the option type defined.
    6 ST_OPTION_TYPE Character(4) VARCHAR2(4) NOT NULL Option Type
    ISAR=ISO-Stock Appreciation Right
    ISO=Incentive Stock Option
    NQ=Non-Qualified
    NSAR=NQ-Stock Appreciation Right
    RSA=Restricted Stock Award
    7 DFLT_OPTION_PARMS Character(1) VARCHAR2(1) NOT NULL Default

    Y/N Table Edit

    Default Value: N

    8 EXPIRE_BASIS_CD Character(1) VARCHAR2(1) NOT NULL This field indicates which date is used as the base to calculate the length of time before an option expires.
    G=Grant Date
    H=Grant Date + 1
    V=Vest Date
    W=Vest Date + 1
    9 OPTION_LIFE_MM Number(4,0) SMALLINT NOT NULL This field indicates the life of the option in numbers of months.
    10 VEST_SCHED_ID Character(10) VARCHAR2(10) NOT NULL The ID that identifies this vesting schedule.

    Prompt Table: ST_VEST_SCHED

    11 AGREEMENT_ID Character(10) VARCHAR2(10) NOT NULL Agreement ID

    Prompt Table: ST_AGREEMENT_VW

    12 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description