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