Share this page

# KWFL_STEP_TRANSITIONS

This table stores information that defines transition information. Each row defines a transition from one workflow step to another.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KNTA_USERS | USER_ID | CREATED_BY
KWFL_WORKFLOW_STEPS_NLS | WORKFLOW_STEP_ID | FROM_WORKFLOW_STEP_ID
KNTA_USERS | USER_ID | LAST_UPDATED_BY
KWFL_WORKFLOW_STEPS_NLS | WORKFLOW_STEP_ID | TO_WORKFLOW_STEP_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
STEP_TRANSITION_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
TRANSITION_TYPE_CODE | NOT NULL | 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 | NOT NULL | NUMBER | ID of the source workflow step
TO_WORKFLOW_STEP_ID | NOT NULL | NUMBER | ID of the target workflow step
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
REQUIRE_NOTE_FLAG | NULLABLE | VARCHAR2(1) | Indicates whether the transition requires that the user enter a note
DEFINITION_LANGUAGE | NOT NULL | VARCHAR2(40) | Definition language
REFERENCE_CODE | NOT NULL | VARCHAR2(200) | Reference code

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KWFL_STEP_TRANSITIONS_N1 | NONUNIQUE | 1 | FROM_WORKFLOW_STEP_ID
KWFL_STEP_TRANSITIONS_N2 | NONUNIQUE | 1 | TO_WORKFLOW_STEP_ID
KWFL_STEP_TRANSITIONS_U1 | UNIQUE | 1 | STEP_TRANSITION_ID
SYS_C005199870 | UNIQUE | 1 | REFERENCE_CODE

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