| 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 | |||