ST_REPRC_TBL

(SQL Table)
Index Back

Stock Reprice

The Stock Reprice record defines business rules for a stock option repricing process. The Stock Reprice record is a child record of STOCK_TBL.

  • Related Language Record: ST_REPRICE_LANG
  • # 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 REPRICE_ID Character(10) VARCHAR2(10) NOT NULL Stock Reprice ID
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: ST_REPRC_TBL.DESCR

    5 RECORD_DT Date(10) DATE NOT NULL Record Date

    Default Value: %date

    6 BREAK_PRICE Number(16,6) DECIMAL(15,6) NOT NULL Reprice Break Price
    7 GRANT_DT Date(10) DATE NOT NULL Grant Date
    8 GRANT_REASON Character(4) VARCHAR2(4) NOT NULL Grant Reason

    Prompt Table: ST_GRNT_RSN_TBL

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

    Prompt Table: ST_AGREEMENT_VW

    10 COMPANY_INSIDER Character(1) VARCHAR2(1) NOT NULL Company Insider

    Y/N Table Edit

    Default Value: N

    11 REPORTING_PERSON Character(1) VARCHAR2(1) NOT NULL Reporting Person

    Y/N Table Edit

    Default Value: N

    12 ST_DIRECTOR Character(1) VARCHAR2(1) NOT NULL Section 16 Director

    Y/N Table Edit

    Default Value: N

    13 ST_OFFICER Character(1) VARCHAR2(1) NOT NULL Section 16 Officer

    Y/N Table Edit

    Default Value: N

    14 ST_BEN_OWNER Character(1) VARCHAR2(1) NOT NULL Section 16 Beneficial Owner

    Y/N Table Edit

    Default Value: N

    15 REPRICE_PLAN_RULE Character(1) VARCHAR2(1) NOT NULL Stock Plan Rule
    K=Keep Original Stock Plan
    N=Apply New Stock Plan

    Default Value: K

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

    Prompt Table: ST_OPT_PLAN_VW

    17 REPRICE_VEST_RULE Character(1) VARCHAR2(1) NOT NULL Vesting Schedule Rule
    D=Defer Original Vesting
    K=Keep Original Vesting
    N=New Vesting

    Default Value: K

    18 VEST_SCHED_ID Character(10) VARCHAR2(10) NOT NULL The ID that identifies this vesting schedule.

    Prompt Table: ST_VEST_SCHED

    19 EXERCISE_HOLD_DT Date(10) DATE Exercise Hold Date
    20 VEST_DEFER_MM Number(3,0) SMALLINT NOT NULL Vesting Deferral: Months
    21 VEST_DEFER_DD Number(2,0) SMALLINT NOT NULL Vesting Defferal Period: Days
    22 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
    23 OPTION_LIFE_MM Number(4,0) SMALLINT NOT NULL This field indicates the life of the option in numbers of months.
    24 REPRICE_EXER_RULE Character(1) VARCHAR2(1) NOT NULL Exercise Before Vest Rule
    K=Keep Original
    O=Override

    Default Value: K

    25 EXER_BFR_VEST Character(1) VARCHAR2(1) NOT NULL This field indicates that exercise is allowed before vesting. Typically used with RSA's.
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    26 REPRICE_XFER_RULE Character(1) VARCHAR2(1) NOT NULL Transferable Options Rule
    K=Keep Original
    O=Override

    Default Value: K

    27 TRANSFER_ALLOW Character(1) VARCHAR2(1) NOT NULL Transferable Options
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    28 ST_OPTN_CNV_NQ Character(4) VARCHAR2(4) NOT NULL Stock Option Conversion - NQ
    ISAR=Incentive Stock Option SAR
    ISO=Incentive Stock Option
    NQ=Non-Qualified Stock Option
    NSAR=Non-Qualified SAR

    Default Value: NQ

    29 ST_OPTN_CNV_ISO Character(4) VARCHAR2(4) NOT NULL Stock Option Conversion - ISO
    ISAR=Incentive Stock Option SAR
    ISO=Incentive Stock Option
    NQ=Non-Qualified Stock Option
    NSAR=Non-Qualified SAR

    Default Value: ISO

    30 ST_OPTN_CNV_NSAR Character(4) VARCHAR2(4) NOT NULL Stock Option Conversion - NSAR
    ISAR=Incentive Stock Option SAR
    ISO=Incentive Stock Option
    NQ=Non-Qualified Stock Option
    NSAR=Non-Qualified SAR

    Default Value: NSAR

    31 ST_OPTN_CNV_ISAR Character(4) VARCHAR2(4) NOT NULL Stock Option Conversion - ISAR
    ISAR=Incentive Stock Option SAR
    ISO=Incentive Stock Option
    NQ=Non-Qualified Stock Option
    NSAR=Non-Qualified SAR

    Default Value: ISAR

    32 REPRICE_STATUS Character(1) VARCHAR2(1) NOT NULL Reprice Eligibility Status
    P=Processed
    U=Unprocessed

    Default Value: U

    33 STATUS_DT Date(10) DATE Status Date

    Default Value: %date