RB_EM_ROUT_HIST

(SQL Table)
 Index Back

ERMS Email Routing History

ERMS Inbound Email Routing History Table

  • Related Language Record: RB_EM_RT_HST_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MCF_EMAIL_ID Number(16,0) DECIMAL(16) NOT NULL Email Id
    2 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
    3 EMAIL_STATUS Character(4) VARCHAR2(4) NOT NULL ERMS Inbound Email Status

    Prompt Table: RB_IBEM_STAT_VW

    4 MAILBOX_ID Character(30) VARCHAR2(30) NOT NULL Mail Box Id is an Id associated with Mail Boxes
    5 LAST_GROUP_WL Character(30) VARCHAR2(30) NOT NULL Last/Current Group-level Worklist
    6 OLD_WL Character(30) VARCHAR2(30) NOT NULL Previous Worklist Value
    7 NEW_WL Character(30) VARCHAR2(30) NOT NULL New Worklist Value
    8 ROUTE_DIRECT Character(2) VARCHAR2(2) NOT NULL Routing direction field for storing worklist routing direction for routing history entries
    GG=Group to Group
    GI=Group to Individual
    IA=Initial Assignment
    IG=Individual to Group
    II=Individual to Individual
    9 IBEM_ROUTE_MTHD Character(4) VARCHAR2(4) NOT NULL Routing Method...............................
    ADDR=Address
    ANAL=Manual from Analysis
    CONT=Content
    CUST=Customer Event
    DOMA=Domain
    MANU=Manual
    THRE=Thread
    WLDF=Default Worklist
    10 IBEM_REASON_CD Character(3) VARCHAR2(3) NOT NULL Reason Code for routing changes to inbound email
    ACC=Accepted
    AOV=Ownership Overridden
    ENC=Encoding Issue
    ESC=Escalated
    MIS=Misrouted
    OTH=Other
    OVR=Oversized Email
    RBY=Routing Bypassed
    REA=Reassigned
    REQ=Requeued to Group
    ROU=Routed by Routing Engine
    11 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    12 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    13 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    14 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    15 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    16 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.
    17 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time