RB_TEST_EMAIL(SQL Table) |
Index Back |
|---|
| # | 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
Prompt Table: RB_MAILBOX_DEFN |
| 3 | EMAIL_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
ERMS Inbound Email Status
Prompt Table: RI_STATUS_TBL |
| 4 | 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 |
| 5 | FROM_ADDRESS | Character(200) | VARCHAR2(200) NOT NULL | Dialog Designer: Reply To Email Address |
| 6 | BO_ID_CONTACT | Number(31,0) | DECIMAL(31) NOT NULL | This field indicates the Business Object ID for the contact. |
| 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 | ROLE_TYPE_ID_CNTCT | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the contact |
| 10 | CURRENT_WL | Character(30) | VARCHAR2(30) NOT NULL |
Current Worklist Value
Prompt Table: RB_WF_WL_GRP |
| 11 | LAST_GROUP_WL | Character(30) | VARCHAR2(30) NOT NULL |
Last/Current Group-level Worklist
Prompt Table: RB_WF_WL_GRP |
| 12 | MCF_EMAIL_TEXT | Long Character | CLOB | Text |