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.