Table Name:	com_tmplte
Table Number:	76
Group:	Policy Mgr
Description:	Object used to define business rules and customer commitments
Flags:	CACHEOBJIDS
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_com_tmplte

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
action	CHAR	text				ALLOW_NULL	Action that occurs when time bomb fires. For notifications, this is the message
condition	CHAR	varchar		255			Condition that must be true for time bomb to fire
description	CHAR	varchar		255			Description of what the template is used for
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
flags	LONG	int				DIRECT	Flags controlling associated time bomb behavior
objid	LONG	int	3			DIRECT	Internal record number	Search (2)
repeat_num	LONG	int				DIRECT	Describes the number of times to repeat the template
repeat_period	LONG	int				DIRECT	Amount of elapsed time between repeats
rule_set	CHAR	varchar		20			Designates an administrative group to which a business rule is assigned; e.g., case/Subcase Only, Change Request, Change Status
time_til_esc	LONG	int				DIRECT	Elapsed time until time bomb will fire <from creation> in seconds
time_type	LONG	tinyint				DIRECT	Describes the elapsed time relative to the focus object in seconds
time_units	LONG	tinyint				DIRECT	Describes what type of unit the elapsed time is in
title	CHAR	varchar	2	40			The title used for identifying the template
type	LONG	int				DIRECT	Type for the object
urgency	LONG	int				DIRECT	The urgency of the associated time bombs

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
escal_act2com_tmplte	MTO	com_tmplte	inv_escal2com_tmplte	Escalation rule for the rule
inv_escal2com_tmplte	OTM	com_tmplte	escal_act2com_tmplte	Rule calling the rule for an escalation
condition2rule_cond	OTM	rule_cond	parentrule2com_tmplte	Related conditions for the business rule to fire
origin2time_bomb	OTM	time_bomb	rule2com_tmplte	Time bombs originated by the business rule
escal_msg2time_bomb	OTM	time_bomb	trckr_info2com_tmplte	Related escalation messages triggered by the business rule
commit_time2trnd	OTOP	trnd	trnd2com_tmplte	Commitment object that fires a trend

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

Index Name	Fields	Additional Information
ind_escal_act2com_tmplte	escal_act2com_tmplte	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY
t0076	title	nonclustered located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
234	com_to_template_view	com_tmplte, employee, time_bomb
288	rule_conds	com_tmplte, rule_cond

My Recent Objects

com_tmplte

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user