KNTA_NOTIF_TYPE_MESSAGES

This table stores templates for email messages.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KNTA_NOTIFICATION_COLUMNS

NOTIFICATION_COLUMN_ID

NOTIFICATION_COLUMN_ID

KNTA_NOTIFICATION_TYPES

NOTIFICATION_TYPE_ID

NOTIFICATION_TYPE_ID

Column Descriptions

Column Name

Null?

Data Type

Description

NOTIF_TYPE_MESSAGE_ID

NOT NULL

NUMBER

System-generated identifier

CREATED_BY

NOT NULL

NUMBER

Identifier for the user who created the record

CREATION_DATE

NOT NULL

DATE

Date record was created

LAST_UPDATED_BY

NOT NULL

NUMBER

Identifier for the user who last updated the record

LAST_UPDATE_DATE

NOT NULL

DATE

Date record was last updated

ENTITY_LAST_UPDATE_DATE

NOT NULL

DATE

Date a record in the entity was last updated

MESSAGE_NAME

NOT NULL

VARCHAR2(80)

name of the message

NOTIFICATION_TYPE_ID

NOT NULL

NUMBER

Foreign Key to KNTA_NOTIFICATION_TYPES table.

FROM_RECIPIENT_TYPE_CODE

NULLABLE

VARCHAR2(30)

Code indicating the type of recipient it is, such as username, email address, and so on, for the Email's From field

FROM_TOKEN_TYPE_CODE

NULLABLE

VARCHAR2(30)

Specifies whether it is a standard token or a user-defined token

FROM_ADDRESS

NULLABLE

VARCHAR2(80)

Value of the From header field in the email.

SUBJECT

NULLABLE

VARCHAR2(240)

Default subject for the email message

REPLY_TO_RECIPIENT_TYPE_CODE

NULLABLE

VARCHAR2(30)

Code indicating the type of recipient it is, such as username, email address, and so on for the Email's Reply To field

REPLY_TO_TOKEN_TYPE_CODE

NULLABLE

VARCHAR2(30)

Specifies whether it is a standard token or a user defined token

REPLY_TO_ADDRESS

NULLABLE

VARCHAR2(80)

Value of the Reply To header field in the email.

CONTENT_TYPE_CODE

NULLABLE

VARCHAR2(30)

Code specifying the format of the email (HTML, TXT, and so on)

PARENT_TEXT

NOT NULL

CLOB

Text of the parent part of the email message, before tokens are replaced

NOTIFICATION_COLUMN_ID

NULLABLE

NUMBER

Foreign Key to KNTA_NOTIFICATION_COLUMNS. These are the default columns for the message.

DEFAULT_FLAG

NOT NULL

VARCHAR2(1)

Determines whether this message is the default message for the notification type

ENABLED_FLAG

NOT NULL

VARCHAR2(1)

Determines whether this message can be used in a notification

NOTIFICATION_FORMAT_CODE

NOT NULL

VARCHAR2(50)

Indicates the format of notification output: HTML or plain text

Indexes

Index Name

Index Type

Sequence

Column Name

KNTA_NOTIF_TYPE_MESSAGES_N1

NONUNIQUE

1

NOTIFICATION_TYPE_ID

KNTA_NOTIF_TYPE_MESSAGES_U1

NONUNIQUE

1

NOTIF_TYPE_MESSAGE_ID

Sequences

Sequence Name

Sequence Type

KNTA_NOTIF_TYPE_MESSAGES_S

NOTIF_TYPE_MESSAGE_ID