KWFL_WORKFLOW_COMMANDS

This table stores the various commands eligible for each workflow step. These commands eventually result in the execution of various product-specific pieces of code. For example, the workflow command execute_object_commands is used to fire Object Type commands as Packages migrate through a workflow.

Foreign Keys

Primary Key Table	Primary Key Column	Foreign Key Column
KNTA_USERS	USER_ID	LAST_UPDATED_BY
KNTA_USERS	USER_ID	CREATED_BY

Column Descriptions

Column Name	Null?	Data Type	Description
WORKFLOW_COMMAND_ID	NOT NULL	NUMBER	System-generated identifier
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
WORKFLOW_COMMAND_CODE	NOT NULL	VARCHAR2(30)	Command code to be fired by the workflow engine.
ENABLED_FLAG	NOT NULL	VARCHAR2(1)	Indicates whether the particular command may be used on a workflow.

Indexes

Index Name	Index Type	Sequence	Column Name
KWFL_WORKFLOW_COMMANDS_N1	NONUNIQUE	1	WORKFLOW_COMMAND_CODE
KWFL_WORKFLOW_COMMANDS_U1	UNIQUE	1	WORKFLOW_COMMAND_ID

Sequences

This table uses no sequences.