KWFL_TRANSITION_TRANSACTIONS

A row is inserted into this table each time a step transaction completes and should proceed to the next step(s) of the workflow.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KNTA_USERS

USER_ID

CREATED_BY

KWFL_STEP_TRANSACTIONS

STEP_TRANSACTION_ID

FROM_STEP_TRANSACTION_ID

KWFL_STEP_TRANSACTIONS

STEP_TRANSACTION_ID

RESET_STEP_TRANSACTION_ID

KWFL_STEP_TRANSACTIONS

STEP_TRANSACTION_ID

TO_STEP_TRANSACTION_ID

KWFL_WORKFLOW_INSTANCE_STEPS

WORKFLOW_INSTANCE_STEP_ID

TO_WORKFLOW_INSTANCE_STEP_ID

KWFL_WORKFLOW_STEPS_NLS

WORKFLOW_STEP_ID

TO_WORKFLOW_STEP_ID

KWFL_WORKFLOW_INSTANCES

WORKFLOW_INSTANCE_ID

WORKFLOW_INSTANCE_ID

Column Descriptions

Column Name

Null?

Data Type

Description

TRANSITION_TRANSACTION_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

NULLABLE

NUMBER

This denormalized column identifies the workflow instance to which this transition transaction belongs.

COMPLETION_GROUP_ID

NULLABLE

NUMBER

This identifies the set of transitions that were generated from step transactions with the same GROUP_ID.

FROM_STEP_TRANSACTION_ID

NULLABLE

NUMBER

This identifies the step transaction which resulted in this transition transaction.

TO_WORKFLOW_STEP_ID

NULLABLE

NUMBER

This denormalized column identifies the step in the workflow to which the transition is moving.

TO_WORKFLOW_INSTANCE_STEP_ID

NULLABLE

NUMBER

This denormalized column identifies the step in the instance of the workflow to which the transition is moving.

TO_STEP_TRANSACTION_ID

NULLABLE

NUMBER

This identifies the step transaction which was created by this transition transaction.

RESET_STEP_TRANSACTION_ID

NULLABLE

NUMBER

This identifies the step transaction which begins the workflow path on which the reset logic should traverse. This step transactions and others leading from it should be reset.

Indexes

Index Name

Index Type

Sequence

Column Name

KWFL_TRANSITION_TRANSACTION_N1

NONUNIQUE

1

COMPLETION_GROUP_ID

KWFL_TRANSITION_TRANSACTION_N1

NONUNIQUE

2

TO_WORKFLOW_STEP_ID

KWFL_TRANSITION_TRANSACTION_N2

NONUNIQUE

1

FROM_STEP_TRANSACTION_ID

KWFL_TRANSITION_TRANSACTION_N3

NONUNIQUE

1

TO_STEP_TRANSACTION_ID

KWFL_TRANSITION_TRANSACTION_U1

UNIQUE

1

TRANSITION_TRANSACTION_ID

Sequences

Sequence Name

Sequence Type

KWFL_COMPLETION_GROUP_ID_S

COMPLETION_GROUP_ID

KWFL_TRANSITION_TRANSACTIONS_S

TRANSITION_TRANSACTION_ID