RF_ENTP_NCV_LVW

(SQL View)
 Index Back

Entitlement Plan View

Related Language view to list all Entitlement Plans that contain only Response, Restore and Service Level Entitlements

SELECT A.SETID , A.ENTITLE_PLAN_NAME , L.LANGUAGE_CD , L.DESCR FROM PS_RF_ENT_PL_HDR A , PS_RF_ENT_PL_LANG L WHERE A.SETID = L.SETID AND A.ENTITLE_PLAN_NAME = L.ENTITLE_PLAN_NAME AND A.ENTITLE_PLAN_NAME NOT IN ( SELECT B.ENTITLE_PLAN_NAME FROM PS_RF_ENTL_PL_DTL B , PS_RF_ENTITLEMENTS C WHERE A.SETID = B.SETID AND B.SETID = C.SETID AND B.ENTITLE_NAME = C.ENTITLE_NAME AND C.ENTITLE_TYPE NOT IN ('RESP', 'REST', 'PPM'))

  • Related Language Record for RF_ENTP_NCOV_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

    Default Value: OPR_DEF_TBL_RB.SETID

    Prompt Table: SP_SETID_NONVW

    2 ENTITLE_PLAN_NAME Character(10) VARCHAR2(10) NOT NULL This field represents the Entitlement Plan Name
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description