PA_RT_PAY_DETL

(SQL Table)
Index Back

Pension Payee Detail Payments

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 Rcd Nbr
3 PA_RUN_ID Character(10) VARCHAR2(10) NOT NULL Run ID
4 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan
5 PA_PMT_NBR Number(2,0) SMALLINT NOT NULL Payment Number
6 PA_PMT_END_DT Date(10) DATE Pay Period End Date
7 PA_CHECK_DATE Date(10) DATE Check Date
8 CALC_NAME Character(20) VARCHAR2(20) NOT NULL Calculation Name
9 PYMT_FREQ Character(4) VARCHAR2(4) NOT NULL Payment Frequency
0=One Time Payment
1=Annual Payment
12=Monthly Payment
2=Semi-Annual
24=Semi-Monthly Payment
26=BiWeekly Payment
4=Quarterly
10 FORM_LONG_NAME Character(100) VARCHAR2(100) NOT NULL Form Long Name
11 FORM_CODE Character(4) VARCHAR2(4) NOT NULL Form Code
CO=Certain Only Installment
JS=Joint & Survivor Annuity
LIFE=Life Annuity
LIO=Level Income Option
LTS=Last to Survive Annuity
LUMP=Lump Sum
POP=Pop Up Annuity
REV=Reversionary Annuity
SPJS=Spouse Demonstration JS
12 GUARANTEED_PAYMENT Number(3,0) SMALLINT NOT NULL Guaranteed Payments
13 PCT_CONTINUED Number(6,2) DECIMAL(5,2) NOT NULL Percent Continued to Survivor
14 SETID Character(5) VARCHAR2(5) NOT NULL SetID
15 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
16 PA_PMT_TYPE Character(1) VARCHAR2(1) NOT NULL Payment Type
17 PA_PMT_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL Payment Amount
18 PA_ADJ_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL Adjustment Amount
19 PA_PMT_TOTAL Signed Number(13,2) DECIMAL(11,2) NOT NULL Payment Total
20 PA_PMT_AMT_NOTAX Signed Number(13,2) DECIMAL(11,2) NOT NULL Payment Amount Non Taxable
21 PA_ADJ_AMT_NOTAX Signed Number(13,2) DECIMAL(11,2) NOT NULL Adjustment Amount Non Taxable
22 PA_PMT_TOTAL_NOTAX Signed Number(13,2) DECIMAL(11,2) NOT NULL Payment Non Taxable Total
23 PA_ALT_PAYEE Character(30) VARCHAR2(30) NOT NULL Designated Payee Name