RB_CHAT_VOL_RPT

(SQL Table)
 Index Back

Chat report

CRM ERMS table storing information about chat volumn report

  • Parent record: RB_REPORT_WRK

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 START_DATE Date(10) DATE NOT NULL Start Date for Gen Standing PO
    4 END_DATE Date(10) DATE NOT NULL End date field to store an end date.
    5 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

    Prompt Table: RB_PRSN_NM_VW

    6 GROUP_NAME Character(30) VARCHAR2(30) NOT NULL Contact Management - Group Name

    Prompt Table: RB_WF_GRP_NM_VW

    7 RB_RPT_GRP_WL_NAME Character(30) VARCHAR2(30) NOT NULL Group Worklist Nameg

    Prompt Table: RB_WF_GRP_NM_VW

    8 PERIOD_FLG Character(4) VARCHAR2(4) NOT NULL Radio Button field for alowing the user to select between running a report hourly or daily/weekly/monthly
    DAY=Daily
    HOUR=Hourly
    MON=Monthly
    WEEK=Weekly

    Default Value: DAY

    9 GROUP_BY Character(4) VARCHAR2(4) NOT NULL Dropdown list for Chat / Email Reports. In order to list the field values to sort on.
    EDT=End Date
    GRP=Group Name
    MBOX=Mailbox
    PRD=Product
    PRDG=Product Group
    QUE=Queue
    SDT=Start Date
    UID=Person ID
    WLST=Worklist

    Default Value: SDT