Share this page

# KNTA_NOTIF_TXN_PARENTS

This table stores a list of all the packages, Issues, or Report Submissions that have notifications to be sent. This table is examined every 20 seconds. If the sent_flag is set to false and it is time to send the notification (according to the interval referenced by the interval_id) a notification will be sent.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KNTA_USERS | USER_ID | CREATED_BY
KNTA_NOTIF_INTERVALS_NLS | INTERVAL_ID | INTERVAL_ID
KNTA_USERS | USER_ID | LAST_UPDATED_BY
KNTA_NOTIFICATIONS_NLS | NOTIFICATION_ID | NOTIFICATION_ID
KCRT_REQUESTS | REQUEST_ID | PARENT_KEY_ID
KNTA_REPORT_SUBMISSIONS | REPORT_SUBMISSION_ID | PARENT_KEY_ID
KDLV_PACKAGES | PACKAGE_ID | PARENT_KEY_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
NOTIF_TXN_PARENT_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_ID | NOT NULL | NUMBER | Foreign Key to the notification table.
PARENT_KEY_ID | NOT NULL | NUMBER | Foreign Key to the KDLV_PACKAGES, KCRT_REQUESTS, or KTNA_REPORT_SUBMISSIONS table.
FROM_EMAIL_ADDRESS | NULLABLE | VARCHAR2(80) | Value of the From header field of an Email
SUBJECT | NULLABLE | VARCHAR2(240) | Subject of the e-mail from KNTA_NOTIFICATIONS
REPLY_TO_EMAIL_ADDRESS | NULLABLE | VARCHAR2(80) | Value of the Reply To header field of an email
CONTENT_TYPE_CODE | NULLABLE | VARCHAR2(30) | Code indicating the format of the Email
PARENT_TEXT | NOT NULL | CLOB | Text of the e-mail with tokens resolved
INTERVAL_ID | NOT NULL | NUMBER | Foreign Key to the interval defined for the notification
NOTIFICATION_SENT_FLAG | NOT NULL | VARCHAR2(1) | Flag set to true if the notification has been sent
REMINDER_FLAG | NOT NULL | VARCHAR2(1) | Flag set to true if a reminder should be sent
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_TXN_PARENTS_N1 | NONUNIQUE | 1 | PARENT_KEY_ID
KNTA_NOTIF_TXN_PARENTS_N2 | NONUNIQUE | 1 | NOTIFICATION_ID
KNTA_NOTIF_TXN_PARENTS_U1 | NONUNIQUE | 1 | NOTIF_TXN_PARENT_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
KNTA_NOTIF_TXN_PARENTS_S | NOTIF_TXN_PARENT_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: