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