KNTA_PREPARED_COMMANDS

This table stores the commands that have been parsed and are ready for execution. Runtime tokens cannot be parsed prior to execution. These conditions are stored in this table and can be evaluated by Command Execution Engine during execution. For each row in the KNTA_COMMANDS table, there is one row in this table for a given command provided the command condition is true or can only be determined at run-time.

Foreign Keys

Primary Key Table	Primary Key Column	Foreign Key Column
KNTA_COMMANDS	COMMAND_ID	COMMAND_ID
KNTA_USERS	USER_ID	CREATED_BY
KNTA_USERS	USER_ID	LAST_UPDATED_BY

Column Descriptions

Column Name	Null?	Data Type	Description
PREPARED_COMMAND_ID	NOT NULL	NUMBER	System-generated identifier
GROUP_ID	NOT NULL	NUMBER	System-generated group identifier
SEQ	NOT NULL	NUMBER	Sequence in which the commands are executed
CONDITION	NULLABLE	VARCHAR2(4000)	Contains the parsed command condition to be evaluated at run-time. This field is blank for conditions that have been evaluated to true at time of parsing.
COMMAND_ID	NOT NULL	NUMBER	Identifier for the command that is being parsed
CREATED_BY	NOT NULL	NUMBER	Identifier for the user who created the record
CREATION_DATE	NOT NULL	DATE	Date record was created
LAST_UPDATED_BY	NOT NULL	NUMBER	Identifier for the user who last updated the record
LAST_UPDATE_DATE	NOT NULL	DATE	Date record was last updated

Indexes

Index Name	Index Type	Sequence	Column Name
KNTA_PREPARED_COMMANDS_N1	NONUNIQUE	1	GROUP_ID
KNTA_PREPARED_COMMANDS_U1	UNIQUE	1	PREPARED_COMMAND_ID

Sequences

Sequence Name	Sequence Type
KNTA_EXEC_GROUP_IDS_S	GROUP_ID
KNTA_PREPARED_COMMANDS_S	PREPARED_COMMAND_ID