VC_IND_GOAL

(SQL Table)
 Index Back

VC Individual Goals

This record stores individual goals and attainments for employees for a Variable Compensation plan.

  • Related Language Record: VC_IND_GOAL_LNG

  • Parent Record Of VC_IND_GOAL_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 VC_PLAN_ID Character(10) VARCHAR2(10) NOT NULL VC Plan ID

    Prompt Table: VC_PLAN_TBL

    2 VC_PAYOUT_PRD_ID Character(10) VARCHAR2(10) NOT NULL Payout Period ID

    Prompt Table: VC_PAYPRD_TBL

    3 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.

    Prompt Table: GB_GROUP_VW

    4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    6 VC_GOAL_ID Character(10) VARCHAR2(10) NOT NULL Goal ID

    Prompt Table: VC_GOAL_VW

    7 VC_NO_GOAL_IND Character(2) VARCHAR2(2) NOT NULL No Goals for this Employee

    Y/N Table Edit

    8 VC_WEIGHT_PERCENT Number(6,2) DECIMAL(5,2) NOT NULL Weighting Percent
    9 VC_PCT_ATTAINED Signed Number(7,2) DECIMAL(5,2) NOT NULL Percent Attained
    10 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254