RB_CHAT_PROFILE

(SQL Table)
 Index Back

Chat Profile Setup Table

CRM ERMS table storing Chat Profile setup information

  • Related Language Record: RB_CHAT_PRO_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RB_CHAT_PROFILE Character(30) VARCHAR2(30) NOT NULL Chat Profile field used by Chat application
    2 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    3 RB_CHAT_STATUS Character(1) VARCHAR2(1) NOT NULL Chat Profile Status......
    A=Active
    I=Inactive

    Default Value: A

    4 REQUIRED_FLAG Character(1) VARCHAR2(1) NOT NULL Required
    N=No
    Y=Yes

    Default Value: N

    5 RB_CHAT_NAME_FLG Character(1) VARCHAR2(1) NOT NULL Allow Guest Input Name indicator

    Y/N Table Edit

    Default Value: Y

    6 ENABLE_FLG Character(1) VARCHAR2(1) NOT NULL Enabled field.

    Y/N Table Edit

    Default Value: N

    7 KB_APPLICATION_ID Character(15) VARCHAR2(15) NOT NULL Used to identify the unique NLP application

    Prompt Table: RBN_APPDEFN

    8 KB_ID Character(15) VARCHAR2(15) NOT NULL Knowledge Base ID
    9 KB_THRESHOLD Number(6,2) DECIMAL(5,2) NOT NULL Used to indicate the threshold
    10 KB_MAX_RETURN Number(3,0) SMALLINT NOT NULL Used to indicate maximum returned suggestions
    11 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).

    Default Value: EMPLOYEE

    Prompt Table: PORTAL_NAME_VW

    12 NODE_NAME Character(40) VARCHAR2(40) NOT NULL Node Name

    Default Value: CRM

    Prompt Table: RB_NODE_NAME_VW

    13 RB_AGENT_SKILL Character(3) VARCHAR2(3) NOT NULL CRm Agent Skill Level
    10=10 - Low
    20=20 - Medium
    30=30 - High

    Default Value: 10

    14 RB_CHAT_PRIORITY Character(3) VARCHAR2(3) NOT NULL Chat Prority
    10=10 - Low
    20=20 - Medium
    30=30 - High

    Default Value: 10