Share this page

# KWFL_CONDITIONS

This table stores only five rows which define the five seeded conditions: AND, OR, SYNC, FIRST_LINE and LAST_LINE. Thus, a user cannot edit any of those conditions. Workflow steps can be of three types: decisions, conditions, and executions.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KNTA_USERS | USER_ID | CREATED_BY
KNTA_USERS | USER_ID | LAST_UPDATED_BY
KNTA_VALIDATIONS_NLS | VALIDATION_ID | RESULT_VALIDATION_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
CONDITION_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
CONDITION_NAME | NOT NULL | VARCHAR2(30) | Name of the condition, which may be up to 30 characters in length.
DESCRIPTION | NULLABLE | VARCHAR2(240) | Optional description of the condition
CONDITION_TYPE_CODE | NOT NULL | VARCHAR2(30) | One of 'AND', 'OR', 'SYNC', 'FIRST_LINE' and 'LAST_LINE', which are the values to represent the five possible condition types.
RESULT_VALIDATION_ID | NOT NULL | NUMBER | Seeded validation of the possible outcome values of this condition.
TIMEOUT_DAYS | NULLABLE | NUMBER | Not used.
PRODUCT_SCOPE_CODE | NOT NULL | VARCHAR2(30) | Which product(s) workflows may use this condition. Defined by lookup type 'PRODUCT_SCOPE_TYPE'. May be 'AI', 'RI', or 'ALL'. AI is Deployment Management, RI is Demand Management
ICON_NAME | NULLABLE | VARCHAR2(80) | Name of GIF or JPG file that resides in the icons directory on the server, which will be used to display this condition in graphical views of the workflow.
ENABLED_FLAG | NOT NULL | VARCHAR2(1) | Whether the condition can be used. Conditions are always enabled ('Y').

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KWFL_CONDITIONS_U1 | UNIQUE | 1 | CONDITION_ID
KWFL_CONDITIONS_U2 | UNIQUE | 1 | CONDITION_NAME

## Sequences

Sequence Name | Sequence Type
--- | ---
KWFL_CONDITIONS_S | CONDITION_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: