| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 CALC_NAME |
Character(20) |
VARCHAR2(20) NOT NULL |
Calculation Name
|
| 2 |
CALC_SEQ_NUM |
Number(9,0) |
DECIMAL(9) NOT NULL |
Calc Seq Num
|
| 3 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 4 |
BENEFIT_PLAN |
Character(6) |
VARCHAR2(6) NOT NULL |
Benefit Plan
|
| 5 |
FUNCTN_RESULT_NM |
Character(10) |
VARCHAR2(10) NOT NULL |
Function Result Name
|
| 6 |
BASE_BENEFIT |
Character(10) |
VARCHAR2(10) NOT NULL |
Basis for optional forms
|
| 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 |
FORM_LONG_NAME |
Character(100) |
VARCHAR2(100) NOT NULL |
Form Long Name
|
| 11 |
FORM_AVAILABLE |
Character(1) |
VARCHAR2(1) NOT NULL |
form available flag
Default Value: Y
|
| 12 |
QJSA_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Qualified Joint and Survivor
N=
Y=Qualified Joint and Survivor
Y/N Table Edit
|
| 13 |
FORM_FACTOR |
Number(11,6) |
DECIMAL(10,6) NOT NULL |
Optional Form Factor
|
| 14 |
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
|
| 15 |
PA_PMT_AMT1 |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Payment Amount 1
|
| 16 |
PA_PMT_AMT1_NOTAX |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Pre 415 Non Taxable
|
| 17 |
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
|
| 18 |
PA_PMT_AMT2 |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Payment Amount 2
|
| 19 |
PA_PMT_AMT2_NOTAX |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Amount 2 Non Taxable
|
| 20 |
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
|
| 21 |
PA_PMT_AMT3 |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Payment Amount 3
|
| 22 |
PA_PMT_AMT3_NOTAX |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Amount 3 Non Taxable
|
| 23 |
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
|
| 24 |
PA_PMT_AMT4 |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Payment Amount 4
|
| 25 |
PA_PMT_AMT4_NOTAX |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Amount 4 Non Taxable
|
| 26 |
DEFAULT_SINGLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Form (Single)
Default Value: N
|
| 27 |
DEFAULT_MARRIED |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Form (Joint)
Default Value: N
|
| 28 |
SPOUSAL_CONSENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Spousal Consent
|
| 29 |
MDIB_VIOLATION |
Character(1) |
VARCHAR2(1) NOT NULL |
Violates 401(a)(9) MDIB Rules
Y=MDIB Adjustment Applied
Default Value: N
|
| 30 |
SLA_FORM_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
SLA indicator
|
| 31 |
SMALL_BNFT_CASHOUT |
Character(1) |
VARCHAR2(1) NOT NULL |
Small Benefit Cashout
|
| 32 |
APPLIES_AT_DATE |
Date(10) |
DATE |
Benefit Date
|
| 33 |
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
|
| 34 |
USE_IN_415 |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Formset in 415 Processing
Y/N Table Edit
|
| 35 |
L415_PMT_AMT1 |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Amount 1 after 415
|
| 36 |
L415_PMT_AMT1_NOTX |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Post 415 Non Taxable
|
| 37 |
L415_PMT_AMT2 |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Amount 2 after 415
|
| 38 |
L415_PMT_AMT2_NOTX |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
L415 Amt 2 Non Taxable
|
| 39 |
L415_PMT_AMT3 |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Amount 3 after 415
|
| 40 |
L415_PMT_AMT3_NOTX |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
L415 Amt 3 Non Taxable
|
| 41 |
L415_PMT_AMT4 |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Amount 4 after 415
|
| 42 |
L415_PMT_AMT4_NOTX |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
L415 Amt 4 Non Taxable
|
| 43 |
DEPENDENT_BENEF |
Character(2) |
VARCHAR2(2) NOT NULL |
Dependent Benefit
01=default
|
| 44 |
L415_DEFINITION |
Character(10) |
VARCHAR2(10) NOT NULL |
415 Limit Definition
|
| 45 |
PRECEDENCE_ORDER |
Number(3,0) |
SMALLINT NOT NULL |
Order of 415 reduction
|
| 46 |
PRORATION_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Proration Percent
|
| 47 |
USER_REDUCTION |
Number(3,0) |
SMALLINT NOT NULL |
User reduction
|
| 48 |
FOR_415_ONLY |
Character(1) |
VARCHAR2(1) NOT NULL |
For 415 only
Default Value: N
|
| 49 |
LIO_AGE_DATE |
Date(10) |
DATE |
Level Income Option Split Date
|
| 50 |
PA_DEP_PMT1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Dependent/Beneficiary ID
|
| 51 |
PA_DEP_PMT2 |
Character(2) |
VARCHAR2(2) NOT NULL |
Dependent/Beneficiary ID
|
| 52 |
PA_DEP_PMT3 |
Character(2) |
VARCHAR2(2) NOT NULL |
Dependent/Beneficiary ID
|
| 53 |
PA_DEP_PMT4 |
Character(2) |
VARCHAR2(2) NOT NULL |
Dependent/Beneficiary ID
|