Share this page

# KNTA_COMMANDS

This is a common table to all of the products in PPM Center. It stores all of the commands used by the various entities within the suite. Commands are referenced from entities such as object types, report types, request types, and workflow steps. The command itself does not contain the actual executions that are run, but rather serves to group command steps together and provide a facility (via the condition) to avoid having those steps run.

## 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_REPORT_TYPES_NLS | REPORT_TYPE_ID | PARENT_ID
KDLV_OBJECT_TYPES | OBJECT_TYPE_ID | PARENT_ID
KWFL_WORKFLOW_STEPS_NLS | WORKFLOW_STEP_ID | PARENT_ID
KNTA_VALIDATIONS_NLS | VALIDATION_ID | PARENT_ID
KCRT_REQUEST_TYPES_NLS | REQUEST_TYPE_ID | PARENT_ID
KNTA_SPECIAL_COMMAND_TYPES | SPECIAL_COMMAND_TYPE_ID | PARENT_ENTITY_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
COMMAND_ID | NOT NULL | NUMBER | System-generated identifier
PARENT_ENTITY_ID | NOT NULL | NUMBER | Identifier of the parent entity for this command. Refer to table KNTA_ENTITIES.
PARENT_ID | NOT NULL | NUMBER | Actual identifier of the parent record for this command (for example, OBJECT_TYPE_ID)
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
ENTITY_LAST_UPDATE_DATE | NOT NULL | DATE | Date a record in the entity was last updated
COMMAND_NAME | NOT NULL | VARCHAR2(150) | Name of the command
COMMAND_SEQ | NOT NULL | NUMBER | Sequence of the command (this sequence is sequential within one PARENT_ID, PARENT_ENTITY_ID)
CONDITION | NULLABLE | VARCHAR2(2000) | Condition to evaluate to determine whether to run the command steps
DESCRIPTION | NULLABLE | VARCHAR2(240) | A description of the command
TIMEOUT_SECONDS | NULLABLE | NUMBER | Number of seconds a command will be allowed to run. This column prevents infinite loops or hanging. If a command reaches its timeout, it is forced to a FAILURE state.
EXIT_ON_FAIL_FLAG | NOT NULL | VARCHAR2(1) | Determines whether the command will exit on failure. (NOT YET IMPLEMENTED).
ENABLED_FLAG | NOT NULL | VARCHAR2(1) | Whether or not the command was enabled.
SOURCE_TYPE_CODE | NULLABLE | VARCHAR2(30) | For records that have been updated by an interface or migrator, indicates the type of external update (specific interface or migrator name, and so on)
SOURCE | NULLABLE | VARCHAR2(100) | For records that have been updated by an interface or migrator, provides additional information about the source of the external update
EVENT_CODE | NULLABLE | VARCHAR2(30) | Specifies the event to trigger the command. For example, after save.

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KNTA_COMMANDS_N1 | NONUNIQUE | 1 | PARENT_ENTITY_ID
KNTA_COMMANDS_N1 | NONUNIQUE | 2 | PARENT_ID
KNTA_COMMANDS_N1 | NONUNIQUE | 3 | COMMAND_SEQ
KNTA_COMMANDS_U1 | UNIQUE | 1 | COMMAND_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
KNTA_COMMANDS_S | 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: