KNTA_ENTITY_TOKENS

This table stores the individual tokens that can be evaluated for each entity to provide dynamic context-sensitive values at the point of use. Tokens can be used in command execution, validation SQL statements, notifications, and workflow executions.

Foreign Keys

Primary Key Table	Primary Key Column	Foreign Key Column
KNTA_USERS	USER_ID	CREATED_BY
KNTA_ENTITIES_NLS	ENTITY_ID	ENTITY_ID
KNTA_USERS	USER_ID	LAST_UPDATED_BY

Column Descriptions

Column Name	Null?	Data Type	Description
ENTITY_TOKEN_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
TOKEN	NOT NULL	VARCHAR2(40)
TOKEN_NAME	NOT NULL	VARCHAR2(100)
TOKEN_SHORT_NAME	NULLABLE	VARCHAR2(50)
DESCRIPTION	NULLABLE	VARCHAR2(240)
ENTITY_ID	NOT NULL	NUMBER
DEFAULT_COLUMN_SIZE	NULLABLE	NUMBER
ENCRYPTED_FLAG	NOT NULL	VARCHAR2(1)
COLUMN_NAME	NULLABLE	VARCHAR2(80)
TOKEN_SQL	NULLABLE	VARCHAR2(2000)
RECIPIENT_TYPE_CODE	NULLABLE	VARCHAR2(30)
ENABLED_FLAG	NOT NULL	VARCHAR2(1)
DEFINITION_LANGUAGE	NOT NULL	VARCHAR2(40)
REFERENCE_CODE	NOT NULL	VARCHAR2(200)

Indexes

Index Name	Index Type	Sequence	Column Name
KNTA_ENTITY_TOKENS_U1	UNIQUE	1	ENTITY_TOKEN_ID
KNTA_ENTITY_TOKENS_U2	UNIQUE	1	ENTITY_ID
KNTA_ENTITY_TOKENS_U2	UNIQUE	2	TOKEN
SYS_C005198065	UNIQUE	1	REFERENCE_CODE

Sequences

This table uses no sequences.