KWFL_STEP_TRANSACTION_HISTORY

A row is inserted into this table each time the status of an execution or decision step transaction changes to ELIGIBLE, COMPLETED, or ERROR. For condition step transactions, a history row is inserted when the status becomes PENDING or COMPLETED.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KWFL_STEP_TRANSACTIONS

STEP_TRANSACTION_ID

STEP_TRANSACTION_ID

KWFL_WORKFLOW_INSTANCES

WORKFLOW_INSTANCE_ID

WORKFLOW_INSTANCE_ID

KWFL_WORKFLOW_INSTANCE_STEPS

WORKFLOW_INSTANCE_STEP_ID

WORKFLOW_INSTANCE_STEP_ID

Column Descriptions

Column Name

Null?

Data Type

Description

STEP_TRANSACTION_HISTORY_ID

NOT NULL

NUMBER

System-generated identifier

CREATION_DATE

NOT NULL

DATE

Date record was created

CREATED_BY

NOT NULL

NUMBER

Identifier for the user who created the record

LAST_UPDATE_DATE

NOT NULL

DATE

Date record was last updated

LAST_UPDATED_BY

NOT NULL

NUMBER

Identifier for the user who last updated the record

STEP_TRANSACTION_ID

NOT NULL

NUMBER

This identifies the step transaction to which this history row belongs

WORKFLOW_INSTANCE_STEP_ID

NOT NULL

NUMBER

This identifies the instance of the step to which this transaction history row belongs

WORKFLOW_INSTANCE_ID

NOT NULL

NUMBER

This identifies the instance of the workflow to which this transaction history row belongs.

STATUS

NOT NULL

VARCHAR2(30)

This gives the hidden status value of the step transaction at the time this history row was created.

USER_COMMENT

NULLABLE

VARCHAR2(240)

This gives the comments within the step transaction at the time this history row was created.

RESULT_VALUE

NULLABLE

VARCHAR2(200)

This gives the hidden result of the step transaction at the time this history row was created.

VISIBLE_RESULT_VALUE

NULLABLE

VARCHAR2(200)

This gives the displayed result of the step transaction at the time this history row was created.

ERROR_VALUE

NULLABLE

VARCHAR2(200)

This gives the hidden error value of the step transaction at the time this history row was created.

VISIBLE_ERROR_VALUE

NULLABLE

VARCHAR2(200)

This gives the displayed error value of the step transaction at the time this history row was created.

ERROR_MESSAGE

NULLABLE

VARCHAR2(240)

This gives the error message for the step transaction at the time this history row was created.

Indexes

Index Name

Index Type

Sequence

Column Name

KWFL_STEP_TRANSACTION_HISTO_N1

NONUNIQUE

1

WORKFLOW_INSTANCE_ID

KWFL_STEP_TRANSACTION_HISTO_N2

NONUNIQUE

1

WORKFLOW_INSTANCE_STEP_ID

KWFL_STEP_TRANSACTION_HISTO_N3

NONUNIQUE

1

STEP_TRANSACTION_ID

KWFL_STEP_TRANSACTION_HISTO_U1

UNIQUE

1

STEP_TRANSACTION_HISTORY_ID

Sequences

Sequence Name

Sequence Type

KWFL_STEP_TXN_HISTORY_S

STEP_TRANSACTION_HISTORY_ID