Share this page

# KNTA_NOTE_ENTRIES

This table stores the notes for all entities.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KNTA_USERS | USER_ID | AUTHOR_ID
KNTA_USERS | USER_ID | CREATED_BY
KNTA_USERS | USER_ID | LAST_UPDATED_BY
KNTA_ENTITIES_NLS | ENTITY_ID | PARENT_ENTITY_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
NOTE_ENTRY_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
PARENT_ENTITY_ID | NOT NULL | NUMBER | Identifier for the parent entity type of the note
PARENT_ENTITY_PRIMARY_KEY | NOT NULL | NUMBER | Primary key value of the parent of the note
AUTHOR_ID | NOT NULL | NUMBER | Usually this value will be the same as CREATED_BY, but for data that is copied, the ID of the user who originally wrote the note
AUTHORED_DATE | NOT NULL | DATE | Usually this value will be the same as CREATION_DATE, but for data that is copied, the original date of the note
NOTE_CONTEXT_VALUE | NULLABLE | VARCHAR2(30) | Only applicable for request notes, stores the request status ID
NOTE_CONTEXT_VISIBLE_VALUE | NULLABLE | VARCHAR2(80) | Only applicable for request notes, stores the request status name
NOTE | NULLABLE | CLOB | Text of the note
TRANSACTION_NOTE_FLAG | NULLABLE | VARCHAR2(1) | Determines whether this note is used in a workflow transition
NOTE_HTML | NULLABLE | CLOB | Stores the HTML code of notes when rich text notes are enabled. The non-HTML content is always stored in NOTE (CLOB) column, even when rich text notes are enabled.

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KNTA_NOTE_ENTRIES_N1 | NONUNIQUE | 1 | PARENT_ENTITY_PRIMARY_KEY
KNTA_NOTE_ENTRIES_N1 | NONUNIQUE | 2 | PARENT_ENTITY_ID
KNTA_NOTE_ENTRIES_U1 | UNIQUE | 1 | NOTE_ENTRY_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
KNTA_NOTE_ENTRIES_S | NOTE_ENTRY_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: