Table Name: | rule_cond |
Table Number: | 287 |
Group: | Policy Mgr |
Description: | Defines a business rule condition |
Flags: | |
Baseline/Custom: | Baseline |
Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
---|---|---|---|---|---|---|---|---|
dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
objid | LONG | int | 3 | DIRECT | Internal record number | Search (1) | ||
op1_type | LONG | tinyint | DIRECT | Type of the first operand | Search (1) | |||
op2_type | LONG | tinyint | DIRECT | Type of the second operand | Search (1) | |||
operand1 | CHAR | varchar | 255 | First operand of the rule condition | Search (1) | |||
operand2 | CHAR | varchar | 255 | Second operand of the rule condition | Search (1) | |||
operator | LONG | tinyint | DIRECT | Relational operator of rule condition | Search (1) | |||
type | LONG | tinyint | DIRECT | Internal designation of type of rule condition | Search (1) | |||
x_rank | LONG | int | 0 | USER_DEFINED | Rank used for ordering conditions of a rule. |
Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
---|---|---|---|---|---|---|---|
parentrule2com_tmplte | MTO | com_tmplte | condition2rule_cond | Parent business rule of the condition | Search (1) | ||
subcond2rule_cond | OTM | rule_cond | parentcond2rule_cond | Reserved; not used | |||
parentcond2rule_cond | MTO | rule_cond | subcond2rule_cond | Reserved; not used |
Index Name | Fields | Flags |
---|
Index Name | Fields | Additional Information |
---|---|---|
objindex | objid | clustered, unique located on PRIMARY |
View ID | View Name | Tables |
---|---|---|
288 | rule_conds | com_tmplte, rule_cond |
rule_cond | |||