PA_SP_CFGPLN_VW

(SQL View)
 Index Back

SP Benefit Plan View

Service Purchase

SELECT DISTINCT C.BENEFIT_PLAN , A.DESCR , A.PENSION_TYPE FROM PS_PA_BEN_PLAN_VW A , PS_PA_SP_CNFG_BP C WHERE A.PLAN_TYPE LIKE '8%' AND A.BENEFIT_PLAN = C.BENEFIT_PLAN AND A.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_BENEF_PLAN_TBL D WHERE A.PLAN_TYPE = D.PLAN_TYPE AND A.BENEFIT_PLAN = D.BENEFIT_PLAN AND D.EFFDT <= %CurrentDateIn) AND C.EFFDT = ( SELECT MAX(E.EFFDT) FROM PS_PA_SP_CNFG_BP E WHERE C.BENEFIT_PLAN = E.BENEFIT_PLAN AND E.EFFDT <= %CurrentDateIn)

  • Related Language Record: PA_PLAN_VW_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan

    Prompt Table: PA_SP_BENPLN_VW

    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 PENSION_TYPE Character(1) VARCHAR2(1) NOT NULL Pension Type
    B=Defined Benefit
    M=Money Purchase
    N=Non Qualified
    Q=Qualified