PPM_EMAIL_PROCESSED_MSGS
This table is used to store the contents of the email message responses sent by the users for the Mobility Access notifications they receive and also the feedback Emails generated by the system after performing the user selected action.
Foreign Keys
Primary Key Table |
Primary Key Column |
Foreign Key Column |
---|---|---|
KNTA_USERS |
USER_ID |
CREATED_BY |
KNTA_USERS |
USER_ID |
LAST_UPDATED_BY |
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
EMAIL_MESSAGE_ID |
NOT NULL |
NUMBER |
System-generated identifier |
CREATION_DATE |
NOT NULL |
DATE |
Date record was created |
CREATED_BY |
NOT NULL |
NUMBER |
Identifier for the user who created the record |
LAST_UPDATE_DATE |
NOT NULL |
DATE |
Date record was last updated |
LAST_UPDATED_BY |
NOT NULL |
NUMBER |
Identifier for the user who last updated the record |
EMAIL_ACCOUNT |
NOT NULL |
VARCHAR2(100) |
Account name of the account configured for the Mobility Access Service |
TYPE_CODE |
NOT NULL |
VARCHAR2(30) |
column to distinguish if the row is for the response email from the user or feedback email generated by the system. Valid values are: INBOUND_ACTION_RESPONSE or OUTBOUND_FEEDBACK. |
FROM_EMAIL_ADDRESS |
NOT NULL |
VARCHAR2(500) |
From email address as set in the response email received or in the feedback email sent to the user |
REPLY_TO_EMAIL_ADDRESS |
NULLABLE |
VARCHAR2(4000) |
Reply to email address as set in the response email received or in the feedback email sent to the user. |
TO_EMAIL_ADDRESSES |
NULLABLE |
VARCHAR2(4000) |
To email addresses as set in the response email received or in the feedback email sent to the user. |
CC_EMAIL_ADDRESSES |
NULLABLE |
VARCHAR2(4000) |
CC email addresses as set in the response email received. Relevant only for response email received from user. |
BCC_EMAIL_ADDRESSES |
NULLABLE |
VARCHAR2(4000) |
BCC email addresses as set in the response email received. Relevant only for response email received from user. |
SUBJECT |
NULLABLE |
VARCHAR2(4000) |
Subject as set in the response email received or in the feedback email sent to the user. |
REFERENCE_ID |
NULLABLE |
NUMBER |
For future enhancements. Not being currently used. |
CONTENT_TYPE |
NULLABLE |
VARCHAR2(200) |
Content type as set in the response email received or in the feedback email sent to the user. |
SENT_DATE |
NULLABLE |
DATE |
Sent date on the response email received or in the feedback email sent to the user. |
PROCESSED_FLAG |
NULLABLE |
VARCHAR2(1) |
Flag to identify if this row has been processed by the Mobility Access Service. Relevant only for response email received from user. |
HEADERS |
NULLABLE |
CLOB |
Email headers as set in the response email received or in the feedback email sent to the user. |
MESSAGE |
NULLABLE |
CLOB |
Email message as set in the response email received or in the feedback email sent to the user. |
ADDED_TO_SERVICE_QUEUE |
NULLABLE |
VARCHAR2(10) |
Denotes whether the message was added to the queue to be processed. Used mainly for service failover scenarios. |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
PPM_EMAIL_PROCESSED_MSGS_U1 |
UNIQUE |
1 |
EMAIL_MESSAGE_ID |
Sequences
Sequence Name |
Sequence Type |
---|---|
PPM_EMAIL_PROCESSED_MSGS_S |
EMAIL_MESSAGE_ID |