PA_I_OFRM_VW

(SQL View)
 Index Back

Calc Results Optional Forms


SELECT C.CALC_NAME , A.EMPLID , A.BENEFIT_PLAN , A.FUNCTN_RESULT_NM , A.FORM_CODE , A.GUARANTEED_PAYMENT , A.PCT_CONTINUED , Z.DESCR , A.FORM_LONG_NAME , A.FORM_AVAILABLE , A.PA_PMT_TYP1 , A.PA_PMT_AMT1 , A.PA_PMT_AMT1_NOTAX , A.PA_PMT_TYP2 , A.PA_PMT_AMT2 , A.PA_PMT_AMT2_NOTAX , A.PA_PMT_TYP3 , A.PA_PMT_AMT3 , A.PA_PMT_AMT3_NOTAX , A.PA_PMT_TYP4 , A.PA_PMT_AMT4 , A.PA_PMT_AMT4_NOTAX , A.L415_PMT_AMT1 , A.L415_PMT_AMT1_NOTX , A.L415_PMT_AMT2 , A.L415_PMT_AMT2_NOTX , A.L415_PMT_AMT3 , A.L415_PMT_AMT3_NOTX , A.L415_PMT_AMT4 , A.L415_PMT_AMT4_NOTX , A.DEFAULT_SINGLE , A.DEFAULT_MARRIED , A.SPOUSAL_CONSENT , A.SLA_FORM_IND , A.SMALL_BNFT_CASHOUT , A.APPLIES_AT_DATE , A.PYMT_FREQ , USE_IN_415 FROM PS_PA_CLC_OFRM_AY A , PS_PA_FNC_RSLT_TBL Z , PS_PA_I_RSLTCLC_VW C WHERE Z.BENEFIT_PLAN = A.BENEFIT_PLAN AND Z.FUNCTN_RESULT_NM = A.FUNCTN_RESULT_NM AND C.CALC_NAME = A.CALC_NAME AND FOR_415_ONLY <> 'Y' AND (PA_PMT_AMT1 > 0.0 OR PA_PMT_AMT1_NOTAX > 0.0 OR PA_PMT_AMT2 > 0.0 OR PA_PMT_AMT2_NOTAX > 0.0 OR PA_PMT_AMT3 > 0.0 OR PA_PMT_AMT3_NOTAX > 0.0 OR PA_PMT_AMT4 > 0.0 OR PA_PMT_AMT4_NOTAX > 0.0)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CALC_NAME Character(20) VARCHAR2(20) NOT NULL Calculation Name
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan
4 FUNCTN_RESULT_NM Character(10) VARCHAR2(10) NOT NULL Function Result Name
5 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
6 GUARANTEED_PAYMENT Number(3,0) SMALLINT NOT NULL Guaranteed Payments
7 PCT_CONTINUED Number(6,2) DECIMAL(5,2) NOT NULL Percent Continued to Survivor
8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
9 FORM_LONG_NAME Character(100) VARCHAR2(100) NOT NULL Form Long Name
10 FORM_AVAILABLE Character(1) VARCHAR2(1) NOT NULL form available flag

Default Value: Y

11 PA_PMT_TYP1 Character(1) VARCHAR2(1) NOT NULL Payment Amount 1 Type
1=Retiree Amount - Pre SSRA
B=Plan Beneficiary Amount
N=Non-Spouse Beneficiary Amount
R=Retiree Amount
12 PA_PMT_AMT1 Number(11,2) DECIMAL(10,2) NOT NULL Payment Amount 1
13 PA_PMT_AMT1_NOTAX Number(11,2) DECIMAL(10,2) NOT NULL Amount 1 Non Taxable
14 PA_PMT_TYP2 Character(1) VARCHAR2(1) NOT NULL Payment Amount 2 Type
2=Retiree Amount - Post SSRA
B=Plan Beneficiary Amount
N=Non-Spouse Beneficiary Amount
S=Survivor Amount
15 PA_PMT_AMT2 Number(11,2) DECIMAL(10,2) NOT NULL Payment Amount 2
16 PA_PMT_AMT2_NOTAX Number(11,2) DECIMAL(10,2) NOT NULL Amount 2 Non Taxable
17 PA_PMT_TYP3 Character(1) VARCHAR2(1) NOT NULL Payment Amount 3 Type
3=Plan Beneficary Amount
N=Non-Spouse Beneficiary Amount
P=Pop Up Amount
S=Survivor
18 PA_PMT_AMT3 Number(11,2) DECIMAL(10,2) NOT NULL Payment Amount 3
19 PA_PMT_AMT3_NOTAX Number(11,2) DECIMAL(10,2) NOT NULL Amount 3 Non Taxable
20 PA_PMT_TYP4 Character(1) VARCHAR2(1) NOT NULL Payment Amount 4 Type
4=Duplicate Ben Amount - Ignore
N=Non-Spouse Beneficiary Amount
P=Pop Up Amount
21 PA_PMT_AMT4 Number(11,2) DECIMAL(10,2) NOT NULL Payment Amount 4
22 PA_PMT_AMT4_NOTAX Number(11,2) DECIMAL(10,2) NOT NULL Amount 4 Non Taxable
23 L415_PMT_AMT1 Number(11,2) DECIMAL(10,2) NOT NULL Amount 1 after 415
24 L415_PMT_AMT1_NOTX Number(11,2) DECIMAL(10,2) NOT NULL L415 Amt 1 Non Taxable
25 L415_PMT_AMT2 Number(11,2) DECIMAL(10,2) NOT NULL Amount 2 after 415
26 L415_PMT_AMT2_NOTX Number(11,2) DECIMAL(10,2) NOT NULL L415 Amt 2 Non Taxable
27 L415_PMT_AMT3 Number(11,2) DECIMAL(10,2) NOT NULL Amount 3 after 415
28 L415_PMT_AMT3_NOTX Number(11,2) DECIMAL(10,2) NOT NULL L415 Amt 3 Non Taxable
29 L415_PMT_AMT4 Number(11,2) DECIMAL(10,2) NOT NULL Amount 4 after 415
30 L415_PMT_AMT4_NOTX Number(11,2) DECIMAL(10,2) NOT NULL L415 Amt 4 Non Taxable
31 DEFAULT_SINGLE Character(1) VARCHAR2(1) NOT NULL Default Form (Single)

Default Value: N

32 DEFAULT_MARRIED Character(1) VARCHAR2(1) NOT NULL Default Form (Joint)

Default Value: N

33 SPOUSAL_CONSENT Character(1) VARCHAR2(1) NOT NULL Spousal Consent
34 SLA_FORM_IND Character(1) VARCHAR2(1) NOT NULL SLA indicator
35 SMALL_BNFT_CASHOUT Character(1) VARCHAR2(1) NOT NULL Small Benefit Cashout
36 APPLIES_AT_DATE Date(10) DATE Benefit Date
37 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
38 USE_IN_415 Character(1) VARCHAR2(1) NOT NULL Use Formset in 415 Processing
N=DO NOT USE THIS SET IN 415
Y=USE THIS SET IN 415