Table Name:cl_rule
Table Number:5385
Group:Mixed Media
Description:Conditions for executing one or more cl_actions. The rule is used to check for matching keywords or to evaluate complex expressions
Flags: 
Baseline/Custom:Baseline
Fields:
Field NameCommon TypeDatabase TypeGeneric Field IDArray SizeDefaultFlagsCommentField Used in Views
activeLONGtinyint  DIRECT Current status of the rule; i.e., 0=inactive, 1=active, 2=invalid, default=1  
confidenceLONGtinyint  DIRECT Indication of the quality of the match. It can be adjusted automatically based on the matches. If there is match, increase this number. Expresses as a probability, range=0-100, default=0  
descriptionCHARvarchar 255  Description of the rule  
devLONGint151 DIRECT, ALLOW_NULL Row version number for mobile distribution purposes  
expressionCHARtext   ALLOW_NULL Expression to be evaluated  
focus_typeLONGsmallint   DIRECT Gives the object type number the rule is constrained to operate on; e.g., 5208=communication  
localeLONGsmallint  DIRECT Preferred language for receiving communications from the system; i.e., 0=English, 1=SJIS, 2=French, 3=German, 4=Spanish, 5=Chinese Big5 (traditional character), 6=Chinese GB (simplified character), 7=Korean, 8-12 (Reserved), Default=0  
objidLONGint3  DIRECT Internal record number  
rankLONGint   DIRECT Sequence number of the rule. Used for ordering the execution of rules  
stop_eval_indLONGtinyint  DIRECT Indicates whether evaluation of subsequent rules in rank order should be terminated if the current rule matches; i.e., 0=no, 1=yes, default=0  
titleCHARvarchar280  Title of the rule  
Relations:
RelationTypeTarget ObjectInverse RelationCommentFlagsMTM TableUsed in Views
cl_rule2cl_actionOTMcl_actioncl_action2cl_ruleActions triggered by the rule    
Indexes: (Defined in Clarify Schema)
Index NameFieldsFlags
cl_title_indtitleUNIQUE 
cl_focus_indfocus_type:rankUNIQUE 
Indexes (Defined in Database):
Index NameFieldsAdditional Information
cl_focus_indfocus_type, ranknonclustered, unique located on PRIMARY
cl_title_indtitlenonclustered, unique located on PRIMARY
objindexobjidclustered, unique located on PRIMARY
Referenced in Views:
View IDView NameTables
My Recent Objects
cl_rule