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

View Field Name	Table Name	Field Name	Comment	Generic Field Id
alert_objid	alert	objid	Alert internal record number	3 (UNIQUE)
site_objid	site	objid	Site internal record number
contact_objid	contact	objid	Contact internal record number
contract_objid	contract	objid	Contact internal record number
login_name	user	login_name	User login name
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
alert_text	alert	alert_text	Alert internal record number
alert_end_date	alert	end_date	Last date the alert is effective
alert_start_date	alert	start_date	Date the alert becomes effective
alert_title	alert	title	The title of the alert
alert_type	alert	type	The type of alert
hot	alert	hot	Indicates whether the alert is hot; 1=hot, 0=not hot
active_str	alert	title	Title replaced with 'active'/'inactive' indicator
hot_str	alert	title	Title replaced with 'yes'/'no' for hot indicator

Join From	Join To
(alert).alert2contact	OUTER (contact).contact2alert
(alert).alert2site	OUTER (site).site2alert
(alert).alert2contract	OUTER (contract).contract2alert
(alert).last_update2user	(user).user2alert

act_entry	case	contact	employee
rol_contct	site	site_view	user

alt-s	Execute SQL
alt-t	Execute SQL, getting latest 10 rows
?	Bring up this help dialog