PA_ACCUMS

(SQL Table)
Index Back

Cash Balance History

This is an employee table containing Cash Balance History.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan
2 FUNCTN_RESULT_NM Character(10) VARCHAR2(10) NOT NULL Function Result Name
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 START_DATE Date(10) DATE Start Date for Gen Standing PO
5 END_DATE Date(10) DATE End Date
6 LAST_PROC_DT Date(10) DATE Last Proc Date
7 ACCUM_PERIOD Character(1) VARCHAR2(1) NOT NULL Accumulation Period
A=Employee's Anniversary Year
C=Calendar Year
M=Calendar Month
O=Other Year
P=Plan Year
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 BALANCE_INTEREST Signed Number(15,2) DECIMAL(13,2) NOT NULL Balance Interest
11 BALANCE_INT_RATE Number(6,2) DECIMAL(5,2) NOT NULL Interest Rate
12 CREDIT_PRD Number(14,2) DECIMAL(13,2) NOT NULL Credit for Period
13 CREDIT_ADJ_PRD Signed Number(15,2) DECIMAL(13,2) NOT NULL Credit Adjustments
14 CREDIT_INT_ADJ Signed Number(15,2) DECIMAL(13,2) NOT NULL Interest Adjustments
15 CREDIT_INT_RATE Number(6,2) DECIMAL(5,2) NOT NULL Credit Interest Rate
16 CONTRIBUTION_RATE Number(6,2) DECIMAL(5,2) NOT NULL Contribution Rate
17 CONTRIB_RATE_ABOVE Number(6,2) DECIMAL(5,2) NOT NULL Above Threshold Contrib 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