PA_RT_ADJ

(SQL Table)
Index Back

Payment Adjustments

This is an employee table for Retiree Admin.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 PA_RUN_ID Character(10) VARCHAR2(10) NOT NULL Run ID
4 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan

Prompt Table: PA_PEN_PLAN_VW

5 PA_PMT_NBR Number(2,0) SMALLINT NOT NULL Payment Number

Default Value: 1

6 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

7 PA_SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence Number

Default Value: 1

8 PA_ADJ_RSN Character(1) VARCHAR2(1) NOT NULL Adjustment Reason
A=Retroactive Adjustment
I=Interest
M=Partial Month
O=Other
R=Recalculation

Default Value: I

9 PA_ADJ_TYP Character(1) VARCHAR2(1) NOT NULL Adjustment Type
B=Balance Adjustment
O=Single Payment

Default Value: O

10 PA_ADJ_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL Adjustment Amount
11 PA_ADJ_AMT_NOTAX Signed Number(13,2) DECIMAL(11,2) NOT NULL Adjustment Amount Non Taxable
12 PA_PMT_END_DT Date(10) DATE Pay Period End Date
13 PA_CHECK_DATE Date(10) DATE Check Date
14 SETID Character(5) VARCHAR2(5) NOT NULL SetID
15 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
16 PA_POSTED_SW Character(1) VARCHAR2(1) NOT NULL Payment Posted

Y/N Table Edit

Default Value: N

17 COMMENTS Long Character CLOB Comment