PA_RT_OFRM_VW

(SQL View)
 Index Back

Calc Results Optional Forms Vw


SELECT emplid ,benefit_plan ,calc_name ,form_code ,guaranteed_payment ,pct_continued ,functn_result_nm ,applies_at_date ,form_long_name ,pymt_freq , l415_pmt_amt1 , l415_pmt_amt2 , l415_pmt_amt3 , l415_pmt_amt4 , l415_pmt_amt1_notx , l415_pmt_amt2_notx , l415_pmt_amt3_notx , l415_pmt_amt4_notx , pa_pmt_typ1 , pa_pmt_typ2 , pa_pmt_typ3 , pa_pmt_typ4 , ' ' , lio_age_date , pa_dep_pmt1 , pa_dep_pmt2 , pa_dep_pmt3 , pa_dep_pmt4 FROM PS_PA_CLC_OFRM_AY WHERE for_415_only <> 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan
3 CALC_NAME Character(20) VARCHAR2(20) NOT NULL Calculation Name
4 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
5 GUARANTEED_PAYMENT Number(3,0) SMALLINT NOT NULL Guaranteed Payments
6 PCT_CONTINUED Number(6,2) DECIMAL(5,2) NOT NULL Percent Continued to Survivor
7 FORM_SET Character(10) VARCHAR2(10) NOT NULL Optional Forms Set
8 APPLIES_AT_DATE Date(10) DATE Benefit Date
9 FORM_LONG_NAME Character(100) VARCHAR2(100) NOT NULL Form Long Name
10 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
11 PA_PMT_AMT1 Number(11,2) DECIMAL(10,2) NOT NULL Payment Amount 1
12 PA_PMT_AMT2 Number(11,2) DECIMAL(10,2) NOT NULL Payment Amount 2
13 PA_PMT_AMT3 Number(11,2) DECIMAL(10,2) NOT NULL Payment Amount 3
14 PA_PMT_AMT4 Number(11,2) DECIMAL(10,2) NOT NULL Payment Amount 4
15 PA_PMT_AMT1_NOTAX Number(11,2) DECIMAL(10,2) NOT NULL Pre 415 Non Taxable
16 PA_PMT_AMT2_NOTAX Number(11,2) DECIMAL(10,2) NOT NULL Amount 2 Non Taxable
17 PA_PMT_AMT3_NOTAX Number(11,2) DECIMAL(10,2) NOT NULL Amount 3 Non Taxable
18 PA_PMT_AMT4_NOTAX Number(11,2) DECIMAL(10,2) NOT NULL Amount 4 Non Taxable
19 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
20 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
21 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
22 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
23 SEL_USDB_OFRM Character(1) VARCHAR2(1) NOT NULL Select USDB Form of Payment

Y/N Table Edit

24 LIO_AGE_DATE Date(10) DATE Level Income Option Split Date
25 PA_DEP_PMT1 Character(2) VARCHAR2(2) NOT NULL Dependent/Beneficiary ID
26 PA_DEP_PMT2 Character(2) VARCHAR2(2) NOT NULL Dependent/Beneficiary ID
27 PA_DEP_PMT3 Character(2) VARCHAR2(2) NOT NULL Dependent/Beneficiary ID
28 PA_DEP_PMT4 Character(2) VARCHAR2(2) NOT NULL Dependent/Beneficiary ID