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