Share this page
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 that indicates what type of recipient it is for the From field of the Email. The options include username, email address. |
|
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 that indicates what type of recipient it is for the Reply To field of the Email. The options include username and email address. |
|
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, such as HTML and TXT. |
|
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 |
