Table Name:time_bomb
Table Number:77
Group:Policy Mgr
Description:Escalation object used to define the escalation criteria for cases, subcases, solutions, part requests and change requests. Also used for running reports
Flags:CACHEOBJIDS 
Baseline/Custom:Baseline
Fields:
Field NameCommon TypeDatabase TypeGeneric Field IDArray SizeDefaultFlagsCommentField Used in Views
creation_timeCLK_TIMEdatetime46  ALLOW_NULL Creation date/time of the time_bomb  
devLONGint151 DIRECT, ALLOW_NULL Row version number for mobile distribution purposes  
end_timeCLK_TIMEdatetime    For reports, the time that a regularly-scheduled report or a report run at fixed intervals should cease running. For Business Rules, the time the triggering event (e.g., dispatch, create, log email) occurred  
escalate_timeCLK_TIMEdatetime    When the time bomb will be evaluated by rule manager for firing. If time is in the past, evaluation will still occur. If in the future, evaluation will not occur Search (1)
flagsLONGint   DIRECT Identifies type of time bomb; e.g., non-rule, rule, rule scheduling, message. For rule scheduling time bombs, also identifies the original event type that will trigger it  
focus_lowidLONGint   DIRECT Objid of the focus object referenced by the time bomb. Any object can be the focus of a time bomb. See focus_type Search (1)
focus_typeLONGint   DIRECT Object type ID (e.g., case=0, probdesc=1) of the time bomb's focus object. The combination of focus_type and focus_lowid fully identify the time bomb's focus object Search (1)
left_repeatLONGint   DIRECT Describes the number of times remaining to fire a repeating time bomb  
objidLONGint3  DIRECT Internal record number Search (1)
property_setCHARvarchar 80  For report time bombs, the properties of the report  
report_titleCHARvarchar 80  For report time bombs, the title of the report  
suppl_infoCHARtext   ALLOW_NULL Used to supply a text to a com_tmplte action for reports. Not applicable for business rules Search (1)
time_periodLONGint   DIRECT For non-rule time bombs, objid of the act_entry object associated with the time bomb creation event. For rule time bombs that are repeating, the time in seconds between firings. See left_repeat  
titleCHARvarchar240  Title of the time bomb. For Business Rule time bombs, this is normally the same title as the business rule action for the time bomb Search (1)
usersCHARvarchar 30  For report time bombs, the user that initiated the report instance  
Relations:
RelationTypeTarget ObjectInverse RelationCommentFlagsMTM TableUsed in Views
trckr_info2com_tmplteMTOcom_tmplteescal_msg2time_bombRelation to rule action or parent template   Search (1)
rule2com_tmplteMTOcom_tmplteorigin2time_bombRelated top-level business rule. Used only for rule time bombs    
cmit_creator2employeeMTOemployeeemp_cmits2time_bombEmployee whose event triggered the time bomb   Search (1)
recipient2employeeMTMemployeerecipient2time_bombReserved; not used  mtm_employee13_
time_bomb2
 
time_bomb2paramMTOrpt_paramparam2time_bombRelated report time and scheduling options. Used only for report time bombs    
parameters2variableMTMvariableparent2time_bombReserved; future  mtm_time_bomb3_
variable0
 
Indexes: (Defined in Clarify Schema)
Index NameFieldsFlags
Indexes (Defined in Database):
Index NameFieldsAdditional Information
ft0077focus_type, focus_lowid, titlenonclustered located on PRIMARY
ind_escalate_timeescalate_timenonclustered located on PRIMARY
ind_focus_lowidfocus_lowidnonclustered located on PRIMARY
objindexobjidclustered, unique located on PRIMARY
Referenced in Views:
View IDView NameTables
234com_to_template_view com_tmplte, employee, time_bomb
My Recent Objects
time_bomb