PA_SVC_TRANS

(SQL Table)
Index Back

Employee Account Adjustments

This is an employee table for Employee Account Adjustments.

# 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_SVC_FUN_VW

4 TRANSACTION_DATE Date(10) DATE TRANSACTION_DATE

Default Value: %DATE

5 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
6 SVC_ADJ_AMT Signed Number(11,6) DECIMAL(9,6) NOT NULL Service Adjustment amount.
7 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

8 EACCT_FR_NAME Character(10) VARCHAR2(10) NOT NULL This field represents a Contribution Employee Account Function Result.
9 SP_ID Number(11,0) DECIMAL(11) NOT NULL Service Purchase ID
10 PB_CALC_SVC2 Character(1) VARCHAR2(1) NOT NULL Calculate Service Adjustment
11 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

12 COMMENTS Long Character CLOB Comment