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 |