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

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