PA_SPTYP_UNK_VW

(SQL View)
 Index Back

SP UNK Type View

Service Purchase type view to list only applicable to Unknown to System service purchase types.

SELECT A.BENEFIT_PLAN ,A.SVC_PURCHASE_TYPE ,A.OVERRIDE_ELIG ,B.DESCR ,A.CUSTOM_STMT_NAME ,A.EMPL_ACCT_FR_NAME ,A.ALLOW_COST_OVRD ,A.ALLOW_NO_COST FROM PS_PA_SP_CNFG_SPT A , PS_PA_SP_TYPE_DEFN B WHERE A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_PA_SP_CNFG_SPT WHERE BENEFIT_PLAN = A.BENEFIT_PLAN AND EFFDT <= %CurrentDateIn) AND A.SVC_PURCHASE_TYPE <> 'WDC' AND A.SVC_PURCHASE_TYPE = B.SVC_PURCHASE_TYPE

  • Related Language Record: PA_BP_SPTLNG_VW

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

    Prompt Table: PA_BEN_PLAN_VW

    2 SVC_PURCHASE_TYPE Character(4) VARCHAR2(4) NOT NULL Service Purchase Type

    Prompt Table: PA_SP_TYPE_DEFN

    3 OVERRIDE_ELIG Character(1) VARCHAR2(1) NOT NULL Sp Eligibility

    Y/N Table Edit

    Default Value: Y

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 CUSTOM_STMT_NAME Character(10) VARCHAR2(10) NOT NULL Custom Statement Name

    Prompt Table: PA_CUSTOM6_VW

    6 EMPL_ACCT_FR_NAME Character(10) VARCHAR2(10) NOT NULL Employee Contribution Account

    Prompt Table: PA_SP_EAC_FR_VW

    7 ALLOW_COST_OVRD Character(1) VARCHAR2(1) NOT NULL Allow Cost Override

    Y/N Table Edit

    8 ALLOW_NO_COST Character(1) VARCHAR2(1) NOT NULL Allow Zero Cost