Share this page

# 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

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: