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