RF_SLVL_COSTCAT

(SQL Table)
 Index Back

Cost category & Service level

Service Level / Cost Category - Cross Reference Table.

  • Related Language Record: RF_SERV_CC_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.

    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.

    Default Value: RF_SERVICE_LVL.COST_CAT_CD

    Prompt Table: RF_COST_CAT

    4 DAYOFTHEWEEK Character(2) VARCHAR2(2) NOT NULL Specifying the days of the week
    1=Sunday
    2=Monday
    3=Tuesday
    4=Wednesday
    5=Thursday
    6=Friday
    7=Saturday
    5 START_TIME Time(15) TIMESTAMP NOT NULL Start of Shift
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    8 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone

    Prompt Table: PSTIMEZONE

    9 END_TIME Time(15) TIMESTAMP NOT NULL End of Shift
    10 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    11 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    12 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    13 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    14 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.
    15 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time