PA_CLC_OAY_VW

(SQL View)
 Index Back

Calc Results Optional Forms


select CALC_NAME, EMPLID, BENEFIT_PLAN, FUNCTN_RESULT_NM, BASE_BENEFIT, FORM_CODE, GUARANTEED_PAYMENT, PCT_CONTINUED, FORM_LONG_NAME, FORM_AVAILABLE, QJSA_IND, FORM_FACTOR, PA_PMT_TYP1, PA_PMT_AMT1, PA_PMT_AMT1_NOTAX, PA_PMT_TYP2, PA_PMT_AMT2, PA_PMT_AMT2_NOTAX, PA_PMT_TYP3, PA_PMT_AMT3, PA_PMT_AMT3_NOTAX, PA_PMT_TYP4, PA_PMT_AMT4, PA_PMT_AMT4_NOTAX, L415_PMT_AMT1, L415_PMT_AMT1_NOTX, L415_PMT_AMT2, L415_PMT_AMT2_NOTX, L415_PMT_AMT3, L415_PMT_AMT3_NOTX, L415_PMT_AMT4, L415_PMT_AMT4_NOTX, DEFAULT_SINGLE, DEFAULT_MARRIED, SPOUSAL_CONSENT, MDIB_VIOLATION, SLA_FORM_IND, SMALL_BNFT_CASHOUT, APPLIES_AT_DATE, PYMT_FREQ, USE_IN_415 from PS_PA_CLC_OFRM_AY where for_415_only <> 'Y'

# 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 BASE_BENEFIT Character(10) VARCHAR2(10) NOT NULL Basis for optional forms
6 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
7 GUARANTEED_PAYMENT Number(3,0) SMALLINT NOT NULL Guaranteed Payments
8 PCT_CONTINUED Number(6,2) DECIMAL(5,2) NOT NULL Percent Continued to Survivor
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 QJSA_IND Character(1) VARCHAR2(1) NOT NULL Qualified Joint and Survivor
N=
Y=Qualified Joint and Survivor

Y/N Table Edit

12 FORM_FACTOR Number(11,6) DECIMAL(10,6) NOT NULL Optional Form Factor
13 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
14 PA_PMT_AMT1 Number(11,2) DECIMAL(10,2) NOT NULL Payment Amount 1
15 PA_PMT_AMT1_NOTAX Number(11,2) DECIMAL(10,2) NOT NULL Pre 415 Non Taxable
16 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
17 PA_PMT_AMT2 Number(11,2) DECIMAL(10,2) NOT NULL Payment Amount 2
18 PA_PMT_AMT2_NOTAX Number(11,2) DECIMAL(10,2) NOT NULL Amount 2 Non Taxable
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_AMT3 Number(11,2) DECIMAL(10,2) NOT NULL Payment Amount 3
21 PA_PMT_AMT3_NOTAX Number(11,2) DECIMAL(10,2) NOT NULL Amount 3 Non Taxable
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 PA_PMT_AMT4 Number(11,2) DECIMAL(10,2) NOT NULL Payment Amount 4
24 PA_PMT_AMT4_NOTAX Number(11,2) DECIMAL(10,2) NOT NULL Amount 4 Non Taxable
25 L415_PMT_AMT1 Number(11,2) DECIMAL(10,2) NOT NULL Amount 1 after 415
26 L415_PMT_AMT1_NOTX Number(11,2) DECIMAL(10,2) NOT NULL Post 415 Non Taxable
27 L415_PMT_AMT2 Number(11,2) DECIMAL(10,2) NOT NULL Amount 2 after 415
28 L415_PMT_AMT2_NOTX Number(11,2) DECIMAL(10,2) NOT NULL L415 Amt 2 Non Taxable
29 L415_PMT_AMT3 Number(11,2) DECIMAL(10,2) NOT NULL Amount 3 after 415
30 L415_PMT_AMT3_NOTX Number(11,2) DECIMAL(10,2) NOT NULL L415 Amt 3 Non Taxable
31 L415_PMT_AMT4 Number(11,2) DECIMAL(10,2) NOT NULL Amount 4 after 415
32 L415_PMT_AMT4_NOTX Number(11,2) DECIMAL(10,2) NOT NULL L415 Amt 4 Non Taxable
33 DEFAULT_SINGLE Character(1) VARCHAR2(1) NOT NULL Default Form (Single)

Default Value: N

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

Default Value: N

35 SPOUSAL_CONSENT Character(1) VARCHAR2(1) NOT NULL Spousal Consent
36 MDIB_VIOLATION Character(1) VARCHAR2(1) NOT NULL MDIB Adjustment Applied
Y=MDIB Adjustment Applied

Y/N Table Edit

Default Value: N

37 SLA_FORM_IND Character(1) VARCHAR2(1) NOT NULL SLA indicator
38 SMALL_BNFT_CASHOUT Character(1) VARCHAR2(1) NOT NULL Small Benefit Cashout
39 APPLIES_AT_DATE Date(10) DATE Benefit Date
40 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
41 USE_IN_415 Character(1) VARCHAR2(1) NOT NULL Use Formset in 415 Processing

Y/N Table Edit