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 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
7 BEG_BALANCE Number(14,2) DECIMAL(13,2) NOT NULL Beginning Balance
8 BALANCE_INT_RATE Number(6,2) DECIMAL(5,2) NOT NULL Balance Interest Rate
9 PRE_TAX_DED_AMT Signed Number(15,2) DECIMAL(13,2) NOT NULL Consolidated Pre tax contribut
10 PRE_TAX_DED_ADJ Signed Number(15,2) DECIMAL(13,2) NOT NULL Pre Tax Contribution Adjstmnts
11 PRE_TAX_DED_INT Number(14,2) DECIMAL(13,2) NOT NULL Pre Tax Contribution Interest
12 PR_TAX_DED_INT_ADJ Signed Number(15,2) DECIMAL(13,2) NOT NULL Pre Tax Contrib Int Adjustment
13 POST_TAX_DED_AMT Signed Number(15,2) DECIMAL(13,2) NOT NULL Consolidated Post-Tax Amts
14 POST_TAX_DED_ADJ Signed Number(15,2) DECIMAL(13,2) NOT NULL Post Tax Contribution Adjstmnt
15 POST_TAX_DED_INT Number(14,2) DECIMAL(13,2) NOT NULL Post Tax Contribution Interest
16 PO_TAX_DED_INT_ADJ Signed Number(15,2) DECIMAL(13,2) NOT NULL Post Tax Contrib Int Adjustmnt
17 CREDIT_INT_RATE Number(6,2) DECIMAL(5,2) NOT NULL Credit Interest Rate
18 ACCUM_PRE_TAX Number(14,2) DECIMAL(13,2) NOT NULL Accumulated Post Tax Amount
19 ACCUM_PRE_TAX_INT Number(14,2) DECIMAL(13,2) NOT NULL Accumulated Pre Tax Interest
20 ACCUM_POST_TAX Number(14,2) DECIMAL(13,2) NOT NULL Accumulated Post Tax Amount
21 ACCUM_POST_TAX_INT Number(14,2) DECIMAL(13,2) NOT NULL Accumulated Post Tax Interest
22 END_BALANCE Number(14,2) DECIMAL(13,2) NOT NULL Ending Balance
23 PA_SVC_PRCHABLE Signed Number(11,6) DECIMAL(9,6) NOT NULL Purchasable Service
24 PA_SVC_PURCHASED Signed Number(11,6) DECIMAL(9,6) NOT NULL Purchased Service
25 PA_SVC_PRCH_ADJ Signed Number(11,6) DECIMAL(9,6) NOT NULL Purchasable Service Adjustment