View Name:	contact_subscription
View Number:	5821
Group:	Morder
Description:	Used to get all the subscription(site_part) that belong to the contact. Used in assigned_services.jsp page
Flags:	VIEW_OPTIMIZED
Baseline/Custom:	Baseline

View Field Name	Table Name	Field Name	Comment	Generic Field Id
rol_objid	con_sp_role	objid	Con_sp_role internal record number	3 (UNIQUE)
sp_objid	site_part	objid	Site_part internal record number
status	site_part	part_status	Site Configuration installed part status. This is a user-defined popup with default name PART_STATUS
instance_name	site_part	instance_name	Default is the concatination of part name, part number, and part revision. May be customized
contact_objid	contact	objid	Contact internal record number
first_name	contact	first_name	Contact's first name
last_name	contact	last_name	Contact's last name
role_name	con_sp_role	role_name	Name of the role
level_to_part	site_part	level_to_part	Relative installation hierarchy level to a part
serial_no	site_part	serial_no	Installed part serial number
quantity	site_part	quantity	Relative installation hierarchy level to a part

Join From	Join To
(con_sp_role).con_sp_role2site_part	(site_part).site_part2con_sp_role
(con_sp_role).con_sp_role2contact	(contact).contact2con_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