ECOM_MG_HIST_TB

#	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 Record
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
5	VC_AWARD_DT	Date(10)	DATE	Award Date
6	ANNUAL_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Annual Rate
7	CHANGE_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Change Amount
8	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
9	COMPRATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Compensation Rate
10	COMP_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Compensation Frequency A=Annual B=Biweekly C=Contract D=Daily H=Hourly M=Monthly S=Semimonthly W=Weekly
11	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action Prompt Table: ACTION_TBL
12	VC_PLAN_TYPE	Character(2)	VARCHAR2(2) NOT NULL	VC Plan Type D=Discretionary Bonus G=Goal Sharing I=Stock - ISO K=Stock - NSAR N=Non-Monetary O=Other P=Profit Sharing Q=Stock - NQ R=Stock - RSA S=Stock- ISAR
13	COMP_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Compensation Source Filter showed on Compensation History Charts B=Base Salary C=Variable Cash N=Variable Non-Cash S=Stock Option
14	DESCR2	Character(30)	VARCHAR2(30) NOT NULL	Descr2
15	REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region
16	PAID_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Paid Hours
17	PAID_HRS_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Paid Work Period
18	STD_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Standard Hours
19	STD_HRS_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Standard Work Period
20	CHANGE_PCT	Signed Number(8,3)	DECIMAL(6,3) NOT NULL	Change Percent
21	VC_PLAN_ID	Character(10)	VARCHAR2(10) NOT NULL	VC Plan ID
22	VC_VALUE_AMOUNT	Number(19,6)	DECIMAL(18,6) NOT NULL	Amount
23	VC_PERF_FACTOR	Number(20,4)	DECIMAL(19,4) NOT NULL	Performance Factor