| # |
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
Prompt Table:
PA_PEN_PLAN_VW
|
| 3 |
FUNCTN_RESULT_NM |
Character(10) |
VARCHAR2(10) NOT NULL |
Function Result Name
Prompt Table:
PA_EACCT_FUN_VW
|
| 4 |
TRANSACTION_DATE |
Date(10) |
DATE |
TRANSACTION_DATE
Default Value: %DATE
|
| 5 |
SEQNUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 6 |
CONTRIB_ADJ_AMT |
Signed Number(15,2) |
DECIMAL(13,2) NOT NULL |
Contribution Adjustment amount.
|
| 7 |
INTEREST_ADJ_AMT |
Signed Number(15,2) |
DECIMAL(13,2) NOT NULL |
Interest Adjustment.
|
| 8 |
EACCT_TRAN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Type of Pension amounts.
O=Post-Tax
R=Pre-Tax
|
| 9 |
EACCT_TRAN_RESN |
Character(3) |
VARCHAR2(3) NOT NULL |
Indicates the type of Employee Account adjustment.
CAJ=Credit Adjustment
CIJ=Credit and Interest Adjust
IAJ=Interest Adjustment
RFF=Refund, Interest Forfeiture
RFI=Refund with Interest
RPI=Repayment with Interest
SPD=Cancel Balance
SRF=Refund of Payment
SRV=Reversal of Payment
SVP=Purchasable Service Adjustment
|
| 10 |
TRANS_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
This field stores the status of the processing of the adjustment by Periodic Process.
A=Applied
P=Pending
T=Temporary
Default Value: P
|
| 11 |
PA_SVC_PRCH_ADJ |
Signed Number(11,6) |
DECIMAL(9,6) NOT NULL |
This field stores the adjustment amount corresponding to a purchase of service in Pensions.
|
| 12 |
SERVICE_FR_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
Service Function Result.
Prompt Table:
PA_DFN_SVC_VW
|
| 13 |
EACCT_FR_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
This field represents a Contribution Employee Account Function Result.
|
| 14 |
SP_ID |
Number(11,0) |
DECIMAL(11) NOT NULL |
Service Purchase ID
|
| 15 |
PB_CALC_SVC |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculate Purchasable Service
|
| 16 |
PA_TRANS_COMMENT |
Character(1) |
VARCHAR2(1) NOT NULL |
This field identifies the type of Employee Account adjustment.
O=Online
P=SP-Service Purchase
S=Sub-Account Activity
W=Withdrawal Request
Default Value: O
|
| 17 |
COMMENTS |
Long Character |
CLOB |
Comment
|