Share this page

# KWFL_STEP_TRANSITIONS_INT

This table stores data used for migrating the workflow definition between instances.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KWFL_TRANSACTIONS_INT | TRANSACTION_ID | PARENT_TRANSACTION_ID
KWFL_WORKFLOW_STEPS_NLS | WORKFLOW_STEP_ID | DEST_TO_WORKFLOW_STEP_ID
KWFL_WORKFLOW_STEPS_NLS | WORKFLOW_STEP_ID | DEST_FROM_WORKFLOW_STEP_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
TRANSACTION_ID | NOT NULL | NUMBER | System-generated identifier
PARENT_TRANSACTION_ID | NOT NULL | NUMBER | Transaction ID of the parent table being imported
GROUP_ID | NOT NULL | NUMBER | This value is used to tie records in the interface tables together. Most of database processing is done based on this value
EXISTS_FLAG | NULLABLE | VARCHAR2(1) | If set to 'Y' then the record already exists in the database.
PROCESS_PHASE | NULLABLE | NUMBER | Indicates which phase a record is at: Pending, Deriving, Validating, Importing or Completed
PROCESS_STATUS | NULLABLE | NUMBER | Indicates the current status of the interface record: Pending, In Process, Errored or Completed
CREATED_BY_USERNAME | NULLABLE | VARCHAR2(200) | Username that creates the record
CREATION_DATE | NULLABLE | DATE | Date record was created
DEST_CREATED_BY | NULLABLE | NUMBER | Identifier for the user who created the record
DEST_CREATION_DATE | NULLABLE | DATE | Date record was created
DEST_LAST_UPDATED_BY | NULLABLE | NUMBER | Identifier for the user who last updated the record
DEST_LAST_UPDATE_DATE | NULLABLE | DATE | Date record was last updated
STEP_TRANSITION_ID | NULLABLE | NUMBER | Source System-generated identifier
DEST_STEP_TRANSITION_ID | NULLABLE | NUMBER | Destination System-generated identifier
TRANSITION_TYPE_CODE | NULLABLE | VARCHAR2(30) | Defined by the lookup type WF_TRANSITION_TYPE. One of the following values: "SPECIFIC_VALUES", "OTHER_VALUES", "ALL_VALUES", "SPECIFIC_ERROR", "OTHER_ERRORS", "ALL_ERRORS".
OPERATOR_CODE | NULLABLE | VARCHAR2(30) | Defined by the lookup type WF_TRANS_OPERATOR. One of the following "=", "!=". If the validation is a text field with the numeric mask set, or if it is a date field, then the following values are also possible: "<", ">", "<=", ">=".
RESULT_VALUE | NULLABLE | VARCHAR2(200) | A value that is defined by the validation.
VISIBLE_RESULT_VALUE | NULLABLE | VARCHAR2(200) | A value that is defined by the validation. This is the value that is shown to the user.
FROM_WORKFLOW_STEP_ID | NULLABLE | NUMBER | ID of the source workflow step
FROM_WORKFLOW_STEP_NAME | NULLABLE | VARCHAR2(80) | Name of the source workflow step
DEST_FROM_WORKFLOW_STEP_ID | NULLABLE | NUMBER | ID of the source workflow step in destination
TO_WORKFLOW_STEP_ID | NULLABLE | NUMBER | ID of the target workflow step
TO_WORKFLOW_STEP_NAME | NULLABLE | VARCHAR2(80) | Name of the target workflow step
DEST_TO_WORKFLOW_STEP_ID | NULLABLE | NUMBER | ID of the target workflow step in destination
DRAW_LABEL_POS | NULLABLE | VARCHAR2(30) | Relative position of where the label is displayed in the workflow layout. It is a real number between 0.0 and 1.0.
DRAW_JOINT_COORDS | NULLABLE | VARCHAR2(1000) | A list of coordinates separated by ";". Each coordinate is a pair of integers, separated by a comma. Example: "100,200;300,400" defines two joints at positions (100,200) and (300,400). If NULL, a straight line is drawn from the source to the target step figure.
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

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KWFL_STEP_TRANSITIONS_INT_N1 | NONUNIQUE | 1 | TRANSACTION_ID
KWFL_STEP_TRANSITIONS_INT_N2 | NONUNIQUE | 1 | GROUP_ID
KWFL_STEP_TRANSITIONS_INT_N2 | NONUNIQUE | 2 | PROCESS_STATUS

## 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: