WCS_ECM_ILD_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUDGET_ID	Character(10)	VARCHAR2(10) NOT NULL	Budget ID
3	BUDGET_START_DT	Date(10)	DATE	Budget Period Start Date
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
6	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
7	VC_PLAN_ID	Character(10)	VARCHAR2(10) NOT NULL	VC Plan ID
8	VC_PAYOUT_PRD_ID	Character(10)	VARCHAR2(10) NOT NULL	Payout Period ID
9	VC_AWARD_DT	Date(10)	DATE	Award Date
10	VC_AWARD_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Award Status A=Approved C=Cancelled D=Ready to Submit E=Error I=Initial Calculation J=Rejected P=Paid/Granted R=Recommended S=Submitted T=Accepted
11	VC_ADJ_AWARD	Number(19,6)	DECIMAL(18,6) NOT NULL	Adjusted Award
12	VC_ACTUAL_AWD_AMT	Number(19,6)	DECIMAL(18,6) NOT NULL	Actual Award as amount
13	VC_ACTUAL_AWD_UNIT	Number(15,6)	DECIMAL(14,6) NOT NULL	Actual Award
14	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
15	VC_AWARD_VALUE	Number(19,6)	DECIMAL(18,6) NOT NULL	Variable Comp Award Value
16	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
17	JOB_EFFDT	Date(10)	DATE	Job Effective Date
18	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action
19	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code
20	COMP_EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Compensation Eff Sequence
21	COMP_RATECD	Character(6)	VARCHAR2(6) NOT NULL	Comp Rate Code
22	COMPRATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Compensation Rate