Table Name:	trnd
Table Number:	211
Group:	Info Retrieval
Description:	EIS object which defines the characteristics of a trend
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_trnd

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
objid	LONG	int	3			DIRECT	Internal record number
output_fmt	CHAR	varchar		80			Will be used to format trend results data. Reserved; future
status	LONG	int			0	DIRECT	Current run status of the trend: i.e., 0=never has been run, 1=running, 2=stopped
title	CHAR	varchar	2	80			Name of trend

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
trnd2com_tmplte	OTOF	com_tmplte	commit_time2trnd	Business rule which causes the trend to run <trigger>
trnd_1query2query	MTO	query	first_query2trnd	First query used in generating the trend
trnd_2query2query	MTO	query	second_query2trnd	Second query used in generating the trend
trnd_3query2query	MTO	query	third_query2trnd	Third query used in generating the trend
trnd_4query2query	MTO	query	fourth_query2trnd	Fourth query used in generating the trend
trnd_5query2query	MTO	query	fifth_query2trnd	Fifth query used in generating the trend
trnd_6query2query	MTO	query	sixth_query2trnd	Sixth query used in generating the trend
trnd_7query2query	MTO	query	seventh_query2trnd	Seventh query used in generating the trend
trnd_8query2query	MTO	query	eigth_query2trnd	Eighth query used in generating the trend
trnd_9query2query	MTO	query	ninth_query2trnd	Ninth query used in generating the trend
trnd_10query2query	MTO	query	tenth_query2trnd	Tenth query used in generating the trend
trnd_11query2query	MTO	query	eleventh_query2trnd	Eleventh query used in generating the trend
trnd_12query2query	MTO	query	twelfth_query2trnd	Twelfth query used in generating the trend
trnd2trnd_inst	OTM	trnd_inst	trnd_inst2trnd	Related trend execution parameters
trnd2user	MTO	user	user2trnd	Originator/owner of trend

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
title_index	title	UNIQUE

Indexes (Defined in Database):

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

Referenced in Views:

View ID	View Name	Tables

My Recent Objects

trnd

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user