Share this page

# KWFL_TRANSACTIONS_INT

This table is used when you are migrating a Workflow from one instance to another.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KNTA_USERS | USER_ID | CREATED_BY
KWFL_STEP_TRANSACTIONS | STEP_TRANSACTION_ID | CURRENT_STEP_TRANSACTION_ID
KNTA_USERS | USER_ID | DELEGATED_TO_USER_ID
KCRT_REQUESTS | REQUEST_ID | INSTANCE_SOURCE_ID
KDLV_PACKAGE_LINES | PACKAGE_LINE_ID | INSTANCE_SOURCE_ID
KCRT_REQUESTS | REQUEST_ID | INSTANCE_SOURCE_SET_ID
KDLV_PACKAGES | PACKAGE_ID | INSTANCE_SOURCE_SET_ID
KNTA_USERS | USER_ID | LAST_UPDATED_BY
KWFL_WORKFLOWS_NLS | WORKFLOW_STEP_ID | TO_WORKFLOW_STEP_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
--- | --- | --- | ---
TRANSACTION_ID | NOT NULL | NUMBER | System-generated identifier
CREATION_DATE | NULLABLE | DATE | Date record was created
CREATED_USERNAME | NOT NULL | VARCHAR2(200) | User that created the record
CREATED_BY | NULLABLE | NUMBER | Identifier for the user who created the record
LAST_UPDATE_DATE | NULLABLE | DATE | Date record was last updated
LAST_UPDATED_USERNAME | NOT NULL | VARCHAR2(200) | User that last updated the record
LAST_UPDATED_BY | NULLABLE | NUMBER | Identifier for the user who last updated the record
EVENT | NOT NULL | VARCHAR2(40) | Identifies the transaction that the record is indented to perform
GROUP_ID | NULLABLE | NUMBER | Typical use is that a group_id is returned to the caller of run_interface procedure. This can be used to re-submit the records.
WORKFLOW_ENGINE_BATCH_ID | NULLABLE | NUMBER | Internal use only
PROCESS_PHASE | NOT NULL | NUMBER | Internal use only
PROCESS_STATUS | NOT NULL | NUMBER | Describes the current status of the record. For example, In Progress and Error.
SOURCE_TYPE_CODE | NULLABLE | VARCHAR2(30) | Internal use only
SOURCE | NULLABLE | VARCHAR2(100) | A alpha-numeric string can be provided to indicate a group of records that need to be processed.
INSTANCE_SOURCE_TYPE_CODE | NULLABLE | VARCHAR2(30) | Describes the product that the interface is invoked on. Typically internal use only.
INSTANCE_SOURCE_SET_NUMBER | NULLABLE | VARCHAR2(40) | Describes the source set number. For example, request number and package number.
INSTANCE_SOURCE_SET_ID | NULLABLE | NUMBER | Identifier for the source set. For example, request ID and package ID.
INSTANCE_SOURCE_LINE_SEQ | NULLABLE | NUMBER | Line sequence number for the package lines
INSTANCE_SOURCE_ID | NULLABLE | NUMBER | Identifier for the source line such as package line ID.
WORKFLOW_STEP_NAME | NULLABLE | VARCHAR2(80) | Step name of the workflow that needs to be processed.
WORKFLOW_STEP_SEQ | NULLABLE | VARCHAR2(30) | Step sequence of the workflow that needs to be processed.
RESULT_VALUE | NULLABLE | VARCHAR2(200) | Hidden result value of the workflow transaction that user is initiating.
VISIBLE_RESULT_VALUE | NULLABLE | VARCHAR2(200) | Visible result value of the workflow transaction that user is initiating.
USER_COMMENTS | NULLABLE | VARCHAR2(200) | Comments that the user wants to attach to the notes field while processing the transaction.
DELEGATED_TO_USERNAME | NULLABLE | VARCHAR2(200) | Describes the user name who this step needs to be delegated (In case the transaction is a delegation)
DELEGATED_TO_USER_ID | NULLABLE | NUMBER | Describes the user ID who this step needs to be delegated (In case the transaction is a delegation)
SCHEDULE_DATE | NULLABLE | DATE | While scheduling a task, this field will specify the date/time the task should start.
WORKFLOW_ID | NULLABLE | NUMBER | Internal use only
WORKFLOW_INSTANCE_ID | NULLABLE | NUMBER | Internal use only
WORKFLOW_STEP_ID | NULLABLE | NUMBER | Identifier of the workflow step that needs to be processed.
WORKFLOW_INSTANCE_STEP_ID | NULLABLE | NUMBER | Internal use only
CURRENT_STEP_TRANSACTION_ID | NULLABLE | NUMBER | Internal use only
APPROVALS_REQUIRED_CODE | NULLABLE | VARCHAR2(30) | Internal use only
EVENT_GROUP_ID | NULLABLE | NUMBER | Internal use only
CMD_EXECUTION_SCHD_TASK_ID | NULLABLE | NUMBER | Internal use only
TO_WORKFLOW_STEP_SEQ | NULLABLE | VARCHAR2(30) | In case of force transition event, this describes the workflow step sequence to transition to.
TO_WORKFLOW_STEP_NAME | NULLABLE | VARCHAR2(80) | In case of force transition event, this describes the workflow step name to transition to.
TO_WORKFLOW_STEP_ID | NULLABLE | NUMBER | In case of force transition event, this describes the workflow ID sequence to transition to.
DATA_LANG | NULLABLE | VARCHAR2(40) | Internal use only

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KWFL_TRANSACTIONS_INT_N1 | NONUNIQUE | 1 | CMD_EXECUTION_SCHD_TASK_ID
KWFL_TRANSACTIONS_INT_N1 | NONUNIQUE | 2 | PROCESS_STATUS
KWFL_TRANSACTIONS_INT_N2 | NONUNIQUE | 1 | GROUP_ID
KWFL_TRANSACTIONS_INT_N2 | NONUNIQUE | 2 | PROCESS_PHASE
KWFL_TRANSACTIONS_INT_N2 | NONUNIQUE | 3 | PROCESS_STATUS
KWFL_TRANSACTIONS_INT_N2 | NONUNIQUE | 4 | EVENT
KWFL_TRANSACTIONS_INT_N3 | NONUNIQUE | 1 | WORKFLOW_ENGINE_BATCH_ID
KWFL_TRANSACTIONS_INT_U1 | UNIQUE | 1 | TRANSACTION_ID

## Sequences

This table uses no sequences.

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: