RF_ENTP_NCOV_VW

(SQL View)
 Index Back

Entitlement Plan View

Lists all Entitlement Plans that contain only Response, Restore and Service Level Entitlements

SELECT A.SETID , A.ENTITLE_PLAN_NAME , A.DESCR FROM PS_RF_ENT_PL_HDR A WHERE 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: RF_ENTP_NCV_LVW

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description