| # |
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_PEN_PLAN_VW
|
| 4 |
PA_PMT_NBR |
Number(2,0) |
SMALLINT NOT NULL |
Payment Number
|
| 5 |
FORM_SET |
Character(10) |
VARCHAR2(10) NOT NULL |
Optional Forms Set
Prompt Table:
PA_CLC_SET_VW
|
| 6 |
CALC_NAME |
Character(20) |
VARCHAR2(20) NOT NULL |
Calculation Name
Prompt Table:
PA_CLC_OF_EDIT
|
| 7 |
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
|
| 8 |
GUARANTEED_PAYMENT |
Number(3,0) |
SMALLINT NOT NULL |
Guaranteed Payments
|
| 9 |
PCT_CONTINUED |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Percent Continued to Survivor
|
| 10 |
APPLIES_AT_DATE |
Date(10) |
DATE |
Benefit Date
|
| 11 |
FORM_LONG_NAME |
Character(100) |
VARCHAR2(100) NOT NULL |
Form Long Name
|
| 12 |
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
|
| 13 |
PA_PMT_AMT1 |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Payment Amount 1
|
| 14 |
PA_PMT_AMT2 |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Payment Amount 2
|
| 15 |
PA_PMT_AMT3 |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Payment Amount 3
|
| 16 |
PA_PMT_AMT4 |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Payment Amount 4
|
| 17 |
PA_PMT_AMT1_NOTAX |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Pre 415 Non Taxable
|
| 18 |
PA_PMT_AMT2_NOTAX |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Amount 2 Non Taxable
|
| 19 |
PA_PMT_AMT3_NOTAX |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Amount 3 Non Taxable
|
| 20 |
PA_PMT_AMT4_NOTAX |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Amount 4 Non Taxable
|
| 21 |
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
|
| 22 |
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
|
| 23 |
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
|
| 24 |
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
|
| 25 |
LIO_AGE_DATE |
Date(10) |
DATE |
Level Income Option Split Date
|
| 26 |
PA_DEP_PMT1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Dependent/Beneficiary ID
|
| 27 |
PA_DEP_PMT2 |
Character(2) |
VARCHAR2(2) NOT NULL |
Dependent/Beneficiary ID
|
| 28 |
PA_DEP_PMT3 |
Character(2) |
VARCHAR2(2) NOT NULL |
Dependent/Beneficiary ID
|
| 29 |
PA_DEP_PMT4 |
Character(2) |
VARCHAR2(2) NOT NULL |
Dependent/Beneficiary ID
|