VC_EE_VCOMP (SQL Table)	Index Back
Employee VC Header Record This record stores the header information regarding an employee's Variable Compensation record when a plan is administered by EE VC (as determined in the VC Plan table). This record stores the effective dated rows. Within an effective date, an employee can be enrolled in one to many Variable Compensation plans and should have at a minimum, a Target formula established for each plan.

VC_EE_VCOMP

(SQL Table)

Employee VC Header Record

This record stores the header information regarding an employee's Variable Compensation record when a plan is administered by EE VC (as determined in the VC Plan table). This record stores the effective dated rows. Within an effective date, an employee can be enrolled in one to many Variable Compensation plans and should have at a minimum, a Target formula established for each plan.

Parent Record Of VC_EE_VCOMP_DTL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date