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 |