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 |