KWFL_STEP_TRANSACTIONS

There is one row in the KWFL_STEP_TRANSACTIONS table for each time that a step in a workflow is visited. This row contains the unique data for the step transaction, and denormalized context data for quicker querying.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KDLV_PACKAGES

PACKAGE_ID

CHILD_PACKAGE_ID

KCRT_REQUESTS

REQUEST_ID

CHILD_REQUEST_ID

KNTA_USERS

USER_ID

CREATED_BY

KENV_ENVIRONMENTS

ENVIRONMENT_ID

DEST_ENVIRONMENT_ID

KWFL_PENDING_EXEC_OBJECTS

BATCH_ID

EXECUTION_BATCH_ID

KCRT_REQUESTS

REQUEST_ID

INSTANCE_SOURCE_ID

KDLV_PACKAGE_LINES

PACKAGE_LINE_ID

INSTANCE_SOURCE_ID

KWFL_STEP_TRANSACTIONS

STEP_TRANSACTION_ID

INSTANCE_SOURCE_ID

KREL_DISTRIBUTIONS

DISTRIBUTION_ID

INSTANCE_SOURCE_ID

KNTA_REPORT_SUBMISSIONS

REPORT_SUBMISSION_ID

INSTANCE_SOURCE_ID

KDLV_PACKAGES

PACKAGE_ID

INSTANCE_SOURCE_SET_ID

KCRT_REQUESTS

REQUEST_ID

INSTANCE_SOURCE_SET_ID

KNTA_REPORT_SUBMISSIONS

REPORT_SUBMISSION_ID

INSTANCE_SOURCE_SET_ID

KREL_DISTRIBUTIONS

DISTRIBUTION_ID

INSTANCE_SOURCE_SET_ID

KWFL_STEP_TRANSACTIONS

STEP_TRANSACTION_ID

INSTANCE_SOURCE_SET_ID

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KNTA_PARAMETER_SET_CONTEXTS

PARAMETER_SET_CONTEXT_ID

PARAMETER_SET_CONTEXT_ID

KWFL_PENDING_EXEC_OBJECTS

PENDING_EXEC_OBJECT_ID

PENDING_EXEC_OBJECT_ID

KNTA_SCHEDULED_TASKS

SCHEDULED_TASK_ID

SCHEDULED_TASK_ID

KENV_ENVIRONMENTS

ENVIRONMENT_ID

SOURCE_ENVIRONMENT_ID

KCRT_REQUESTS

REQUEST_ID

TOP_INSTANCE_SOURCE_ID

KNTA_REPORT_SUBMISSIONS

REPORT_SUBMISSION_ID

TOP_INSTANCE_SOURCE_ID

KDLV_PACKAGE_LINES

PACKAGE_LINE_ID

TOP_INSTANCE_SOURCE_ID

KREL_DISTRIBUTIONS

DISTRIBUTION_ID

TOP_INSTANCE_SOURCE_ID

KDLV_PACKAGES

PACKAGE_ID

TOP_INSTANCE_SOURCE_SET_ID

KNTA_REPORT_SUBMISSIONS

REPORT_SUBMISSION_ID

TOP_INSTANCE_SOURCE_SET_ID

KCRT_REQUESTS

REQUEST_ID

TOP_INSTANCE_SOURCE_SET_ID

KREL_DISTRIBUTIONS

DISTRIBUTION_ID

TOP_INSTANCE_SOURCE_SET_ID

KWFL_WORKFLOWS_NLS

WORKFLOW_ID

WORKFLOW_ID

KWFL_WORKFLOW_INSTANCES

WORKFLOW_INSTANCE_ID

WORKFLOW_INSTANCE_ID

KWFL_WORKFLOW_INSTANCE_STEPS

WORKFLOW_INSTANCE_STEP_ID

WORKFLOW_INSTANCE_STEP_ID

KWFL_WORKFLOW_STEPS_NLS

WORKFLOW_STEP_ID

WORKFLOW_STEP_ID

Column Descriptions

Column Name

Null?

Data Type

Description

STEP_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_STEP_ID

NOT NULL

NUMBER

This identifies the instance of the step to which this step transaction belongs. This is a foreign key into KWFL_WORKFLOW_INSTANCE_STEPS.

WORKFLOW_INSTANCE_ID

NOT NULL

NUMBER

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

INSTANCE_SOURCE_SET_ID

NOT NULL

NUMBER

This denormalized column identifies the ID of the entity to which this step transaction belongs. This is a foreign key into KDLV_PACKAGES, KREL_DISTRIBUTIONS, KCRT_REQUESTS, KNTA_REPORT_SUBMISSIONS, or KWFL_STEP_TRANSACTIONS.

INSTANCE_SOURCE_TYPE_CODE

NOT NULL

VARCHAR2(30)

This denormalized column identifies whether the type of the entity using the workflow. Choices are "CR", "DIST", "IR", "REPORT", and "WORKFLOW" as specified by the lookup WF_INSTANCE_SOURCE_TYPE.

INSTANCE_SOURCE_ID

NOT NULL

NUMBER

This denormalized column identifies the ID of the detail entity using the workflow. In the case of "IR", "DIST", "REPORT" and "WORKFLOW", the value in this column is identical to that in INSTANCE_SOURCE_SET_ID.

TOP_INSTANCE_SOURCE_TYPE_CODE

NOT NULL

VARCHAR2(30)

This denormalized column identifies whether the type of the entity using the Top-Level workflow (Non-Subworkflow). Choices are "CR", "DIST", "IR", and "REPORT".

TOP_INSTANCE_SOURCE_SET_ID

NOT NULL

NUMBER

This denormalized column identifies the ID of the detail entity using the Top-Level workflow (Non-Subworkflow). This is a foreign key into KDLV_PACKAGES, KREL_DISTRIBUTIONS, KCRT_REQUESTS, KNTA_REPORT_SUBMISSIONS.

TOP_INSTANCE_SOURCE_ID

NOT NULL

NUMBER

This denormalized column identifies the ID of the detail entity using the Top-Level workflow (Non-Subworkflow). In the case of "IR", "DIST", "REPORT", the value in this column is identical to that in TOP_INSTANCE_SOURCE_SET_ID.

WORKFLOW_ID

NOT NULL

NUMBER

This denormalized column identifies the workflow that is being run.

WORKFLOW_STEP_ID

NOT NULL

NUMBER

This denormalized column identifies the step in the workflow to which this transaction belongs.

GROUP_ID

NULLABLE

NUMBER

This identifies a set of step transactions that were triggered directly by the same event. These Step Transaction rows necessarily also share the same WORKFLOW_STEP_ID. This column is used internally by the Workflow Engine to update these transactions en mass.

STATUS

NOT NULL

VARCHAR2(30)

This specifies the current status of the step transaction. Choices are specified by the seeded lookup WF_TXN_STATUS.

RESET_FLAG

NOT NULL

VARCHAR2(1)

This flag marks whether this step transaction resulted in a reset in the workflow instance.

SUB_WORKFLOW_FLAG

NOT NULL

VARCHAR2(1)

This flag marks whether this step transaction record is for a subworkflow step.

USER_COMMENT

NULLABLE

VARCHAR2(400)

This hold the comments entered by the users updating this step transaction.

TIMEOUT_DATE

NULLABLE

DATE

This specifies the final day by which this step transaction must complete.

CONCURRENT_REQUEST_ID

NULLABLE

NUMBER

This identifies the concurrent request (if any) that was spawned by this step transaction.

RESULT_VALUE

NULLABLE

VARCHAR2(200)

If this step transaction completed successfully, this holds the hidden result value. Valid values in this field are determined by the validation associated to the given workflow step.

VISIBLE_RESULT_VALUE

NULLABLE

VARCHAR2(200)

If this step transaction completed successfully, this holds the result value to be displayed to the user. Valid values in this field are determined by the validation associated to the given workflow step.

ERROR_VALUE

NULLABLE

VARCHAR2(200)

If this step transaction completed in error, this holds the hidden error value. These values are chosen among the codes of lookup WF_ERROR.

VISIBLE_ERROR_VALUE

NULLABLE

VARCHAR2(200)

If this step transaction completed in error, this holds error value to be displayed to the user. These values are chosen among the meaning values of lookup WF_ERROR.

ERROR_MESSAGE

NULLABLE

VARCHAR2(240)

If this step transaction completed in error, this holds the detailed information about the error.

USER_STATUS_VALUE

NULLABLE

VARCHAR2(200)

This is the NVL of RESULT_VALUE, ERROR_VALUE, and STATUS.

VISIBLE_USER_STATUS_VALUE

NULLABLE

VARCHAR2(200)

This is the NVL of VISIBLE_RESULT_VALUE, VISIBLE_ERROR_VALUE, and visible status. Additionally, the scheduled date or spawned concurrent request ID, or spawned Package is appended to the VISIBLE_USER_STATUS_VALUE. This field is directly displayed in the status tabs of the Issue and Package Detail windows.

SCHEDULED_TASK_ID

NULLABLE

NUMBER

This identifies the row in the KNTA_SCHEDULED_TASKS table that was created by this step transaction. A row is created in KNTA_SCHEDULED_TASKS when the user chooses to schedule an execution for a later date.

PENDING_EXEC_OBJECT_ID

NULLABLE

NUMBER

This identifies the command execution that was created by this step transaction. This is a foreign key into KWFL_PENDING_EXEC_OBJECTS.

EXECUTION_BATCH_ID

NULLABLE

NUMBER

This identifies a set of command executions being performed together. Step transactions directly triggered by the same event will share a batch ID This column is used by the execution manager performs and organizes the execution of the items as a set.

CHILD_REQUEST_ID

NULLABLE

NUMBER

This identifies the request (if any) that was spawned by this step transaction.

CHILD_PACKAGE_ID

NULLABLE

NUMBER

This identifies the Package (if any) that was spawned by this step transaction.

SOURCE_ENVIRONMENT_ID

NULLABLE

NUMBER

This column specifies the source environment for the step transaction. It is read from the column SOURCE_ENVIRONMENT_ID in KWFL_WORKFLOW_STEPS.

DEST_ENVIRONMENT_ID

NULLABLE

NUMBER

This column specifies the destination environment for the step transaction. It is read from the column DEST_ENVIRONMENT_ID in KWFL_WORKFLOW_STEPS.

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.

PARAMETER_SET_CONTEXT_ID

NULLABLE

NUMBER

This identifies the context for this entity's parameters.

PARAMETER1-25

NULLABLE

VARCHAR2(200)

Parameter set segment. This is used for command executions with parameters (for example, ai_create_request).

VISIBLE_PARAMETER1-25

NULLABLE

VARCHAR2(200)

Parameter set segment

Indexes

Index Name

Index Type

Sequence

Column Name

KWFL_STEP_TRANSACTIONS_N1

NONUNIQUE

1

GROUP_ID

KWFL_STEP_TRANSACTIONS_N2

NONUNIQUE

1

WORKFLOW_INSTANCE_ID

KWFL_STEP_TRANSACTIONS_N2

NONUNIQUE

2

WORKFLOW_INSTANCE_STEP_ID

KWFL_STEP_TRANSACTIONS_N3

NONUNIQUE

1

TIMEOUT_DATE

KWFL_STEP_TRANSACTIONS_N3

NONUNIQUE

2

STATUS

KWFL_STEP_TRANSACTIONS_N5

NONUNIQUE

1

INSTANCE_SOURCE_SET_ID

KWFL_STEP_TRANSACTIONS_N6

NONUNIQUE

1

STATUS

KWFL_STEP_TRANSACTIONS_N6

NONUNIQUE

2

TIMEOUT_DATE

KWFL_STEP_TRANSACTIONS_N7

NONUNIQUE

1

TOP_INSTANCE_SOURCE_ID

KWFL_STEP_TRANSACTIONS_N8

NONUNIQUE

1

TOP_INSTANCE_SOURCE_SET_ID

KWFL_STEP_TRANSACTIONS_U1

UNIQUE

1

STEP_TRANSACTION_ID

Sequences

Sequence Name

Sequence Type

KWFL_STEP_TRANSACTIONS_S

STEP_TRANSACTION_ID

KWFL_STEP_TRANSACTION_GROUPS_S

GROUP_ID