RB_ERMS_VOL_RPT

(SQL Table)
 Index Back

ERMS report

CRM ERMS table used to store email volumn information

  • 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 MAILBOX_ID Character(30) VARCHAR2(30) NOT NULL Mail Box Id is an Id associated with Mail Boxes

    Prompt Table: RB_MB_RPT_VW

    9 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL PRoduct Group

    Prompt Table: RB_RPT_PRDGR_VW

    10 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

    Prompt Table: RB_RPT_PROD_VW

    11 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

    12 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