Share this page

# KNTA_PREPARED_COMMAND_STEPS

This table stores the actual execution steps after the steps are parsed and special commands have been expanded. The commands may contain runtime tokens that will be parsed only at runtime.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KNTA_USERS | USER_ID | CREATED_BY
KNTA_PREPARED_COMMANDS | PREPARED_COMMAND_ID | PREPARED_COMMAND_ID
KNTA_USERS | USER_ID | LAST_UPDATED_BY

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
PREPARED_COMMAND_STEP_ID | NOT NULL | NUMBER | System-generated identifier
PREPARED_COMMAND_ID | NOT NULL | NUMBER | Identifier for the prepared command to which this step belongs
SEQ | NOT NULL | NUMBER | Sequence in which the command steps will be executed
COMMAND | NULLABLE | VARCHAR2(4000) | Actual command that will be executed
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
PREPARED_SPECIAL_COMMAND_ID | NULLABLE | NUMBER | Identifier for the prepared special command to which this step belongs

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KNTA_PREPARED_COMMAND_STEPS_N1 | NONUNIQUE | 1 | PREPARED_COMMAND_ID
KNTA_PREPARED_COMMAND_STEPS_U1 | UNIQUE | 1 | PREPARED_COMMAND_STEP_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
KNTA_PREPARED_COMMAND_STEPS_S | PREPARED_COMMAND_STEP_ID

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: