Table Name:	search_control
Table Number:	361
Group:	Full Text Search
Description:	Search control data for the full text search engine
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_search_control

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
availability	CHAR	varchar		20			Available for use; i.e., AVAILABLE, UNAVAILABLE
default_status	CHAR	varchar		5			Turned on by default; i.e., ON, OFF
description	CHAR	varchar		255			Brief description of the option or parameter
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
display_order	LONG	int				DIRECT	Sort order or rank within a particular parameter set
external_name	CHAR	varchar		80			Name of option as seen in the user interface
internal_name	CHAR	varchar		255			The internal name as recognized by the FTS engine
objid	LONG	int	3			DIRECT	Internal record number
parameter_set	CHAR	varchar		30			Parameter setting; i.e., collection, sort_method, match_method, properties_used, search_options, auto_search
reserved	CHAR	varchar		40			Reserved; internal
source_object	LONG	int				DIRECT	Type of object the option applies to; i.e., case, CR, etc
target_type	CHAR	varchar		10			Valid only for parameter set=collection. FROM_DB or EXTERNAL_DOC

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
search_prefs2user	MTM	user	search_prefs2search_control	Users related to the search control		mtm_user47_ search_control0

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

Index Name	Fields	Additional Information
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables

My Recent Objects

search_control

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user