Share this page

# 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

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: