Share this page

# 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

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: