PA_CLC_ACCT_AY

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CALC_NAME	Character(20)	VARCHAR2(20) NOT NULL	Calculation Name
2	BENEFIT_PLAN	Character(6)	VARCHAR2(6) NOT NULL	Benefit Plan
3	FUNCTN_RESULT_NM	Character(10)	VARCHAR2(10) NOT NULL	Function Result Name
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	START_DT	Date(10)	DATE	Start Date
6	END_DT	Date(10)	DATE	end date
7	LAST_PROC_DT	Date(10)	DATE	Last Proc Date
8	BEG_BALANCE	Number(14,2)	DECIMAL(13,2) NOT NULL	Beginning Balance
9	EARNINGS	Signed Number(15,2)	DECIMAL(13,2) NOT NULL	Earnings
10	CREDIT_PRD	Number(14,2)	DECIMAL(13,2) NOT NULL	Credit for Period
11	CREDIT_ADJ_PRD	Signed Number(15,2)	DECIMAL(13,2) NOT NULL	Credit Adjustments
12	CREDIT_INT_ADJ	Signed Number(15,2)	DECIMAL(13,2) NOT NULL	Interest Adjustments
13	CREDIT_INT_RATE	Number(6,2)	DECIMAL(5,2) NOT NULL	Credit Interest Rate
14	CONTRIBUTION_RATE	Number(6,2)	DECIMAL(5,2) NOT NULL	Contribution Rate
15	CONTRIB_RATE_ABOVE	Number(6,2)	DECIMAL(5,2) NOT NULL	Above Threshold Contrib Rate
16	BALANCE_INTEREST	Signed Number(15,2)	DECIMAL(13,2) NOT NULL	Balance Interest
17	BALANCE_INT_RATE	Number(6,2)	DECIMAL(5,2) NOT NULL	Interest Rate
18	ACCUM_INTEREST	Signed Number(15,2)	DECIMAL(13,2) NOT NULL	Accumulated Interest
19	ACCUM_CREDITS	Signed Number(15,2)	DECIMAL(13,2) NOT NULL	Accumulated Credits
20	END_BALANCE	Number(14,2)	DECIMAL(13,2) NOT NULL	Ending Balance