PA_EACCT_ACCUM

(SQL Table)
Index Back

Employee Account History

This is an employee table for Employee Account History.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
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 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 BALANCE_INT_RATE Number(6,2) DECIMAL(5,2) NOT NULL Interest Rate
10 PRE_TAX_DED_AMT Signed Number(15,2) DECIMAL(13,2) NOT NULL Pre-tax Credit
11 PRE_TAX_DED_ADJ Signed Number(15,2) DECIMAL(13,2) NOT NULL Pre-tax Adjustment
12 PRE_TAX_DED_INT Number(14,2) DECIMAL(13,2) NOT NULL Pre-tax Interest
13 PR_TAX_DED_INT_ADJ Signed Number(15,2) DECIMAL(13,2) NOT NULL Pre-tax Interest Adjustment
14 POST_TAX_DED_AMT Signed Number(15,2) DECIMAL(13,2) NOT NULL Post-tax Credit
15 POST_TAX_DED_ADJ Signed Number(15,2) DECIMAL(13,2) NOT NULL Post-tax Adjustment
16 POST_TAX_DED_INT Number(14,2) DECIMAL(13,2) NOT NULL Post-tax Interest
17 PO_TAX_DED_INT_ADJ Signed Number(15,2) DECIMAL(13,2) NOT NULL Post-tax Interest Adjustment
18 CREDIT_INT_RATE Number(6,2) DECIMAL(5,2) NOT NULL Credit Interest Rate
19 ACCUM_PRE_TAX Number(14,2) DECIMAL(13,2) NOT NULL Pre-Tax Account Balance
20 ACCUM_PRE_TAX_INT Number(14,2) DECIMAL(13,2) NOT NULL Pre-Tax Interest Account Balance
21 ACCUM_POST_TAX Number(14,2) DECIMAL(13,2) NOT NULL Post-Tax Account Balance
22 ACCUM_POST_TAX_INT Number(14,2) DECIMAL(13,2) NOT NULL Post-Tax Interest Account Balance
23 END_BALANCE Number(14,2) DECIMAL(13,2) NOT NULL Ending Balance