Table Name:	template
Table Number:	5371
Group:	Mixed Media
Description:	Contains pre-defined, auto-suggest responses to Mixed Media requests
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_template

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
active	LONG	tinyint			1	DIRECT	Indicates whether the template is active; i.e., 0=inactive, 1=active, default=1	Search (1)
body	CHAR	text				ALLOW_NULL	Body of the template
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
id_number	CHAR	varchar	4	40			Unique template number assigned based on auto-numbering definition	Search (1)
objid	LONG	int	3			DIRECT	Internal record number	Search (1)
title	CHAR	varchar		255			Title of the template	Search (1)
update_stamp	CLK_TIME	datetime	46				Date/time of last update to the template

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
tmplt2cl_action	OTM	cl_action	cl_action2template	Classification actions using the template
tmplt2cl_result	OTM	cl_result	cl_result2template	Classification results generated from the template
tmplt2communication	OTM	communication	cmcn2template	Communications generated from the template
tmplt2doc_inst	OTM	doc_inst	doc_inst2template	Attachments used by the template
tmplt2user	MTO	user	user2template	User who originated the template
tmplt2workaround	MTO	workaround	workaround2template	Workaround used by the template

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
id_ind	id_number	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
id_ind	id_number	nonclustered, unique 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

template

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user