Share this page

# KWFL_WORKFLOW_STEPS

Each row contains the definition of a workflow step, which is represented by a workflow step figure in the workflow builder screen. A workflow step is based on a decision, condition, or execution. The source and destination environments may be defined for a step, which are in general used to define where from and to objects are migrated. When the workflow step becomes enabled, it may change the assigned user or group of an Request (for Demand Management) or for a Package (for Deployment Management).

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KENV_ENVIRONMENTS | ENVIRONMENT_ID | DEST_ENVIRONMENT_ID
KENV_ENV_GROUPS | ENV_GROUP_ID | DEST_ENV_GROUP_ID
KWFL_WORKFLOWS_NLS | WORKFLOW_ID | DEFAULT_CHILD_PKG_WF_ID
KWFL_WORKFLOWS_NLS | WORKFLOW_ID | STEP_SOURCE_ID
KENV_ENV_GROUPS | ENV_GROUP_ID | SOURCE_ENV_GROUP_ID
KNTA_REF_RELATIONSHIPS_NLS | REF_RELATIONSHIP_ID | REF_RELATIONSHIP_ID
KCRT_REQUEST_TYPES_NLS | REQUEST_TYPE_ID | DEFAULT_CHILD_REQ_RT_ID
KNTA_USERS | USER_ID | LAST_UPDATED_BY
KWFL_VERIFICATION_TEMP | WORKFLOW_ID | WORKFLOW_ID
KWFL_CONDITIONS | CONDITION_ID | STEP_SOURCE_ID
KWFL_WORKFLOWS_NLS | WORKFLOW_ID | WORKFLOW_ID
KNTA_PARAMETER_SET_CONTEXTS | PARAMETER_SET_CONTEXT_ID | USER_DATA_SET_CONTEXT_ID
KWFL_EXECUTIONS_NLS | EXECUTION_ID | STEP_SOURCE_ID
KNTA_USERS | USER_ID | CREATED_BY
KWFL_WORKFLOW_PARAMETERS_NLS | WORKFLOW_PARAMETER_ID | RESULT_WORKFLOW_PARAMETER_ID
KWFL_APPROVALS_NLS | APPROVAL_ID | STEP_SOURCE_ID
KNTA_USERS | USER_ID | PARENT_ASSIGNED_TO_USER_ID
KENV_ENVIRONMENTS | ENVIRONMENT_ID | SOURCE_ENVIRONMENT_ID
KNTA_SECURITY_GROUPS_NLS | SECURITY_GROUP_ID | PARENT_ASSIGNED_TO_GROUP_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
WORKFLOW_STEP_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_ID | NOT NULL | NUMBER | Workflow ID of the containing workflow
STEP_TYPE_CODE | NOT NULL | VARCHAR2(30) | Defined by lookup STEP_TYPE ('APPROVAL', 'CONDITION', 'EXECUTION', or 'WORKFLOW')
STEP_SOURCE_ID | NULLABLE | NUMBER | ID of the approval, condition, execution, or workflow.
RESULT_WORKFLOW_PARAMETER_ID | NULLABLE | NUMBER | ID of the workflow parameter where the result is stored into
PRODUCT_SCOPE_CODE | NOT NULL | VARCHAR2(30) | Defined by lookup PRODUCT_SCOPE_TYPE
PARENT_ASSIGNED_TO_USER_ID | NULLABLE | NUMBER | When set, sets the assigned-to user for a request or package when this step becomes eligible
PARENT_ASSIGNED_TO_GROUP_ID | NULLABLE | NUMBER | When set, sets the assigned-to group for a request or package when this step becomes eligible
PARENT_STATUS | NULLABLE | VARCHAR2(30) | When set, sets the status of a request or package when this step becomes eligible
SOURCE_ENVIRONMENT_ID | NULLABLE | NUMBER | Defines the source environment, only used for executions
SOURCE_ENV_GROUP_ID | NULLABLE | NUMBER | Defines the source environment group, only used for executions
DEST_ENVIRONMENT_ID | NULLABLE | NUMBER | Defines the destination environment, only used for executions
DEST_ENV_GROUP_ID | NULLABLE | NUMBER | Defines the destination environment group, only used for executions
OM_ARCHIVE_FLAG | NULLABLE | VARCHAR2(1) | When 'Y' and the migrated object is an AOL object type, Object*Migrator will archive the object
AVERAGE_LEAD_TIME | NULLABLE | NUMBER | In days. Purely informational
STEP_NAME | NOT NULL | VARCHAR2(80) | By default the same name as the name of the step source, but user can override it to something else.
JUMP_RECEIVE_LABEL_CODE | NULLABLE | VARCHAR2(30) | Defines the label for the jump and receive steps. Jump/Receive can be performed if the steps have same label.
DESCRIPTION | NULLABLE | VARCHAR2(240) | Description of the workflow
INFORMATION_URL | NULLABLE | VARCHAR2(200) | Defines the URL where the 'hint' can be found for a step. When selected, the hint is displayed in the status tabs for relevant entities.
REQUEST_TYPE_LIST | NULLABLE | VARCHAR2(200) | Defines the list of request types that can be used to create a request using the 'Create_Request' execution command. If left blank, all the request types will be available to create a request.
ACTION_BUTTON_LABEL | NULLABLE | VARCHAR2(80) | When set, this text is used on the Action button on the Package, Request status panel. When blank the step name is used for the label.
SORT_ORDER | NOT NULL | NUMBER | Each step can have a unique sort order between 1 and the total number of workflow steps for one workflow. This determines the display sequence on Package, request status tabs.
ENABLED_FLAG | NOT NULL | VARCHAR2(1) | Only enabled workflow steps can have incoming transitions.
DISPLAY_TYPE_CODE | NOT NULL | VARCHAR2(30) | Determines whether the step will be displayed always, never or on active only.
DRAW_CENTER_POS | NULLABLE | VARCHAR2(30) | X and Y coordinates of the workflow step icon when drawn by the workflow builder
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 | Constant 1212
USER_DATA1-20 | NULLABLE | VARCHAR2(200) | User data segment
VISIBLE_USER_DATA1-20 | NULLABLE | VARCHAR2(200) | User data segment
PERCENT_COMPLETE | NULLABLE | NUMBER | When set, sets the percent complete of a request to this value when this step becomes eligible
RELEASE_IS_REQUIRED_FLAG | NOT NULL | VARCHAR2(1) | When set to 'Y' a valid release should be entered while taking action on this step.
STEP_TIMEOUT_TYPE | NULLABLE | VARCHAR2(50) | Timeout type. Could be a constant or token.
STEP_TIMEOUT_VALUE | NULLABLE | VARCHAR2(200) | Numeric value for timeout
STEP_TIMEOUT_UNIT_CODE | NULLABLE | VARCHAR2(30) | Time out units. Could be minutes, hours, days, and so on
USE_SOURCE_TIMEOUT_FLAG | NOT NULL | VARCHAR2(1) | When this column is set to 'Y' the timeout properties of the step source is used.
ALLOWED_CHILD_PKG_WF_LIST | NULLABLE | VARCHAR2(200) | A KNTA_MULTI.Multi_Delimiter separated list of package workflow identifiers that are allowed to be chosen for packages spawned by this workflow step
DEFAULT_CHILD_PKG_WF_ID | NULLABLE | NUMBER | Identifier for default package workflow to be chosen for packages spawned by this workflow step
DEFAULT_CHILD_REQ_RT_ID | NULLABLE | NUMBER | Identifier for default request type to be chosen for requests spawned by this workflow step
REF_RELATIONSHIP_ID | NULLABLE | NUMBER | Identifier for the referenced relationship for the newly spawned entity
STEP_AUTH_TYPE_CODE | NOT NULL | VARCHAR2(30) | Indicate the type of authorization is required for this creation step
NORMAL_BACKGROUND_COLOR | NULLABLE | VARCHAR2(20) | For the token evaluation engine. Contains the primary key of a table (see KNTA_TOKEN). The reference to this table is used to resolve all the tokens from this context after update
ASSIGNED_TO_USER_TOKEN | NULLABLE | VARCHAR2(500) | For the token evaluation engine. Contains the primary key of a table (see KNTA_TOKEN). The reference to this table is used to resolve all the tokens from this context after update
ASSIGNED_TO_GROUP_TOKEN | NULLABLE | VARCHAR2(500) | For the token evaluation engine. Contains the primary key of a table (see KNTA_TOKEN). The reference to this table is used to resolve all the tokens from this context after update
DEFINITION_LANGUAGE | NOT NULL | VARCHAR2(40) | Definition language
REFERENCE_CODE | NOT NULL | VARCHAR2(200) | Reference code
USE_IN_MOBILE_FLAG | NOT NULL | VARCHAR2(1) | Whether or not the workflow step is available to be acted on in PPM for Mobile

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KWFL_WORKFLOW_STEPS_N1 | NONUNIQUE | 1 | WORKFLOW_ID
KWFL_WORKFLOW_STEPS_N1 | NONUNIQUE | 2 | SORT_ORDER
KWFL_WORKFLOW_STEPS_N2 | NONUNIQUE | 1 | STEP_SOURCE_ID
KWFL_WORKFLOW_STEPS_N2 | NONUNIQUE | 2 | STEP_TYPE_CODE
KWFL_WORKFLOW_STEPS_NLS_N3 | NONUNIQUE | 1 | WORKFLOW_ID
KWFL_WORKFLOW_STEPS_NLS_N3 | NONUNIQUE | 2 | ENABLED_FLAG
KWFL_WORKFLOW_STEPS_NLS_N3 | NONUNIQUE | 3 | WORKFLOW_STEP_ID
KWFL_WORKFLOW_STEPS_NLS_U2 | NONUNIQUE | 1 | WORKFLOW_STEP_ID
KWFL_WORKFLOW_STEPS_NLS_U2 | NONUNIQUE | 2 | ENABLED_FLAG
KWFL_WORKFLOW_STEPS_U1 | UNIQUE | 1 | WORKFLOW_STEP_ID
SYS_C005199976 | UNIQUE | 1 | REFERENCE_CODE

## Sequences

This table does not use any Sequences.

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: