KNTA_NOTIFICATION_TYPES

This table stores the definition for each type of notification provided in PPM Center. The table stores default values as well as corresponding lookup values used in PPM Center to build the user defined notifications.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_ENTITY_GROUPS_NLS

ENTITY_GROUP_ID

DETAIL_ENTITY_GROUP_ID

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KNTA_ENTITY_GROUPS_NLS

ENTITY_GROUP_ID

PARENT_ENTITY_GROUP_ID

Column Descriptions

Column Name

Null?

Data Type

Description

NOTIFICATION_TYPE_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

NOTIFICATION_TYPE_NAME

NOT NULL

VARCHAR2(80)

Name of notification type

DESCRIPTION

NULLABLE

VARCHAR2(240)

Description of notification type

TABLE_NAME

NOT NULL

VARCHAR2(30)

Table that will trigger the notification to be sent. Will be either KWFL_STEP_TRANSACTIONS or KNTA_REPORT_SUBMISSIONS

CONDITION_COLUMN

NOT NULL

VARCHAR2(30)

Name of the column in the TABLE_NAME that could trigger a notification

CONDITION_SQL

NULLABLE

VARCHAR2(2000)

SQL run whose result is put in condition_value in KNTA_NOTIFICATIONS_TEMP

EVENT_COLUMN

NULLABLE

VARCHAR2(30)

A secondary column in the TABLE_NAME to further define a notification - this is the code for the status of the WF step or report submission.

VISIBLE_EVENT_COLUMN

NULLABLE

VARCHAR2(30)

Name of the column in TABLE_NAME with the visible value of the event

PARENT_GROUP_COLUMN

NULLABLE

VARCHAR2(30)

Name of the column in TABLE_NAME that is the ID of the entity to which the TABLE_NAME belongs

DETAIL_GROUP_COLUMN

NULLABLE

VARCHAR2(30)

Name of the column in TABLE_NAME (KWFL_TRANSACTION_STEPS) that is the ID of the detail entity using the workflow.

ON_INSERT_FLAG

NOT NULL

VARCHAR2(1)

Determines whether an insert in TABLE_NAME will trigger a notification

ON_UPDATE_FLAG

NOT NULL

VARCHAR2(1)

Determines whether an update to TABLE_NAME will trigger a notification

ON_DELETE_FLAG

NOT NULL

VARCHAR2(1)

Determines whether a delete to TABLE_NAME will trigger a notification

ENABLED_FLAG

NOT NULL

VARCHAR2(1)

Determine if this notification type may be used to define notifications

PARENT_ENTITY_GROUP_ID

NULLABLE

NUMBER

Entity group identifier for the header message

DETAIL_ENTITY_GROUP_ID

NULLABLE

NUMBER

Entity group identifier for the detail message

Indexes

Index Name

Index Type

Sequence

Column Name

KNTA_NOTIFICATION_TYPES_U1

UNIQUE

1

NOTIFICATION_TYPE_ID

Sequences

Sequence Name

Sequence Type

KNTA_NOTIFICATION_TYPES_S

NOTIFICATION_TYPE_ID