RF_SO_ENT

(SQL View)
 Index Back

Service Order Entitlements

This view is for retrieving service order entitlements.

SELECT A.SETID , A.AGREEMENT_CODE , A.AGR_RENEWAL_NUM , A.AGREEMENT_LINE , A.ENTITLE_NAME , B.DESCR , B.ENTITLE_TYPE , B.ENTITLE_MINUTES , B.SERVICE_LVL_CD , B.COVERAGE_TYPE , B. AGRT_COV_PCT , B.AGRT_COV_LEN , B.AGRT_COV_UOM , B.ENTITLE_PCT FROM PS_RF_AG_LINE_ENTL A , PS_RF_ENTITLEMENTS B WHERE B.SETID = ( SELECT C.SETID FROM PS_SET_CNTRL_REC C WHERE C.SETCNTRLVALUE = A.SETID AND C.RECNAME = 'RF_ENTITLEMENTS') AND A.ENTITLE_NAME = B.ENTITLE_NAME

  • Related Language Record: RF_SO_ENT_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 AGREEMENT_CODE Character(30) VARCHAR2(30) NOT NULL This field represents the agreement code (name) for an agreement
    3 AGR_RENEWAL_NUM Number(4,0) SMALLINT NOT NULL This field represents the agreement renewal number (agreements begin at a value of one and the number is incremented with every renewal)
    4 AGREEMENT_LINE Character(10) VARCHAR2(10) NOT NULL This field records the value for the agreement line number
    5 ENTITLE_NAME Character(10) VARCHAR2(10) NOT NULL This field represents the name of the entitlement

    Prompt Table: RF_ENTITLEMENTS

    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 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
    8 ENTITLE_MINUTES Number(6,0) INTEGER NOT NULL This field represents the number of minutes for the response or restore time of an entitlement
    9 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

    Prompt Table: RF_SERVICE_LVL
    Set Control Field: SERVICE_LVL_CD

    10 COVERAGE_TYPE Character(4) VARCHAR2(4) NOT NULL This field represents the coverage type of an entitlement
    EXP=Expenses
    MAT=Material
    TIME=Time
    11 AGRT_COV_PCT Number(3,0) SMALLINT NOT NULL This field represents the agreement coverage percentage
    12 AGRT_COV_LEN Number(6,0) INTEGER NOT NULL This field represents the agreement coverage length
    13 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
    14 ENTITLE_PCT Signed Number(4,0) DECIMAL(3) NOT NULL This field represents the entitlement uplift or discount percent