Table Name:	cl_result
Table Number:	5387
Group:	Mixed Media
Description:	Documents the result obtained for an execution of the matching rule
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_cl_result

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
action_auto_exec	LONG	tinyint			0	DIRECT	The value of cl_action.auto_exec_ind at the time the result was generated	Search (1)
action_rank	LONG	int				DIRECT	The value of cl_action.rank at the time the result was generated	Search (1)
action_type	LONG	tinyint			0	DIRECT	Execution type; i.e., 0=script, 1=auto-suggest, default=0
create_date	CLK_TIME	datetime					The create date and time of the result
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
exec_log	CHAR	text	23			ALLOW_NULL	Diagnostic information to review the classification steps
focus_lowid	LONG	int				DIRECT, ALLOW_NULL	The internal record number of the object that was responded to by the result	Search (1)
focus_type	LONG	smallint				DIRECT	The object type of the object which was responded to by the result: currently=5208	Search (1)
objid	LONG	int	3			DIRECT	Internal record number	Search (1)
rule_confidence	LONG	int				DIRECT	The value of cl_rule.confidence at the time the result was generated	Search (1)
rule_rank	LONG	int				DIRECT	The value of cl_rule.rank at the time the result was generated	Search (1)

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
cl_result2cl_action	MTO	cl_action	cl_action2cl_result	Action which generated the result
cl_result2template	MTO	template	tmplt2cl_result	Template related to the cl_action which generated the result			Search (1)

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

Index Name	Fields	Additional Information
ind_cl_result2cl_action	cl_result2cl_action, cl_result2template	nonclustered located on PRIMARY
ind_cl_result2template	cl_result2template, cl_result2cl_action	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
5396	cl_picklist	cl_result, template

My Recent Objects

cl_result

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user