KWFL_WORKFLOWS

This table stores the header information for a workflow definition, such as workflow name, description, and associated product scope.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KWFL_WORKFLOWS_NLS

WORKFLOW_ID

DEFAULT_CHILD_PKG_WF_ID

KNTA_USERS

USER_ID

CREATED_BY

KCRT_REQUEST_TYPES_NLS

REQUEST_TYPE_ID

DEFAULT_CHILD_REQ_RT_ID

KWFL_WORKFLOW_STEPS_NLS

WORKFLOW_STEP_ID

FIRST_WORKFLOW_STEP_ID

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KWFL_WORKFLOW_STEPS_NLS

WORKFLOW_STEP_ID

REOPEN_STEP_ID

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

WORKFLOW_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

WORKFLOW_NAME

NOT NULL

VARCHAR2(150)

Name of the workflow

DESCRIPTION

NULLABLE

VARCHAR2(240)

Description of the workflow

PRODUCT_SCOPE_CODE

NOT NULL

VARCHAR2(30)

Either 'AI' for Deployment Management, 'RI' for Demand Management or 'ALL' for all

FIRST_WORKFLOW_STEP_ID

NULLABLE

NUMBER

ID of the workflow step that will be enabled when the workflow is instantiated

REOPEN_STEP_ID

NULLABLE

NUMBER

ID of the workflow step that will be enabled when the workflow is reopened

RESTRICT_OBJECTS_FLAG

NULLABLE

VARCHAR2(1)

When set to 'Y', all new object types are restricted from this workflow

FORCE_APP_CODE_FLAG

NOT NULL

VARCHAR2(1)

If 'Y', Forces the user to select an app code for the object when adding a request line.

RESTRICT_WORKFLOWS_FLAG

NULLABLE

VARCHAR2(1)

When set to 'Y', all new workflows are restricted from this workflow

ENABLED_FLAG

NOT NULL

VARCHAR2(1)

Only enabled workflows can be used for new issues or change requests

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 1211

USER_DATA1-20

NULLABLE

VARCHAR2(200)

User data segment

VISIBLE_USER_DATA1-20

NULLABLE

VARCHAR2(200)

User data segment

SUB_WORKFLOW_FLAG

NOT NULL

VARCHAR2(1)

This flag indicates if the workflow is a subworkflow.

RESULT_VALIDATION_ID

NULLABLE

NUMBER

In case of subworkflows, this validation will define the transitions coming out of the subworkflow step.

ICON_NAME

NULLABLE

VARCHAR2(80)

In case of subworkflows, the subworkflow step will be displayed with this icon.

USE_IN_RELEASE_DIST_FLAG

NOT NULL

VARCHAR2(1)

This column is applicable only for Package Workflows. A package sub-workflow can be included in a Distribution workflow only when this column is set to 'Y' (Yes).

DEFAULT_CHILD_PKG_WF_ID

NULLABLE

NUMBER

Identifier for the default package workflow for packages that are spawned by this workflow

DEFAULT_CHILD_REQ_RT_ID

NULLABLE

NUMBER

Identifier for the default request type for requests that are spawned by this workflow

RESTRICT_CHILD_REQ_RTS_FLAG

NULLABLE

VARCHAR2(1)

When set to 'Y', all new request types are restricted from this workflow

DEFINITION_LANGUAGE

NOT NULL

VARCHAR2(40)

Definition language

REFERENCE_CODE

NOT NULL

VARCHAR2(200)

Reference code

USE_IN_MOBILE_FLAG NOT NULLL VARCHAR2(1) Whether or not the workflow steps of the workflow are available to be acted on in PPM for Mobile

Indexes

Index Name

Index Type

Sequence

Column Name

KWFL_WORKFLOWS_NLS_U3

NONUNIQUE

1

WORKFLOW_ID

KWFL_WORKFLOWS_NLS_U3

NONUNIQUE

2

SUB_WORKFLOW_FLAG

KWFL_WORKFLOWS_U1

UNIQUE

1

WORKFLOW_ID

KWFL_WORKFLOWS_U2

UNIQUE

1

WORKFLOW_NAME

SYS_C005199903

UNIQUE

1

REFERENCE_CODE

Sequences

Sequence Name

Sequence Type

KWFL_WORKFLOWS_S

WORKFLOW_ID