VC_PLAN_TBL

(SQL Table)
 Index Back

Variable Comp Plan Table

This record stores all data relevant to a Variable Compensation plan that is not likely to change over the life of the plan. All data that can be changed is stored in the VC Plan Effective-dated table.

  • Related Language Record: VC_PLAN_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 VC_PLAN_ID Character(10) VARCHAR2(10) NOT NULL VC Plan ID
    2 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    4 VC_PLAN_START_DT Date(10) DATE NOT NULL Plan Start Date
    5 VC_PLAN_END_DT Date(10) DATE NOT NULL Plan End Date
    6 VC_PLAN_TYPE Character(2) VARCHAR2(2) NOT NULL VC Plan Type
    D=Discretionary Bonus
    G=Goal Sharing
    I=Stock - ISO
    K=Stock - NSAR
    N=Non-Monetary
    O=Other
    P=Profit Sharing
    Q=Stock - NQ
    R=Stock - RSA
    S=Stock- ISAR

    Prompt Table: VC_PLAN_TYPE_VW

    7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    8 VC_GOAL_TYPE Character(2) VARCHAR2(2) NOT NULL Plan Goal Type
    G=Weighted Goals
    M=Goals Matrix
    9 VC_PLAN_MEM_CRIT Character(2) VARCHAR2(2) NOT NULL Plan Member Criteria
    A=Ad Hoc Award
    E=Empl VC Record
    G=Empl VC Record with Groups
    T=Define Tree/Group
    10 VC_CARRYOVER_IND Character(2) VARCHAR2(2) NOT NULL Carryover Awards

    Y/N Table Edit

    Default Value: N

    11 VC_FUND_IND Character(2) VARCHAR2(2) NOT NULL Funded Plan

    Y/N Table Edit

    Default Value: N

    12 STOCK_ID Character(10) VARCHAR2(10) NOT NULL Stock ID

    Prompt Table: STOCK_DTL

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

    Default Value: O

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

    Prompt Table: %RECNAME_EDIT