KWFL_EXECUTIONS
An execution is a step-source; that is, a workflow step can be defined on a particular execution. There are several types of executions: (1) PL/SQL code execution (2) SQL execution (3) Token based resolution (4) Special command execution (5) Workflow step command execution. While the user can specify any PL/SQL code or token, there is only a limited set of workflow commands. The execution "Close successfully", for example, is of type (4) and the command is "wf_close_success". The user can also define commands at the execution step by selecting workflow step commands as the execution type.
Foreign Keys
Primary Key Table |
Primary Key Column |
Foreign Key Column |
---|---|---|
KWFL_WORKFLOW_COMMANDS |
WORKFLOW_COMMAND_ID |
WORKFLOW_COMMAND_ID |
KNTA_USERS |
USER_ID |
LAST_UPDATED_BY |
KNTA_USERS |
USER_ID |
CREATED_BY |
KNTA_VALIDATIONS_NLS |
VALIDATION_ID |
RESULT_VALIDATION_ID |
KNTA_PARAMETER_SET_CONTEXTS |
PARAMETER_SET_CONTEXT_ID |
USER_DATA_SET_CONTEXT_ID |
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
EXECUTION_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 |
ENTITY_LAST_UPDATE_DATE |
NOT NULL |
DATE |
Date a record in the entity was last updated |
EXECUTION_NAME |
NOT NULL |
VARCHAR2(100) |
A unique name of an execution |
DESCRIPTION |
NULLABLE |
VARCHAR2(240) |
Description of the execution |
EXECUTION_TYPE_CODE |
NOT NULL |
VARCHAR2(30) |
Defined by the lookup type "EXECUTION_TYPE". It can be "PLSQL", "SQL", "TOKEN", "COMMAND" or "COMMAND_EXECUTION". When it is "COMMAND", the field WORKFLOW_COMMAND_ID specifies what command to execute. |
WORKFLOW_COMMAND_ID |
NULLABLE |
NUMBER |
Defined the command to be executed. Only relevant when the EXECUTION_TYPE_CODE is "COMMAND". |
EXECUTION |
NULLABLE |
VARCHAR2(2000) |
Relevant only when EXECUTION_TYPE_CODE is "PLSQL", "SQL", or "TOKEN". For "PLSQL", it contains a PL/SQL function name and parameters. For "SQL" it contains the SQL statement. For "TOKEN", it contains the token name including brackets. |
RESULT_VALIDATION_ID |
NOT NULL |
NUMBER |
Defines the validation used for valid result values |
TIMEOUT_VALUE |
NULLABLE |
NUMBER |
Number of time units, given in TIMEOUT_UNIT_CODE, for the execution decision to timeout. This is not the timeout for the actual execution run time. |
TIMEOUT_UNIT_CODE |
NULLABLE |
VARCHAR2(30) |
Unit of time for the Timeout of the execution decision. Can be "Minutes", "Hours", "Days", "Weeks", or "Weekdays". Defaults to "Days". |
PRODUCT_SCOPE_CODE |
NOT NULL |
VARCHAR2(30) |
Defined by the lookup type "PRODUCT_SCOPE_TYPE". It can be "ALL", "AI", or "RI". |
PROCESSING_TYPE_CODE |
NOT NULL |
VARCHAR2(30) |
Defined by the lookup type "PROCESSING_TYPE". It can be IMMEDIATE or MANUAL. |
ICON_NAME |
NULLABLE |
VARCHAR2(80) |
Name of the image file that resides in the icons directory of the server, which is used to display the execution in graphical views. |
ENABLED_FLAG |
NOT NULL |
VARCHAR2(1) |
Either 'Y' or 'N'. If set to 'N', no new workflow steps can be created based on that execution. |
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. |
USER_DATA_SET_CONTEXT_ID |
NULLABLE |
NUMBER |
Parameter set context identifier for the user data fields |
USER_DATA1-20 |
NULLABLE |
VARCHAR2(200) |
User data segment |
VISIBLE_USER_DATA1-20 |
NULLABLE |
VARCHAR2(200) |
User data segment |
SYNCHRONOUS_FLAG |
NOT NULL |
VARCHAR2(1) |
Y or N, should this execution wait to finish before returning to the end user or should it run asynchronously |
DEFINITION_LANGUAGE |
NULLABLE |
VARCHAR2(40) |
Language in which this execution was created |
REFERENCE_CODE |
NOT NULL |
VARCHAR2(200) |
Reference code. Equals to that of LOC table. |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
KWFL_EXECUTIONS_U1 |
UNIQUE |
1 |
EXECUTION_ID |
KWFL_EXECUTIONS_U2 |
UNIQUE |
1 |
EXECUTION_NAME |
SYS_C00109353956 |
UNIQUE |
1 |
REFERENCE_CODE |
Sequences
Sequence Name |
Sequence Type |
---|---|
KWFL_EXECUTIONS_S |
EXECUTION_ID |