RF_ENTITLEMENTS

(SQL Table)
 Index Back

Entitlements Definition

Main record used for Entitlement Definitions

  • Related Language Record: RF_ENTITLE_LANG

    • # 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 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
    12 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    13 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    14 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    15 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    16 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    17 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time