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