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 |
(double-click a column header to select column text)
Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
---|---|---|---|---|---|---|---|---|
creation_time | CLK_TIME | datetime | 46 | ALLOW_NULL | Creation date/time of the time_bomb | |||
dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
end_time | CLK_TIME | datetime | 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_time | CLK_TIME | datetime | 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) | ||||
flags | LONG | int | 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_lowid | LONG | int | 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_type | LONG | int | 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_repeat | LONG | int | DIRECT | Describes the number of times remaining to fire a repeating time bomb | ||||
objid | LONG | int | 3 | DIRECT | Internal record number | Search (1) | ||
property_set | CHAR | varchar | 80 | For report time bombs, the properties of the report | ||||
report_title | CHAR | varchar | 80 | For report time bombs, the title of the report | ||||
suppl_info | CHAR | text | ALLOW_NULL | Used to supply a text to a com_tmplte action for reports. Not applicable for business rules | Search (1) | |||
time_period | LONG | int | 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 | ||||
title | CHAR | varchar | 2 | 40 | 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) | ||
users | CHAR | varchar | 30 | For report time bombs, the user that initiated the report instance |
Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
---|---|---|---|---|---|---|---|
trckr_info2com_tmplte | MTO | com_tmplte | escal_msg2time_bomb | Relation to rule action or parent template | Search (1) | ||
rule2com_tmplte | MTO | com_tmplte | origin2time_bomb | Related top-level business rule. Used only for rule time bombs | |||
cmit_creator2employee | MTO | employee | emp_cmits2time_bomb | Employee whose event triggered the time bomb | Search (1) | ||
recipient2employee | MTM | employee | recipient2time_bomb | Reserved; not used | mtm_employee13_ time_bomb2 | ||
time_bomb2param | MTO | rpt_param | param2time_bomb | Related report time and scheduling options. Used only for report time bombs | |||
parameters2variable | MTM | variable | parent2time_bomb | Reserved; future | mtm_time_bomb3_ variable0 |
Index Name | Fields | Flags |
---|
Index Name | Fields | Additional Information |
---|---|---|
ft0077 | focus_type, focus_lowid, title | nonclustered located on PRIMARY |
ind_escalate_time | escalate_time | nonclustered located on PRIMARY |
ind_focus_lowid | focus_lowid | nonclustered located on PRIMARY |
objindex | objid | clustered, unique located on PRIMARY |
View ID | View Name | Tables |
---|---|---|
234 | com_to_template_view | com_tmplte, employee, time_bomb |
time_bomb | |||