KNTA_PENDING_REFERENCES

This table stores pending references that need to be updated.

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_ENTITIES_NLS

ENTITY_ID

SOURCE_ENTITY_ID

Column Descriptions

Column Name

Null?

Data Type

Description

REF_PENDING_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

SOURCE_ENTITY_ID

NOT NULL

NUMBER

Indicates the source entity type of this reference. This value should correspond to ENTITY_ID in KNTA_ENTITIES

SOURCE_ID

NOT NULL

NUMBER

Provides the ID of the source

STATUS_CODE

NULLABLE

VARCHAR2(200)

Indicates the status for this reference - SCHEDULED, NEW, IN_PROGRESS, CANCELLED, CLOSED_SUCCESS, CLOSED_FAILURE, CLOSED_MIXED

EVENT_CODE

NULLABLE

VARCHAR2(200)

Provides the event code for this reference - PREDECESSORS_COMPLETED, PREDECESORS_REMOVED, PREDECESSORS_ADDED, OVERRIDDEN

UPDATE_SYS_OVERRIDE

NULLABLE

VARCHAR2(1)

Indicates the update system override flag

REL_BEHAVIOR_CODE

NULLABLE

VARCHAR2(200)

Provides the relational behavior code for this reference - INFORMATIONAL, PREDECESSOR, SUCCESSOR, FF_PREDECESSOR, AUTO_UPDATE, UPDATED_BY_STEP

CALLBACK_EVENT

NULLABLE

VARCHAR2(100)

Provides the callback event for this reference - REOPEN, REQUEST_HOOK, UPDATE_TASK_STATE

Indexes

This table uses no indexes.

Sequences

Sequence Name

Sequence Type

KNTA_PENDING_REFERENCES_S

REF_PENDING_ID