KWFL_WORKFLOW_INSTANCE_STEPS

This table stores one row per workflow step defined in the original workflow for this instance. Each row provides a reference to the KWFL_STEP_TRANSACTIONS table, which contains the current status (Eligible, Approved, and so on) of each step in the instance.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KWFL_STEP_TRANSACTIONS

STEP_TRANSACTION_ID

CURRENT_STEP_TRANSACTION_ID

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KWFL_WORKFLOWS_NLS

WORKFLOW_ID

WORKFLOW_ID

KWFL_WORKFLOW_INSTANCES

WORKFLOW_INSTANCE_ID

WORKFLOW_INSTANCE_ID

KWFL_WORKFLOW_STEPS_NLS

WORKFLOW_STEP_ID

WORKFLOW_STEP_ID

Column Descriptions

Column Name

Null?

Data Type

Description

WORKFLOW_INSTANCE_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_INSTANCE_ID

NOT NULL

NUMBER

References the originating workflow instance for this instance step

WORKFLOW_ID

NOT NULL

NUMBER

References the original workflow for this instance

WORKFLOW_STEP_ID

NOT NULL

NUMBER

References the original workflow step for this instance

CURRENT_STEP_TRANSACTION_ID

NULLABLE

NUMBER

This identifier points to the KWFL_STEP_TRANSACTIONS table, and indicates the most recent transaction that has occurred for a given instance step.

ACTIVE_FLAG

NOT NULL

VARCHAR2(1)

Indicates whether the step is active or not. A step is active if it is pending some sort of action (for example, if the step is eligible, or has not completed its outbound transition)

WORKFLOW_STEP_ID_PATH

NULLABLE

VARCHAR2(200)

A KNTA_MULTI.Multi_Delimiter separated list of Workflow identifiers in the order of workflow hierarchy. This value is unique and used for identifying workflow steps.

Indexes

Index Name

Index Type

Sequence

Column Name

KWFL_WORKFLOW_INSTANCE_STEP_N1

NONUNIQUE

1

WORKFLOW_INSTANCE_ID

KWFL_WORKFLOW_INSTANCE_STEP_N2

NONUNIQUE

1

WORKFLOW_STEP_ID

KWFL_WORKFLOW_INSTANCE_STEP_N3

NONUNIQUE

1

WORKFLOW_STEP_ID_PATH

KWFL_WORKFLOW_INSTANCE_STEP_U1

UNIQUE

1

WORKFLOW_INSTANCE_STEP_ID

KWFL_WORKFLOW_INSTANCE_STEP_N4

NONUNIQUE

1

WORKFLOW_STEP_ID

KWFL_WORKFLOW_INSTANCE_STEP_N4

NONUNIQUE

2

WORKFLOW_INSTANCE_ID

KWFL_WORKFLOW_INSTANCE_STEP_N8

NONUNIQUE

1

ACTIVE_FLAG

Sequences

Sequence Name

Sequence Type

KWFL_WORKFLOW_INSTANCE_STEPS_S

WORKFLOW_INSTANCE_STEP_ID