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