KNTA_COMMAND_STEPS

This table stores the actual command-line, token-based commands for each respective entity. These command steps are sent through the token parser and passed to the command line of the various machines PPM Center can connect to. Command steps may also consist of special commands (see the special command tables for reference).

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
COMMAND_STEP_ID	NOT NULL	NUMBER	System-generated identifier
CREATION_DATE	NOT NULL	DATE	Date record was created
CREATED_BY	NOT NULL	NUMBER	Identifier for the user who created the record
LAST_UPDATE_DATE	NOT NULL	DATE	Date record was last updated
LAST_UPDATED_BY	NOT NULL	NUMBER	Identifier for the user who last updated the record
COMMAND_ID	NOT NULL	NUMBER	Identifier of the parent command
STEP_SEQ	NOT NULL	NUMBER	Sequence of the command step (within a given command)
COMMAND	NULLABLE	VARCHAR2(2000)	Command itself (for example, ksc_copy_server_server)
DESCRIPTION	NULLABLE	VARCHAR2(240)	A description of the command
ENABLED_FLAG	NOT NULL	VARCHAR2(1)	Whether or not the command step has been enabled. (Currently not updateable using the command builder.)
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_COMMAND_STEPS_N1	NONUNIQUE	1	COMMAND_ID
KNTA_COMMAND_STEPS_N1	NONUNIQUE	2	STEP_SEQ
KNTA_COMMAND_STEPS_U1	UNIQUE	1	COMMAND_STEP_ID

Sequences

Sequence Name	Sequence Type
KNTA_COMMAND_STEPS_S	COMMAND_STEP_ID