RB_IN_EM_VW(SQL View) |
Index Back |
|---|---|
Inbound Email viewERMS view displaying Inbound Email information |
| SELECT A.MCF_EMAIL_ID ,A.BUSINESS_UNIT , A.BO_ID_CUST , A.ROLE_TYPE_ID_CUST , B.BO_NAME_DISPLAY , B.BO_NAME_AC , A.BO_ID_CONTACT , A.ROLE_TYPE_ID_CNTCT , C.BO_NAME_DISPLAY , A.EMAIL_STATUS , A.PROCESS_STATE ,A.LANGUAGE_CD ,A.STRUCTURED_SW ,A.PRIORITY_NBR ,A.TMPLT_CATEGRY_ID ,A.TMPLT_TYPE_ID ,A.PRODUCT_GROUP ,A.PRODUCT_ID , A.MCF_WL_SUBJECT , A.REPLY_TO_ADDRESS , A.ASSIGNED_TO , A.LAST_GROUP_WL ,A.RB_DETAIL_STATUS ,A.EMAIL_STATUS , A.MAILBOX_ID , A.MB_DUE_DTTM , A.ROW_ADDED_DTTM ,A.CLOSED_DTTM FROM PS_RB_IN_EMAIL A ,PS_BO_NAME_PRIM_VW B ,PS_BO_NAME_PRIM_VW C WHERE A.BO_ID_CUST = B.BO_ID (+) AND A.BO_ID_CONTACT = C.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 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | BO_ID_CUST | Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |
| 4 | ROLE_TYPE_ID_CUST | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the customer |
| 5 | BO_NAME_DISPLAY | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |
| 6 | BO_NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
| 7 | BO_ID_CONTACT | Number(31,0) | DECIMAL(31) NOT NULL | This field indicates the Business Object ID for the contact. |
| 8 | ROLE_TYPE_ID_CNTCT | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the contact |
| 9 | BO_NAME_DISPLAY_2 | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |
| 10 | RB_MCF_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Interaction status code in multi function
Prompt Table: RB_IBEM_STAT_VW |
| 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 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 13 | STRUCTURED_SW | Character(1) | VARCHAR2(1) NOT NULL | Structured/Unstructured Indicator |
| 14 | PRIORITY_NBR | Number(3,0) | SMALLINT NOT NULL |
Priority
Prompt Table: RB_PRIORTY_NAME |
| 15 | TMPLT_CATEGRY_ID | Number(6,0) | INTEGER NOT NULL |
Template Category ID
Prompt Table: RBC_TEMPLT_CAT |
| 16 | TMPLT_TYPE_ID | Number(6,0) | INTEGER NOT NULL |
Template Type ID
Prompt Table: RBC_TEMPLT_TYPE |
| 17 | PRODUCT_GROUP | Character(10) | VARCHAR2(10) NOT NULL |
PRoduct Group
Prompt Table: RB_PROD_GRP_VW |
| 18 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL |
Product ID
Prompt Table: RB_P_PRODGRP_VW |
| 19 | EMAIL_SUBJECT254 | Character(254) | VARCHAR2(254) NOT NULL | Email Subject |
| 20 | REPLY_TO_ADDRESS | Character(254) | VARCHAR2(254) NOT NULL | Email Address associated with the Reply To Person |
| 21 | ASSIGNED_TO | Character(15) | VARCHAR2(15) NOT NULL |
This is a field to store assignment information.
Prompt Table: RB_WORKER |
| 22 | LAST_GROUP_WL | Character(30) | VARCHAR2(30) NOT NULL | Last/Current Group-level Worklist |
| 23 | RB_DETAIL_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Detail item status
AUT=Closed - Auto Response CAN=Closed - Canceled DUP=Closed - Duplicate OPN=Open REP=Closed - Response |
| 24 | EMAIL_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
ERMS Inbound Email Status
Prompt Table: RB_IBEM_STAT_VW |
| 25 | MAILBOX_ID | Character(30) | VARCHAR2(30) NOT NULL | Mail Box Id is an Id associated with Mail Boxes |
| 26 | MB_DUE_DTTM | DateTime(26) | TIMESTAMP | Mailbox level (or external) due date/time |
| 27 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 28 | CLOSED_DTTM | DateTime(26) | TIMESTAMP | Date Time stamp for when the case status category was changed to closed. |