| View Name: | alert2objects |
| View Number: | 106 |
| Group: | Customer Mgr |
| Description: | Joins alerts with the alerted objects. Used by Select Flashes TAB (Form 8511) and many tabs |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
(double-click a column header to select column text)
View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| active | alert | active | Indicates whether alert is active; i.e., 0=inactive, 1=active. In order to fire, an alert must be both effective and active | |
| active_str | alert | title | Title replaced with 'active'/'inactive' indicator | |
| alert_end_date | alert | end_date | Last date the alert is effective | |
| alert_objid | alert | objid | Alert internal record number | 3 (UNIQUE) |
| alert_start_date | alert | start_date | Date the alert becomes effective | |
| alert_text | alert | alert_text | Alert internal record number | |
| alert_title | alert | title | The title of the alert | |
| alert_type | alert | type | The type of alert | |
| contact_objid | contact | objid | Contact internal record number | |
| contract_objid | contract | objid | Contact internal record number | |
| hot | alert | hot | Indicates whether the alert is hot; 1=hot, 0=not hot | |
| hot_str | alert | title | Title replaced with 'yes'/'no' for hot indicator | |
| login_name | user | login_name | User login name | |
| site_objid | site | objid | Site internal record number |
| alert2objects | |||