| Table Name: | anls_rule |
| Table Number: | 5902 |
| Group: | Analytics |
| Description: | Information about the rules |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| class_value | CHAR | varchar | 255 | The value of the class | Search (1) | |||
| description | CHAR | varchar | 255 | ALLOW_NULL | Description of the rule description | Search (2) | ||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| display | CHAR | varchar | 1333 | Conditions of the rule | Search (4) | |||
| header | CHAR | varchar | 255 | A string that contains the first 3 attributes of the rule | Search (4) | |||
| importance | CHAR | varchar | 80 | Rule importance (high, medium, low). | Search (3) | |||
| is_manual | LONG | tinyint | 0 | DIRECT | Indicates whether the rule is generated manually; 1=Yes, 0=No; default=0 | Search (2) | ||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (3) | ||
| rule_num | LONG | int | DIRECT | A serial number of the rule | Search (2) |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views | Set Name | Type ID Stored in | Objid Stored In |
|---|---|---|---|---|---|---|---|---|---|---|
| Exclusive Set Relations | ||||||||||
| anls_rule2md_lr_param | MTM | md_lr_param | md_lr_param2anls_rule | Model's active rules | mtm_anls_rule7_ md_lr_param5 | |||||
| anls_rule2rs_cls_comp | OTM | rs_cls_comp | class_comp2anls_rule | The complex classes of the rule (each complex class contains 2 classes) | ||||||
| anls_rule2rs_cls_simp | OTM | rs_cls_simp | class_simp2anls_rule | The simple classes of the rule (e.g. churn=yes) | ||||||
| anls_rule2rs_cnd_comp | OTM | rs_cnd_comp | cond_comp2anls_rule | The complex conditions of the rule | ||||||
| anls_rule2rs_cnd_simp | OTM | rs_cnd_simp | cond_simp2anls_rule | The simple conditions of the rule (e.g. state=NY) | ||||||
| anls_rule2rule_set_de | MTO | rule_set_de | rule_set_de2anls_rule | Rule set's rule | Search (1) | |||||
| anls_rule2rule_stats | OTM | rule_stats | rule_stats2anls_rule | Statistics of a rule | ||||||
| anls_rule2weight | OTM | weight | weight2anls_rule | Weight behind the rule | weight_for | source_type | source_lowid | |||
| Index Name | Fields | Flags |
|---|
| Index Name | Fields | Additional Information |
|---|---|---|
| cv5902 | class_value | nonclustered located on PRIMARY |
| imp5902 | importance | nonclustered located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 5967 | rule_stat_view | anls_rule, rs_cls_simp, rule_set, rule_set_de, rule_stats |
| 6053 | br_definition_view | anls_rule, model, rs_cls_simp, rule_stats, weight, weight_set |
| 6054 | lr_definition_view | anls_rule, model, rule_stats, weight, weight_set, wgt_att_cnt, wgt_att_dsc |
| 6060 | weight_rule_view | anls_rule, gbst_elm, model, weight, weight_set |
| anls_rule | |||