Share this page

# 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

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: