Share this page

# KNTA_SPECIAL_COMMAND_TYPES

This table stores an entry for each special command. Special commands are commands that are frequently used and would benefit from simplification in the object commands. They act like macros or function calls. Special commands starting with ksc_ are PPM Center special commands. For example, ksc_copy_server_server and ksc_connect_dest_server. Special commands starting with sc_ are customer defined. For example, sc_custom_name.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KNTA_USERS | USER_ID | CREATED_BY
KNTA_ENTITIES_NLS | ENTITY_ID | ENTITY_ID
KNTA_USERS | USER_ID | LAST_UPDATED_BY

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
SPECIAL_COMMAND_TYPE_ID | NOT NULL | NUMBER | System generated primary key
CREATED_BY | NOT NULL | NUMBER | Identifier for the user who created the record
CREATION_DATE | NOT NULL | DATE | Date the 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 the record was last updated
ENTITY_LAST_UPDATE_DATE | NOT NULL | DATE | Date a record in the entity was last updated
SPECIAL_COMMAND_TYPE_NAME | NOT NULL | VARCHAR2(80) | Name of the special command.
DESCRIPTION | NULLABLE | VARCHAR2(240) | Details
ENTITY_ID | NOT NULL | NUMBER | Entity identifier for the special command
ENABLED_FLAG | NULLABLE | VARCHAR2(1) | Indicates whether the special command will be shown in the special command builder
EXPAND_FLAG | NULLABLE | VARCHAR2(1) | 'Y' indicates commands are expanded in the database (with parameters) as well as the java code. New custom commands should be set to 'Y'
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_SPECIAL_COMMAND_TYPES_U1 | UNIQUE | 1 | SPECIAL_COMMAND_TYPE_ID
KNTA_SPECIAL_COMMAND_TYPES_U2 | UNIQUE | 1 | SPECIAL_COMMAND_TYPE_NAME

## Sequences

Sequence Name | Sequence Type
--- | ---
KNTA_SPECIAL_COMMAND_TYPES_S | SPECIAL_COMMAND_TYPE_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: