RB_EM_IB_VW

(SQL View)
 Index Back

Inbound Email view

Inbound Email View

SELECT B.SUBINT_OBJ_TYPE , B.OBJECTVALUE1 , A.MCF_EMAIL_ID , A.INTERACTION_ID , A.EMAIL_STATUS , A.MCF_WL_SUBJECT , A.BO_ID_CUST , A.ROLE_TYPE_ID_CUST , A.BO_ID_CONTACT , A.ROLE_TYPE_ID_CNTCT , A.PROCESS_STATE , A.REPLY_TO_ADDRESS , A.ASSIGNED_TO , NAME , A.MB_DUE_DTTM , A.WL_DUE_DTTM , A.CONTEXT_TAG , A.ROW_ADDED_DTTM , A.SLA_EXT_BASE_DTTM , A.MAILBOX_ID FROM PS_RB_EM_IB_BASE_V B , PS_RB_IN_EMAIL A , PS_RD_PERSON_NAME C WHERE B.INTERACTION_ID = A.INTERACTION_ID AND A.ASSIGNED_TO = C.PERSON_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SUBINT_OBJ_TYPE Character(4) VARCHAR2(4) NOT NULL sub-interaction object type
2 OBJECTVALUE1 Character(100) VARCHAR2(100) NOT NULL ID
3 EM_PARENT_EMAILID Number(16,0) DECIMAL(16) NOT NULL Inbound Email ID
4 INTERACTION_ID Character(15) VARCHAR2(15) NOT NULL interaction id
5 EMAIL_STATUS Character(4) VARCHAR2(4) NOT NULL ERMS Inbound Email Status

Prompt Table: RB_IBEM_STAT_VW

6 MCF_WL_SUBJECT Character(254) VARCHAR2(254) NOT NULL Subject
7 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
8 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer
9 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
10 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact
11 PROCESS_STATE Character(4) VARCHAR2(4) NOT NULL Process State for AE Processing
AUTO=Auto Responded by System
CREA=Email Instance Created
FORW=Mailbox Forwarding
PIMS=Synched Email
QUED=Queued for Routing
ROUT=Email Routed
12 REPLY_TO_ADDRESS Character(254) VARCHAR2(254) NOT NULL Email Address associated with the Reply To Person
13 ASSIGNED_TO Character(15) VARCHAR2(15) NOT NULL This is a field to store assignment information.
14 ASSIGNED_TO_F Character(70) VARCHAR2(70) NOT NULL Assigned To
15 MB_DUE_DTTM DateTime(26) TIMESTAMP Mailbox level (or external) due date/time
16 WL_DUE_DTTM DateTime(26) TIMESTAMP Worklist-level (or internal) due date/time
17 CONTEXT_TAG Character(254) VARCHAR2(254) NOT NULL Context Tag
18 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
19 SLA_EXT_BASE_DTTM DateTime(26) TIMESTAMP External Service Level Agreement Base Date/time
20 MAILBOX_ID Character(30) VARCHAR2(30) NOT NULL Mail Box Id is an Id associated with Mail Boxes