| # |
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 |
BENEFIT_PLAN |
Character(6) |
VARCHAR2(6) NOT NULL |
Benefit Plan
Prompt Table:
PA_RT_FORM_VW
|
| 4 |
PA_PMT_NBR |
Number(2,0) |
SMALLINT NOT NULL |
Payment Number
Default Value: 1
Prompt Table:
PA_RT_EMP_FORM
|
| 5 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 6 |
PA_PMT_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Status
A=Active Payment
C=Stopped Payment
D=Deferred Payment
S=Suspended Payment
Default Value: A
|
| 7 |
PA_PMT_RSN |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Reason
B=Beneficiary
C=Result of COLA Adjustment
M=Manually Entered
O=Overridden
S=System Calculated
|
| 8 |
CALC_NAME |
Character(20) |
VARCHAR2(20) NOT NULL |
Calculation Name
Prompt Table:
PA_CLC_EMP_EDIT
|
| 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
Prompt Table:
SETID_TBL
|
| 15 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
VENDOR_PROV_VW
|
| 16 |
PA_PMT_CHOICE |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Choice
|
| 17 |
PA_PMT_TYP1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Type 1
1=Retiree Amount - Pre SSRA
B=Plan Beneficiary Amount
N=Non-Spouse Beneficiary Amount
R=Retiree Amount
|
| 18 |
PA_PMT_TYP2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Type 2
2=Retiree Amount - Post SSRA
B=Plan Beneficiary Amount
N=Non-Spouse Beneficiary Amount
S=Survivor Amount
|
| 19 |
PA_PMT_TYP3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Type 3
3=Plan Beneficary Amount
N=Non-Spouse Beneficiary Amount
P=Pop Up Amount
S=Survivor
|
| 20 |
PA_PMT_TYP4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Type 4
4=Duplicate Ben Amount - Ignore
N=Non-Spouse Beneficiary Amount
P=Pop Up Amount
|
| 21 |
PA_PMT_AMT1 |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Payment Amount 1
|
| 22 |
PA_PMT_AMT2 |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Payment Amount 2
|
| 23 |
PA_PMT_AMT3 |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Payment Amount 3
|
| 24 |
PA_PMT_AMT4 |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Payment Amount 4
|
| 25 |
PA_PMT_AMT1_NOTAX |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Pre 415 Non Taxable
|
| 26 |
PA_PMT_AMT2_NOTAX |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Amount 2 Non Taxable
|
| 27 |
PA_PMT_AMT3_NOTAX |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Amount 3 Non Taxable
|
| 28 |
PA_PMT_AMT4_NOTAX |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Amount 4 Non Taxable
|
| 29 |
PA_ALT_PAYEE |
Character(30) |
VARCHAR2(30) NOT NULL |
Designated Payee Name
|
| 30 |
DELETE_ON_SAVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Select for Delete
N=Do not Delete
Y=Mark to Delete
|
| 31 |
ROLLOVER_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Rollover
Y/N Table Edit
Default Value: N
|
| 32 |
COMMENTS |
Long Character |
CLOB |
Comment
|