RB_CLASSIFY_TBL(SQL Table) |
Index Back |
|---|---|
Classification QueueThis Table stores all the E-mails that are read by the Mail Reader process and needs to be processed by the Structure/Unstructured Content Ananlysis process |
| # | 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 | MCF_WL_SUBJECT | Character(254) | VARCHAR2(254) NOT NULL | Subject |
| 4 | 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 |
| 5 | ROUTE_TO_DEFAULT | Character(1) | VARCHAR2(1) NOT NULL |
Route To Default
Y/N Table Edit |
| 6 | 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 |
| 7 | 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 |
| 8 | FROM_ADDRESS | Character(200) | VARCHAR2(200) NOT NULL | Dialog Designer: Reply To Email Address |
| 9 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 10 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 11 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |