Share this page

# PPM_EMAIL_CONTEXT_INFO

This table stores the context information for the email notification sent to the user which has been configured for Mobility Access. The PPM background service for Mobility Access uses this information to process it and complete the user selected action.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KNTA_USERS | USER_ID | CREATED_BY
KNTA_ENTITIES_NLS | ENTITY_ID | ENTITY_ID
KNTA_USERS | USER_ID | LAST_UPDATED_BY
KNTA_PENDING_EXCEPTIONS | SOURCE_ID | SOURCE_ID
KWFL_VERIFICATION_TEMP | WORKFLOW_ID | WORKFLOW_ID
KWFL_WORKFLOWS_NLS | WORKFLOW_ID | WORKFLOW_ID
KCRT_RBU_TEMP_STEP_IDS | WORKFLOW_STEP_ID | WORKFLOW_STEP_ID
KWFL_WORKFLOW_STEPS_NLS | WORKFLOW_STEP_ID | WORKFLOW_STEP_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
CONTEXT_INFO_ID | NOT NULL | NUMBER | System-generated identifier
UUID | NOT NULL | VARCHAR2(100) | Universally unique identifier used to match the email and the email address to which the notification was sent.
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
ENTITY_ID | NOT NULL | NUMBER | Identifier used to distinguish between PPM Requests and PPM Packages. For Package, it will be 1 and for Request it will be 20.
SOURCE_ID | NOT NULL | NUMBER | Request ID of the PPM Request for which the notification was sent of the ENTITY_ID is 20. Else Package Line ID of the PPM Package Line for which the notification was sent if the ENTITY_ID is 1.
SOURCE_SET_ID | NOT NULL | NUMBER | Request ID of the PPM Request for which the notification was sent of the ENTITY_ID is 20. Else Package ID of the PPM Package Line for which the notification was sent if the ENTITY_ID is 1.
WORKFLOW_ID | NOT NULL | NUMBER | Workflow ID of the workflow step for which the Mobility Access notification was configured and sent.
WORKFLOW_STEP_ID | NOT NULL | NUMBER | Workflow step ID of the workflow step for which the Mobility Access notification was configured and sent.
EMAIL_ADDRESS | NOT NULL | VARCHAR2(80) | Email address to which the notification was sent.
DISPLAY_LANGUAGE | NOT NULL | VARCHAR2(10) | Display Language Code used for creating the notification content.
COUNTRY_CODE | NULLABLE | VARCHAR2(10) | Country Code used for creating the notification content.
LANGUAGE_FORMAT_CODE | NOT NULL | VARCHAR2(10) | Language format code used for formatting the notification content
REGION_FORMAT_CODE | NULLABLE | VARCHAR2(10) | Region format code used for formatting the notification content

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
PPM_EMAIL_CONTEXT_INFO_U1 | UNIQUE | 1 | CONTEXT_INFO_ID
PPM_EMAIL_CONTEXT_INFO_U2 | UNIQUE | 1 | UUID

## Sequences

Sequence Name | Sequence Type
--- | ---
PPM_EMAIL_CONTEXT_INFO_S | CONTEXT_INFO_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: