RF_SERVICE_LVL

(SQL Table)
 Index Back

Service Level Table

Main Table to Define Service Levels (used as entitlements)

  • Related Language Record: RF_SRV_LVL_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 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
    3 COST_CAT_CD Character(6) VARCHAR2(6) NOT NULL Code used to define cost categories.

    Prompt Table: RF_COST_CAT
    Set Control Field: SETID

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 DISCOUNT_PERCENT2 Signed Number(5,0) DECIMAL(4) NOT NULL Discount/Uplift %
    7 MULTIPLIER Signed Number(17,2) DECIMAL(15,2) NOT NULL Multiplier
    8 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone

    Prompt Table: PSTIMEZONE

    9 FLAG_MONDAY Character(1) VARCHAR2(1) NOT NULL This field is used to record Monday as a day of service within a service level entitlement.
    N=No
    Y=Yes

    Y/N Table Edit

    10 TIME_MONDAY Time(15) TIMESTAMP Begin Time
    11 TIME_MONDAY2 Time(15) TIMESTAMP End Time
    12 FLAG_TUESDAY Character(1) VARCHAR2(1) NOT NULL This field is used to record Tuesday as a day of service within a service level entitlement.
    N=No
    Y=Yes

    Y/N Table Edit

    13 TIME_TUESDAY Time(15) TIMESTAMP Begin Time
    14 TIME_TUESDAY2 Time(15) TIMESTAMP End Time
    15 FLAG_WEDNESDAY Character(1) VARCHAR2(1) NOT NULL This field is used to record Wednesday as a day of service within a service level entitlement.
    N=No
    Y=Yes

    Y/N Table Edit

    16 TIME_WEDNESDAY Time(15) TIMESTAMP Begin Time
    17 TIME_WEDNESDAY2 Time(15) TIMESTAMP End Time
    18 FLAG_THURSDAY Character(1) VARCHAR2(1) NOT NULL This field is used to record Thursday as a day of service within a service level entitlement.
    N=No
    Y=Yes

    Y/N Table Edit

    19 TIME_THURSDAY Time(15) TIMESTAMP Begin Time
    20 TIME_THURSDAY2 Time(15) TIMESTAMP End Time
    21 FLAG_FRIDAY Character(1) VARCHAR2(1) NOT NULL This field is used to record Friday as a day of service within a service level entitlement.
    N=No
    Y=Yes

    Y/N Table Edit

    22 TIME_FRIDAY Time(15) TIMESTAMP Begin Time
    23 TIME_FRIDAY2 Time(15) TIMESTAMP End Time
    24 FLAG_SATURDAY Character(1) VARCHAR2(1) NOT NULL This field is used to record Saturday as a day of service within a service level entitlement.
    N=No
    Y=Yes

    Y/N Table Edit

    25 TIME_SATURDAY Time(15) TIMESTAMP Begin Time
    26 TIME_SATURDAY2 Time(15) TIMESTAMP End Time
    27 FLAG_SUNDAY Character(1) VARCHAR2(1) NOT NULL This field is used to record Sunday as a day of service within a service level entitlement.
    N=No
    Y=Yes

    Y/N Table Edit

    28 TIME_SUNDAY Time(15) TIMESTAMP Begin Time
    29 TIME_SUNDAY2 Time(15) TIMESTAMP End Time
    30 HOLIDAY_SCHEDULE Character(6) VARCHAR2(6) NOT NULL This is the holiday schedule field.

    Prompt Table: HOLIDAY_TBL

    31 COMMENTS_2000 Long Character(32700) CLOB Comment Text
    32 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    33 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    34 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    35 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    36 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.
    37 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time