RB_IN_EM_VW1 (SQL View)	Index Back
Inbound Email view Inbound Email View

RB_IN_EM_VW1

(SQL View)

Inbound Email view

Inbound Email View

SELECT A.MCF_EMAIL_ID , A.BO_ID_CUST , A.ROLE_TYPE_ID_CUST , B.BO_NAME , A.BO_ID_CONTACT , A.ROLE_TYPE_ID_CNTCT , B.BO_NAME , A.EMAIL_STATUS , A.PROCESS_STATE , A.MCF_WL_SUBJECT , A.REPLY_TO_ADDRESS , A.ASSIGNED_TO , A.MAILBOX_ID , A.MB_DUE_DTTM , A.ROW_ADDED_DTTM FROM PS_RB_IN_EMAIL A , PS_RB_IBEM_NAME_VW B WHERE A.BO_ID_CUST = B.BO_ID (+)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 MCF_EMAIL_ID Number(16,0) DECIMAL(16) NOT NULL Email Id

2 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.

3 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer

4 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object

5 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.

6 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact

7 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL The individual contact name associated with a given bank/counterparty.

8 RB_MCF_STATUS Character(4) VARCHAR2(4) NOT NULL Interaction status code in multi function
Prompt Table: RB_IBEM_STAT_VW

9 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

10 EMAIL_SUBJECT254 Character(254) VARCHAR2(254) NOT NULL Email Subject

11 REPLY_TO_ADDRESS Character(254) VARCHAR2(254) NOT NULL Email Address associated with the Reply To Person

12 ASSIGNED_TO Character(15) VARCHAR2(15) NOT NULL This is a field to store assignment information.

13 MAILBOX_ID Character(30) VARCHAR2(30) NOT NULL Mail Box Id is an Id associated with Mail Boxes

14 MB_DUE_DTTM DateTime(26) TIMESTAMP Mailbox level (or external) due date/time

15 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	MCF_EMAIL_ID	Number(16,0)	DECIMAL(16) NOT NULL	Email Id
2	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
3	ROLE_TYPE_ID_CUST	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the customer
4	BO_NAME	Character(50)	VARCHAR2(50) NOT NULL	Name Description of Business Object
5	BO_ID_CONTACT	Number(31,0)	DECIMAL(31) NOT NULL	This field indicates the Business Object ID for the contact.
6	ROLE_TYPE_ID_CNTCT	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the contact
7	CONTACT_NAME	Character(50)	VARCHAR2(50) NOT NULL	The individual contact name associated with a given bank/counterparty.
8	RB_MCF_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Interaction status code in multi function Prompt Table: RB_IBEM_STAT_VW
9	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
10	EMAIL_SUBJECT254	Character(254)	VARCHAR2(254) NOT NULL	Email Subject
11	REPLY_TO_ADDRESS	Character(254)	VARCHAR2(254) NOT NULL	Email Address associated with the Reply To Person
12	ASSIGNED_TO	Character(15)	VARCHAR2(15) NOT NULL	This is a field to store assignment information.
13	MAILBOX_ID	Character(30)	VARCHAR2(30) NOT NULL	Mail Box Id is an Id associated with Mail Boxes
14	MB_DUE_DTTM	DateTime(26)	TIMESTAMP	Mailbox level (or external) due date/time
15	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.