WP_EE_FUND

#	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 Rcd Nbr
5	ORDER_SEQ	Number(3,0)	SMALLINT NOT NULL	Sequence Order for Processing Default Value: 0
6	WP_GROSS_PAY	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employee Salary
7	WP_FORMULA_ID	Character(10)	VARCHAR2(10) NOT NULL	Profit Sharing Formula ID
8	WP_ROUND_RULE	Character(1)	VARCHAR2(1) NOT NULL	Rounding Rule D=Down S=Standard U=Up
9	DEC_PLACES	Number(3,0)	SMALLINT NOT NULL	Number of Decimal Places
10	WP_MAXDIS_FORM_ID	Character(10)	VARCHAR2(10) NOT NULL	Global Fund Limit Formula
11	WP_MAXSAL_FORM_ID	Character(10)	VARCHAR2(10) NOT NULL	Individ. Salary Limit Formula Prompt Table: WP_FORMULA_TBL
12	WP_MAXSAL_PRO_FLG	Character(1)	VARCHAR2(1) NOT NULL	Prorated
13	WP_MAXALC_FORM_ID	Character(10)	VARCHAR2(10) NOT NULL	Individual Alloc Limit Formula
14	WP_MAXALC_PRO_FLG	Character(1)	VARCHAR2(1) NOT NULL	Prorated
15	WP_EE_PRO_FACTOR	Number(19,6)	DECIMAL(18,6) NOT NULL	Prorate factor used in profit-sharing calculation
16	WP_SALARY_PRO_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Prorate with Salary
17	WP_DURAT_PRO_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Prorate with Working Duration
18	WP_UNIFORM_PRO_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Uniform Distribution
19	WP_TOTAL_GROSS_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Total Gross Amount
20	WP_TOTAL_NET_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Total Net Amount
21	WP_TOTIN_GROSS_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Total Interest Gross Amount
22	WP_TOTIN_NET_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Total Interest Net Amount
23	WP_GROSS_PAY_MAX	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Profit Sharing Amount
24	WP_RELEASE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Release Request A=Amount N=None T=Total Release
25	WP_GLOBAL_FUND_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Global Fund Amount
26	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: WP_AGREEMENT.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL
27	ELIG_FLG	Character(1)	VARCHAR2(1) NOT NULL	If Criteria Met E=Eligible I=Ineligible Y/N Table Edit Default Value: N