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