KNTA_ENTITIES

This table stores information about the database tables that make up a business category within PPM Center. The information here supports token evaluation and database-level locking of records.

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	PARENT_ENTITY_ID
KNTA_VALIDATIONS_NLS	VALIDATION_ID	VALIDATION_ID

Column Descriptions

Column Name	Null?	Data Type	Description
ENTITY_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
ENTITY_NAME	NOT NULL	VARCHAR2(80)
ENTITY_SHORT_NAME	NOT NULL	VARCHAR2(80)
DESCRIPTION	NULLABLE	VARCHAR2(240)
TOKEN_PREFIX	NULLABLE	VARCHAR2(30)
ENABLED_FLAG	NOT NULL	VARCHAR2(1)
TABLE_NAME	NULLABLE	VARCHAR2(30)
PRIMARY_KEY	NULLABLE	VARCHAR2(30)
USER_PRIMARY_KEY	NULLABLE	VARCHAR2(30)
PARENT_ENTITY_ID	NULLABLE	NUMBER
PARENT_FOREIGN_KEY	NULLABLE	VARCHAR2(30)
PARSE_PACKAGE_NAME	NULLABLE	VARCHAR2(30)
PARSE_FUNCTION_NAME	NULLABLE	VARCHAR2(30)
VALIDATION_ID	NULLABLE	NUMBER
DEFINITION_LANGUAGE	NOT NULL	VARCHAR2(40)
REFERENCE_CODE	NOT NULL	VARCHAR2(200)

Indexes

Index Name	Index Type	Sequence	Column Name
KNTA_ENTITIES_N1	NONUNIQUE	1	PARENT_ENTITY_ID
KNTA_ENTITIES_U1	UNIQUE	1	ENTITY_ID
KNTA_ENTITIES_U2	UNIQUE	1	TOKEN_PREFIX
SYS_C00108368909	UNIQUE	1	REFERENCE_CODE

Sequences

This table uses no sequences.