RX_ENTITLE_LVW

(SQL View)
 Index Back

View to get Entitlements

This view is used to pull Entitlements for a given Agreement Product.

SELECT A.SETID PROD_SETID , A.PRODUCT_ID , A.AGREEMENT_SETID , A.AGREEMENT_CODE , E.SETID ENTITLE_SETID , E.ENTITLE_NAME ,G.LANGUAGE_CD , E.DESCR FROM PS_PROD_ITEM A , PS_RF_AG_HDR_ENTL C , PS_RF_ENTITLEMENTS E ,PS_RF_ENTITLE_LANG G WHERE A.AGREEMENT_SETID = C.SETID AND A.AGREEMENT_CODE = C.AGREEMENT_CODE AND C.AGR_RENEWAL_NUM = 1 AND E.SETID = ( SELECT F.SETID FROM PS_SET_CNTRL_REC F WHERE F.SETCNTRLVALUE = A.AGREEMENT_SETID AND F.RECNAME = 'RF_ENTITLEMENTS') AND C.ENTITLE_NAME = E.ENTITLE_NAME AND E.SETID=G.SETID AND E.ENTITLE_NAME=G.ENTITLE_NAME

  • Related Language Record for RX_ENTITLE_SS

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROD_SETID Character(5) VARCHAR2(5) NOT NULL Product SET ID
    2 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    3 AGREEMENT_SETID Character(5) VARCHAR2(5) NOT NULL AGREEMENT_SETID field is added to the PROD_ITEM record. This is because we may select a template from a different SETID than the product definition
    4 AGREEMENT_CODE Character(30) VARCHAR2(30) NOT NULL This field represents the agreement code (name) for an agreement
    5 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
    6 ENTITLE_NAME Character(10) VARCHAR2(10) NOT NULL This field represents the name of the entitlement
    7 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description