VC_IND_DFT (SQL Table)	Index Back
VC Individual Default Goals This record stores defaults for individuals within a Variable Compensation plan or group within a plan. Any goal that will apply at an individual level to all members in a plan or all members in a group can be set up in this default table. These goals will be carried forward to the Individual Goals table for each employee in the plan/group.

VC_IND_DFT

(SQL Table)

VC Individual Default Goals

This record stores defaults for individuals within a Variable Compensation plan or group within a plan. Any goal that will apply at an individual level to all members in a plan or all members in a group can be set up in this default table. These goals will be carried forward to the Individual Goals table for each employee in the plan/group.

Related Language Record: VC_IND_DFT_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: VC_GROUP_VW

4 VC_GOAL_ID Character(10) VARCHAR2(10) NOT NULL Goal ID
Prompt Table: VC_GOAL_VW

5 VC_WEIGHT_PERCENT Number(6,2) DECIMAL(5,2) NOT NULL Weighting Percent

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

#	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: VC_GROUP_VW
4	VC_GOAL_ID	Character(10)	VARCHAR2(10) NOT NULL	Goal ID Prompt Table: VC_GOAL_VW
5	VC_WEIGHT_PERCENT	Number(6,2)	DECIMAL(5,2) NOT NULL	Weighting Percent
6	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description