Share this page

# KNTA_FIELD_CHANGE_NOTES

This table stores auditing information to be displayed in the notes section when an entity's field values have changed.

## 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
--- | --- | --- | ---
FIELD_CHANGE_NOTE_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 | Entity type identifier of the parent of this note
PARENT_ENTITY_PRIMARY_KEY | NOT NULL | NUMBER | Primary key of the parent entity
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 original person who wrote the note
AUTHORED_DATE | NOT NULL | DATE | Usually this value will be the same as the CREATION_DATE, but for data that is copied, the original date of the note's creation
NOTE_CONTEXT_VALUE | NULLABLE | VARCHAR2(30) | Currently only applicable for Request notes, stores the request status ID
NOTE_CONTEXT_VISIBLE_VALUE | NULLABLE | VARCHAR2(80) | Currently only applicable for Request notes, stores the request status name
OLD_COLUMN_VALUE | NULLABLE | VARCHAR2(4000) | Column's previous hidden value
OLD_VISIBLE_COLUMN_VALUE | NULLABLE | VARCHAR2(4000) | Column's previous visible value
NEW_COLUMN_VALUE | NULLABLE | VARCHAR2(4000) | Column's new hidden value
NEW_VISIBLE_COLUMN_VALUE | NULLABLE | VARCHAR2(4000) | Column's new visible value
COLUMN_PROMPT | NOT NULL | VARCHAR2(200) | Prompt of the field that was changed

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KNTA_FIELD_CHANGE_NOTES_N1 | NONUNIQUE | 1 | PARENT_ENTITY_PRIMARY_KEY
KNTA_FIELD_CHANGE_NOTES_N1 | NONUNIQUE | 2 | PARENT_ENTITY_ID
KNTA_FIELD_CHANGE_NOTES_U1 | UNIQUE | 1 | FIELD_CHANGE_NOTE_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
KNTA_FIELD_CHANGE_NOTES_S | FIELD_CHANGE_NOTE_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: