VC_CALC_WRD_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	VC_ORG_PLAN_WEIGHT	Number(6,2)	DECIMAL(5,2) NOT NULL	Org Goal Weight
3	VC_GRP_PLAN_WEIGHT	Number(6,2)	DECIMAL(5,2) NOT NULL	Group Goal Weight
4	VC_IND_PLAN_WEIGHT	Number(6,2)	DECIMAL(5,2) NOT NULL	Ind Goal Weight
5	AE_TEST_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Test Flag
6	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
7	VC_PLAN_ID	Character(10)	VARCHAR2(10) NOT NULL	VC Plan ID
8	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
9	TREE_EFFDT	Date(10)	DATE	Effective date of the Tree
10	VC_VALUE_AMOUNT	Number(19,6)	DECIMAL(18,6) NOT NULL	Amount
11	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
12	VC_PAYOUT_PRD_ID	Character(10)	VARCHAR2(10) NOT NULL	Payout Period ID
13	GB_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Group Build ID.
14	GB_GROUP_ID2	Character(15)	VARCHAR2(15) NOT NULL	Group ID
15	VC_CALC_BY_PRD_FLG	Character(1)	VARCHAR2(1) NOT NULL	Whole period / only one group
16	ERNCD	Character(3)	VARCHAR2(3) NOT NULL	Earnings Code
17	VC_ADJ_FACTOR	Number(19,3)	DECIMAL(18,3) NOT NULL	Adjustment Factor
18	VC_CALC_SOURCE	Character(2)	VARCHAR2(2) NOT NULL	Calculation Source M=Manual Calculation N=System - Minimum S=System Calculated X=System - Maximum
19	PRD_END_DT	Date(10)	DATE	Pay Period End Date
20	PRD_BGN_DT	Date(10)	DATE	Period Begin Date
21	VC_ELIG_PRO_DAYS	Number(8,3)	DECIMAL(7,3) NOT NULL	Days Eliglble In Period
22	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
23	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
24	VC_PERF_FACTOR	Number(20,4)	DECIMAL(19,4) NOT NULL	Performance Factor
25	VC_TARGET_VALUE	Number(19,6)	DECIMAL(18,6) NOT NULL	Target Value
26	VC_MINIMUM_VALUE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Minimun Value
27	VC_MAXIMUM_VALUE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Maximum Value
28	VC_CALC_AWARD	Number(19,6)	DECIMAL(18,6) NOT NULL	Calculated Award
29	VC_ADJ_AWARD	Number(19,6)	DECIMAL(18,6) NOT NULL	Adjusted Award
30	VC_SUM_TARGET	Number(19,6)	DECIMAL(18,6) NOT NULL	Sum of Target Awards
31	VC_SUM_MIN	Number(19,6)	DECIMAL(18,6) NOT NULL	Sum of Minimum Awards
32	VC_ORIGINAL_ALLOC	Number(19,6)	DECIMAL(18,6) NOT NULL	Original Allocation
33	VC_GRP_PERF_FACTOR	Number(20,4)	DECIMAL(19,4) NOT NULL	Group Perf Factor
34	GB_CHILD_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Child Group ID
35	DEC_PLACES	Number(3,0)	SMALLINT NOT NULL	Number of Decimal Places
36	ST_ROUNDING_RULE	Character(1)	VARCHAR2(1) NOT NULL	Used to determine how the shares will be rounded to the maximum decimal point. D=Round Down S=Standard Rounding U=Round Up
37	DEC_PLACES2	Number(3,0)	SMALLINT NOT NULL	Number of Decimal Places
38	VC_ROUND_RULE	Character(1)	VARCHAR2(1) NOT NULL	Rounding Rule D=Round Down S=Standard Rounding U=Round Up
39	VC_AWARD_VALUE	Number(19,6)	DECIMAL(18,6) NOT NULL	Variable Comp Award Value
40	VC_ACTUAL_AWD_UNIT	Number(15,6)	DECIMAL(14,6) NOT NULL	Actual Award
41	VC_ACTUAL_AWD_AMT	Number(19,6)	DECIMAL(18,6) NOT NULL	Actual Award as amount
42	VC_BALANCE_ALLOC	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Balance Allocation
43	VC_RESERVE_BALANCE	Number(19,6)	DECIMAL(18,6) NOT NULL	Reserve Balance
44	VC_WHERE_CLAUSE	Character(254)	VARCHAR2(254) NOT NULL	Where Clause
45	VC_CARRYOVER_BAL	Number(19,6)	DECIMAL(18,6) NOT NULL	Carryover Balance
46	PRORATE_FACTOR	Number(8,3)	DECIMAL(7,3) NOT NULL	Prorate Factor
47	GROSSUP	Character(1)	VARCHAR2(1) NOT NULL	Gross-Up Y/N Table Edit Default Value: N
48	SEPCHK_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Separate check flag. Y/N Table Edit Default Value: N
49	PIN_ERN_NUM	Number(8,0)	INTEGER NOT NULL	Pin Number Earning
50	VC_ELIG_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Eligibility Status AE=Auto Eligible AI=Auto Ineligible EP=Eligible with Proration ME=Manual Eligible MI=Manual Ineligble