RF_SO_ENT_DISP

(SQL View)
 Index Back

Service Order Entitlements

This view is for displaying service order entitlements.

SELECT A.SETID , 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_EN_DI_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_NAME Character(10) VARCHAR2(10) NOT NULL This field represents the name of the entitlement

    Prompt Table: RF_ENTITLEMENTS

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

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