| condition_id |
INT |
Condition Identifier |
| condition_type |
INT |
Condition expression type, (1 = value, 2 = field, 3 = constant, 4 = change) |
| field_id* |
INT |
Related field identifier |
| field_id2 |
INT |
Second field identifier for comparison conditions |
| field_name |
NVARCHAR (510) |
Descriptive name of the additional field |
| field_type_id |
INT |
Additional field type identifier, reference the ASMS_TYPES.id table |
| field_value |
NVARCHAR (510) |
Additional field value |
| field2_name |
NVARCHAR (510) |
Descriptive name of the additional comparison field |
| field2_value |
NVARCHAR (510) |
Value of the additional comparison field |
| function_id |
INT |
Condition function identifier |
| function_name |
NVARCHAR (510) |
Descriptive name of the condition function |
| function_value |
NVARCHAR (510) |
Condition Function Value |
| id* |
INT |
Unique identifier of the record |
| label |
NVARCHAR (8000) |
Create an expression-related tag string for the UI |
| operador |
CHAR (20) |
Expression operator name |
| operator_id |
INT |
Expression operator identifier |
| operator_value |
NVARCHAR (100) |
Operator Value |
| table_id |
INT |
Identifies the item types of the condition expression, (1 = case, 2 = additional field, 3 = customer, 4 = company, 5 = Ci, 6 = time, 7 = progress, 8 = expected date, 9 = real-time, 10 = fulfillment, 11 = knowledge base, 12 = total ci, 13 = service, 14 = packet, 15 = event, 16 = operadot and, 17 = operator or, 18 = survey, 19 = metric, 20 = metric with data, 21 = unlimited metric, 22 = cases of a service, 23 = cost of a service, 24 = effort of a service, 25 = price of a service) |
| table_id2 |
INT |
Identifies the item types in the comparison condition expression |
| task_id* |
INT |
Identifier of the related parent condition, reference the ASMS_TASK_TEMPLATE.id table |
| text |
NVARCHAR (8000) |
Create a text version of the condition expression |
| valor |
NVARCHAR (200) |
Condition item value |
| value_text |
NVARCHAR (8000) |
Description of the value |
| value2 |
NVARCHAR (510) |
Second value for comparison operations |
| value2_name |
NVARCHAR (510) |
Name of the second value for comparison operations |
