WP_PSHARING_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
5	WP_AGREEMENT_ID	Character(5)	VARCHAR2(5) NOT NULL	Profit-Sharing: Agreement Identifier
6	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
7	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
8	WP_AGRT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Agreement Type S=Profit Sharing W=Worker's Participation
9	WP_SURPLUS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Profit Sharing Surplus C=Carryover I=Immediate Re-Share N=None Default Value: C
10	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
11	PERIOD_ID	Character(12)	VARCHAR2(12) NOT NULL	Reference Period
12	FISCAL_BEGIN_DT	Date(10)	DATE	Fiscal Begin Date
13	FISCAL_END_DT	Date(10)	DATE	Fiscal End Date
14	DURATION	Number(5,0)	INTEGER NOT NULL	Recurrence Duration Default Value: 5
15	DURATION_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Type of Duration D=Days M=Months Y=Years Default Value: Y
16	WP_REINIT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Re-Initialize ? Y/N Table Edit Default Value: N
17	IF_FLAG	Character(1)	VARCHAR2(1) NOT NULL	If flag
18	WP_GROSS_PAY	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employee Salary
19	WP_GROSS_PAY_MAX	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Profit Sharing Amount
20	WP_BASE	Number(19,6)	DECIMAL(18,6) NOT NULL	Base used in Profit-Sharing Calculation
21	WP_EESURPLUS	Number(19,6)	DECIMAL(18,6) NOT NULL	Surplus by employee used in Profit-Sharing Calculation
22	WP_ALLOCATED	Number(19,6)	DECIMAL(18,6) NOT NULL	Allocated Sum for Profit-Sharing
23	WP_MAXDIS_FORM_ID	Character(10)	VARCHAR2(10) NOT NULL	Global Fund Limit Formula
24	WP_MAXSAL_FORM_ID	Character(10)	VARCHAR2(10) NOT NULL	Individ. Salary Limit Formula
25	WP_MAXALC_FORM_ID	Character(10)	VARCHAR2(10) NOT NULL	Individual Alloc Limit Formula
26	WP_MAXSAL_PRO_FLG	Character(1)	VARCHAR2(1) NOT NULL	Prorated
27	WP_MAXALC_PRO_FLG	Character(1)	VARCHAR2(1) NOT NULL	Prorated
28	WP_SALARY_PRO_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Prorate with Salary
29	WP_DURAT_PRO_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Prorate with Working Duration
30	WP_UNIFORM_PRO_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Uniform Distribution
31	WP_GLOBAL_FUND_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Global Fund Amount
32	WP_GROSS_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Gross Amount
33	WP_EE_PRO_FACTOR	Number(19,6)	DECIMAL(18,6) NOT NULL	Prorate factor used in profit-sharing calculation
34	WP_PRORATE_FACTOR	Number(19,6)	DECIMAL(18,6) NOT NULL	Sum of Proration Factors for Profit-Sharing
35	WP_ROUND_RULE	Character(1)	VARCHAR2(1) NOT NULL	Rounding Rule D=Down S=Standard U=Up
36	DEC_PLACES	Number(3,0)	SMALLINT NOT NULL	Number of Decimal Places
37	WP_VALUE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Variable Value
38	PAYMENT_DT	Date(10)	DATE	Payment Date
39	WP_FUND_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Profit-Sharing: This field determines the status of the related funds. A=Available C=Cancelled E=Error N=Posted to Account P=Paid R=Request Payment S=Sent to Payroll T=Entitled X=Transfer to Account
40	WP_VALUE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Value Type M=Monetary N=Numeric Default Value: N
41	COUNTER	Number(10,0)	DECIMAL(10) NOT NULL	Counter
42	WP_ITERATION	Number(2,0)	SMALLINT NOT NULL	Iteration Field for Profit-Sharing
43	WP_FORMULA_ID	Character(10)	VARCHAR2(10) NOT NULL	Profit Sharing Formula ID
44	WP_TAKEOVER_AMT	Number(19,6)	DECIMAL(18,6) NOT NULL	Carry Over Amount