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.