RF_ENTL_NCOV_VW

(SQL View)
 Index Back

Help Desk Entitlement view

Entitlements that are allowed for Internal (Help Desk) agreements

SELECT SETID , ENTITLE_NAME , ENTITLE_TYPE , DESCR , TIMEZONE , HOLIDAY_SCHEDULE , HOLIDAY_DESCR , ENTITLE_PCT FROM PS_RF_ENTL_VW WHERE ENTITLE_TYPE IN ('RESP', 'REST', 'PPM')

  • Related Language Record: RF_ENTL_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_NAME Character(10) VARCHAR2(10) NOT NULL This field represents the name of the entitlement
    3 ENTITLE_TYPE_INT Character(4) VARCHAR2(4) NOT NULL This field represents the type of entitlement used. It differs from the regular Entitle Type field by not having the translate value for coverage, which is not desired for internal agreements.
    PPM=Service Level
    RESP=Guaranteed Response
    REST=Guaranteed Restore
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone
    6 HOLIDAY_SCHEDULE Character(6) VARCHAR2(6) NOT NULL This is the holiday schedule field.

    Prompt Table: HOLIDAY_TBL

    7 HOLIDAY_DESCR Character(30) VARCHAR2(30) NOT NULL Holiday Schedule Description field.
    8 ENTITLE_PCT Signed Number(4,0) DECIMAL(3) NOT NULL This field represents the entitlement uplift or discount percent