RX_ENTITLE_SS

(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 , E.DESCR , E.ENTITLE_TYPE , E.ENTITLE_MINUTES , E.SERVICE_LVL_CD , E.COVERAGE_TYPE , E.AGRT_COV_PCT , E.AGRT_COV_LEN , E.AGRT_COV_UOM , E.ENTITLE_PCT FROM PS_PROD_ITEM A , PS_RF_AG_HDR_ENTL C , PS_RF_ENTITLEMENTS E 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

  • Related Language Record: RX_ENTITLE_LVW

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 ENTITLE_TYPE Character(4) VARCHAR2(4) NOT NULL This field represents the type of entitlement
    COV=Guaranteed Coverage
    PPM=Service Level
    RESP=Guaranteed Response
    REST=Guaranteed Restore
    9 ENTITLE_MINUTES Number(6,0) INTEGER NOT NULL This field represents the number of minutes for the response or restore time of an entitlement
    10 SERVICE_LVL_CD Character(4) VARCHAR2(4) NOT NULL This field stores the Service Level Code.
    7X24=7X24
    ENH=Enhanced
    PREF=Preferred
    PREM=Premium
    STD=Standard
    11 COVERAGE_TYPE Character(4) VARCHAR2(4) NOT NULL This field represents the coverage type of an entitlement
    EXP=Expenses
    MAT=Material
    TIME=Time
    12 AGRT_COV_PCT Number(3,0) SMALLINT NOT NULL This field represents the agreement coverage percentage
    13 AGRT_COV_LEN Number(6,0) INTEGER NOT NULL This field represents the agreement coverage length
    14 AGRT_COV_UOM Character(4) VARCHAR2(4) NOT NULL This field represents agreement coverage unit of measurement
    DAY=Day
    MON=Month
    WK=Week
    YR=Year
    15 ENTITLE_PCT Signed Number(4,0) DECIMAL(3) NOT NULL This field represents the entitlement uplift or discount percent