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