View Name:	con_sp_role_view
View Number:	5870
Group:	Billing Manager
Description:	This view is used in the contacts Tab in subscriber overview
Flags:	VIEW_OPTIMIZED
Baseline/Custom:	Baseline

View Field Name	Table Name	Field Name	Comment	Generic Field Id
role_objid	con_sp_role	objid	Internal record number for con_sp_role	3 (UNIQUE)
role_name	con_sp_role	role_name	Con_sp_role internal record number
sp_objid	site_part	objid	Site_part Internal record number
con_objid	contact	objid	Contact Internal record number
con_first_name	contact	first_name	Contact's first name
con_last_name	contact	last_name	Contact's last name
con_phone	contact	phone	Contact's phone number which includes area code, number, and extension
con_title	contact	title	Contact's professional title
con_e_mail	contact	e_mail	Contact's primary e-mail address

Join From	Join To
(con_sp_role).con_sp_role2contact	(contact).contact2con_sp_role
(con_sp_role).con_sp_role2site_part	(site_part).site_part2con_sp_role

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