WP_EE_INTEREST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	WP_AGREEMENT_ID	Character(5)	VARCHAR2(5) NOT NULL	Profit-Sharing: Agreement Identifier
2	PERIOD_ID	Character(12)	VARCHAR2(12) NOT NULL	Time Period ID
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
5	FROM_DATE	Date(10)	DATE NOT NULL	From Date
6	THRU_DATE	Date(10)	DATE NOT NULL	Thru Date
7	WP_GROSS_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Gross Amount
8	WP_NET_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Profit-Sharing Net Amount
9	WP_DEDUCTIONS_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Deductions on Interests
10	WP_INTEREST_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Interest Status A=Cancelled C=Entitled E=Error M=Manual P=Paid R=Re-invested S=Sent to Payroll
11	PAYMENT_DT	Date(10)	DATE	Payment Date
12	WP_INTEREST_FLG	Character(1)	VARCHAR2(1) NOT NULL	Profit-Sharing I=Immediate N=No Interest R=Re-Invest
13	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
14	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
15	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
16	INSTANCE	Number(3,0)	SMALLINT NOT NULL	Instance Number