Share this page

# 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

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: