Table Name:trnd
Table Number:211
Group:Info Retrieval
Description:EIS object which defines the characteristics of a trend
Flags: 
Baseline/Custom:Baseline
Fields:
Field NameCommon TypeDatabase TypeGeneric Field IDArray SizeDefaultFlagsCommentField Used in Views
devLONGint151 DIRECT, ALLOW_NULL Row version number for mobile distribution purposes  
objidLONGint3  DIRECT Internal record number  
output_fmtCHARvarchar 80  Will be used to format trend results data. Reserved; future  
statusLONGint  DIRECT Current run status of the trend: i.e., 0=never has been run, 1=running, 2=stopped  
titleCHARvarchar280  Name of trend  
Relations:
RelationTypeTarget ObjectInverse RelationCommentFlagsMTM TableUsed in Views
trnd2com_tmplteOTOFcom_tmpltecommit_time2trndBusiness rule which causes the trend to run <trigger>    
trnd_1query2queryMTOqueryfirst_query2trndFirst query used in generating the trend    
trnd_2query2queryMTOquerysecond_query2trndSecond query used in generating the trend    
trnd_3query2queryMTOquerythird_query2trndThird query used in generating the trend    
trnd_4query2queryMTOqueryfourth_query2trndFourth query used in generating the trend    
trnd_5query2queryMTOqueryfifth_query2trndFifth query used in generating the trend    
trnd_6query2queryMTOquerysixth_query2trndSixth query used in generating the trend    
trnd_7query2queryMTOqueryseventh_query2trndSeventh query used in generating the trend    
trnd_8query2queryMTOqueryeigth_query2trndEighth query used in generating the trend    
trnd_9query2queryMTOqueryninth_query2trndNinth query used in generating the trend    
trnd_10query2queryMTOquerytenth_query2trndTenth query used in generating the trend    
trnd_11query2queryMTOqueryeleventh_query2trndEleventh query used in generating the trend    
trnd_12query2queryMTOquerytwelfth_query2trndTwelfth query used in generating the trend    
trnd2trnd_instOTMtrnd_insttrnd_inst2trndRelated trend execution parameters    
trnd2userMTOuseruser2trndOriginator/owner of trend    
Indexes: (Defined in Clarify Schema)
Index NameFieldsFlags
title_indextitleUNIQUE 
Indexes (Defined in Database):
Index NameFieldsAdditional Information
objindexobjidclustered, unique located on PRIMARY
title_indextitlenonclustered, unique located on PRIMARY
Referenced in Views:
View IDView NameTables
My Recent Objects
trnd