Table Name:	canned_resp
Table Number:	4677
Group:	Dovetail
Description:	Canned Responses
Flags:
Baseline/Custom:	Custom

Fields
Relations
Indexes
Referenced in Views

select * from table_canned_resp

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		255		USER_DEFINED	Availability. Personal, Shared to Workgroups, Shared to Everyone
body	CHAR	text				USER_DEFINED	Canned Response Content
id	CHAR	varchar		255		USER_DEFINED	Unique ID
modify_stmp	CLK_TIME	datetime				USER_DEFINED	When the response was last modified.
name	CHAR	varchar		255		USER_DEFINED	name of the Response
object_type	CHAR	varchar		255		USER_DEFINED	Object Type this response applies to. i.e. Case, Subcase
objid	LONG	int	3			USER_DEFINED	Internal record number
status	CHAR	varchar		255		USER_DEFINED	Status. Active, Inactive

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
canned_response2workgroup	MTM	hgbst_elm	workgroup2canned_response	Workgroups that this canned response has been shared to	USER_DEFINED	mtm_hgbst_elm2_ canned_resp0
canned_resp2shared_item	OTM	shared_item	shared_item2canned_resp	Canned responses that have been shared.	USER_DEFINED
canned_response2user	MTO	user	user2canned_response	User that created this canned response	USER_DEFINED

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
can_rsp_name_idx	name:object_type:canned_response2user	UNIQUE
can_rsp_id_idx	id	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
can_rsp_id_idx	id	nonclustered, unique located on PRIMARY
can_rsp_name_idx	name, object_type, canned_response2user	nonclustered, unique located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables

My Recent Objects

canned_resp

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user