MCF_EMAIL_IDP=Spam
S=Structured E-Mail
U=Unstructured E-mail
0=Queued For Content Analysis
1=Collection Built
2=Content Analysis Processing
3=Complete
RB_UNST_QUEUE(SQL View) |
Index Back |
|---|---|
RB_UNST_QUEUEView on RB_CLASSISFY_TBL, MCFEM_MAIL_PART and RB_IN_EMAIL used for Verity Collection Build process and Routing Engine. |
| SELECT ET.MCF_EMAIL_ID , ET.MAILBOX_ID ,Q.MAIL_TYPE , ET.FROM_ADDRESS , ET.BO_ID_CONTACT , ET.BO_ID_CUST , ET.ROLE_TYPE_ID_CUST , ET.ROLE_TYPE_ID_CNTCT , Q.CLASSIFY_STATUS , ET.MCF_EMAIL_TEXT FROM PS_RB_CLASSIFY_TBL Q , PS_RB_MAILBOX_DEFN M , PS_RB_TEST_EMAIL ET WHERE Q.MCF_EMAIL_ID = Et.MCF_EMAIL_ID AND ET.MAILBOX_ID =M.MAILBOX_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 | MAILBOX_ID | Character(30) | VARCHAR2(30) NOT NULL | Mail Box Id is an Id associated with Mail Boxes |
| 3 | MAIL_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Type of the ERMS E-mail ( Structured/Unstructured/Spam )
P=Spam S=Structured E-Mail U=Unstructured E-mail |
| 4 | FROM_ADDRESS | Character(200) | VARCHAR2(200) NOT NULL | Dialog Designer: Reply To Email Address |
| 5 | BO_ID_CONTACT | Number(31,0) | DECIMAL(31) NOT NULL | This field indicates the Business Object ID for the contact. |
| 6 | BO_ID_CUST | Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |
| 7 | ROLE_TYPE_ID_CUST | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the customer |
| 8 | ROLE_TYPE_ID_CNTCT | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the contact |
| 9 | CLASSIFY_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Determines the status of the Classification of an E-mail
0=Queued For Content Analysis 1=Collection Built 2=Content Analysis Processing 3=Complete |
| 10 | MCF_EMAIL_TEXT | Long Character | CLOB | Text |