RB_INEM_AUDIT(SQL Table) |
Index Back |
|---|---|
Inbound Email Audit RecordCRM ERMS table Used for ERMS Inbound Email |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  AUDIT_OPRID |
Character(30) | VARCHAR2(30) NOT NULL | The OPRID of the user who made the changes audited on an audit record. |
| 2 | AUDIT_STAMP |
DateTime(26) | TIMESTAMP | Date and Time Stamp |
| 3 | AUDIT_ACTN |
Character(1) | VARCHAR2(1) NOT NULL |
Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values |
| 4 | AUDIT_RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Name of the record definition audited. AUDIT_RECNAME is used in User-Defined Audit Record Definitions. |
| 5 | MCF_EMAIL_ID |
Number(16,0) | DECIMAL(16) NOT NULL | Email Id |
| 6 | MAILBOX_ID | Character(30) | VARCHAR2(30) NOT NULL | Mail Box Id is an Id associated with Mail Boxes |
| 7 | REPLY_TO_ADDRESS | Character(254) | VARCHAR2(254) NOT NULL | Email Address associated with the Reply To Person |
| 8 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 9 | MCF_WL_SUBJECT | Character(254) | VARCHAR2(254) NOT NULL | Subject |
| 10 | 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 |
| 11 | EMAIL_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
ERMS Inbound Email Status
Prompt Table: RB_IBEM_STAT_VW |
| 12 | 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 |
| 13 | TMPLT_CATEGRY_ID | Number(6,0) | INTEGER NOT NULL | Template Category ID |
| 14 | TMPLT_TYPE_ID | Number(6,0) | INTEGER NOT NULL | Template Type ID |
| 15 | PRODUCT_GROUP | Character(10) | VARCHAR2(10) NOT NULL | PRoduct Group |
| 16 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 17 | PRIORITY_NBR | Number(3,0) | SMALLINT NOT NULL | Priority |
| 18 | MOOD_ID | Number(6,0) | INTEGER NOT NULL | Mood |
| 19 | BO_ID_CONTACT | Number(31,0) | DECIMAL(31) NOT NULL | This field indicates the Business Object ID for the contact. |
| 20 | BO_ID_CUST | Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |
| 21 | BO_ID_SITE | Number(31,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 22 | ROLE_TYPE_ID_CUST | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the customer |
| 23 | ROLE_TYPE_ID_CNTCT | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the contact |
| 24 | MULTI_BO_ID_SW | Character(1) | VARCHAR2(1) NOT NULL | Multiple BO ID.................................... |
| 25 | LAST_GROUP_WL | Character(30) | VARCHAR2(30) NOT NULL | Last/Current Group-level Worklist |
| 26 | CURRENT_WL | Character(30) | VARCHAR2(30) NOT NULL | Current Worklist Value |
| 27 | ASSIGNED_TO | Character(15) | VARCHAR2(15) NOT NULL | This is a field to store assignment information. |
| 28 | ASSIGNED_DTTM | DateTime(26) | TIMESTAMP | Assigned To Date/Time |
| 29 | WL_MAINT_DTTM | DateTime(26) | TIMESTAMP | Last modified date/time for the worklist value |
| 30 | MB_DUE_DTTM | DateTime(26) | TIMESTAMP | Mailbox level (or external) due date/time |
| 31 | MB_WARN_DTTM | DateTime(26) | TIMESTAMP | Mailbox-level (or external) early warning date/time |
| 32 | WL_DUE_DTTM | DateTime(26) | TIMESTAMP | Worklist-level (or internal) due date/time |
| 33 | WL_WARN_DTTM | DateTime(26) | TIMESTAMP | Worklist-level (or internal) early warning date/time |
| 34 | CONTEXT_TAG | Character(254) | VARCHAR2(254) NOT NULL | Context Tag |
| 35 | CLOSED_BY_OPRID | Character(30) | VARCHAR2(30) NOT NULL | This field is indicate closed by oprid. |
| 36 | CLOSED_DTTM | DateTime(26) | TIMESTAMP | Date Time stamp for when the case status category was changed to closed. |