Table Name:	site_part
Table Number:	15
Group:	Product Mgr
Description:	Defines an instance of an installed part to the system. See part_inst for instances of inventory parts
Flags:	CACHEOBJIDS, ALLOW_FLEX
Baseline/Custom:	Baseline

select * from table_site_part

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
bin_objid	LONG	int				DIRECT	Productbin internal object number	Search (2)
cmmtmnt_end_dt	CLK_TIME	datetime				ALLOW_NULL	Installed part's service commitment end date
comments	CHAR	varchar		255			Installed part comment	Search (1)
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes	Search (2)
dir_site_objid	LONG	int				DIRECT	Site at which the part is installed. Derived from all_site_part2site. Not applicable to parts installed at more than one site	Search (4)
inst_objid	LONG	int				DIRECT	Objid of parent-installed part in the part's BOM	Search (7)
install_date	CLK_TIME	datetime					Part installation date	Search (3)
instance_id	CHAR	varchar		30		ALLOW_NULL	Installed part unique instance id	Search (3)
instance_name	CHAR	varchar	2	80			Default is the concatination of part name, part number, and part revision. May be customized	Search (24)
invoice_no	CHAR	varchar		30			Installed part invoice number	Search (12)
level_to_bin	LONG	int				DIRECT	Relative level to a bin	Search (3)
level_to_part	LONG	int				DIRECT	Relative installation hierarchy level to a part	Search (8)
machine_id	CHAR	varchar		80			Parent site_part machine ID. Used for SMS compare
mdbk	CHAR	varchar	25	80			Reserved; not used
modified	LONG	int				DIRECT	Reserved; not used
objid	LONG	int	3			DIRECT	Internal record number	Search (46)
part_status	CHAR	varchar		40			Site Configuration installed part status. This is a user-defined popup with default name PART_STATUS	Search (8)
quantity	LONG	int				DIRECT	Installed part quantity; equal to 1 for serialized parts	Search (9)
selected_prd	CHAR	varchar		5			Selected product	Search (3)
serial_no	CHAR	varchar		30			Installed part serial number	Search (30)
service_end_dt	CLK_TIME	datetime					Last day part was/will be in service
ship_date	CLK_TIME	datetime					Installed part ship date	Search (1)
site_objid	LONG	int				DIRECT	Site objid	Search (4)
site_part_ind	LONG	int				DIRECT, ALLOW_NULL	Used for read-only installed part	Search (2)
state_code	LONG	int	26			DIRECT	Reserved; not used
state_value	CHAR	varchar	27	20			Reserved; not used
status_dt	CLK_TIME	datetime				ALLOW_NULL	Date on which subscriber status changed	Search (1)
warranty_date	CLK_TIME	datetime					Installed part warranty end date	Search (9)

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	MTM Table	Used in Views	Set Name	Type ID Stored in	Objid Stored In
							Exclusive Set Relations
site_part2act_entry	OTM	act_entry	act_entry2site_part	Activity entry for installed part; installs, de-installs, etc
site_part2billable_itm	OTM	billable_itm	billable_itm2site_part	Billable item is related to service/subscription (installed part)
site_part2biz_cal_hdr	OTM	biz_cal_hdr	biz_cal_hdr2site_part	Access hours for the part
site_part2bug	OTM	bug	instalatn2site_part	Indicates installed parts selected for change requests. Reserved
selected_prd2bug	OTM	bug	bug_pid2site_part	Problem part in change request. Reserved
part2bus_prt_role	OTM	bus_prt_role	bprt_role2site_part	Business organization roles for the installed part
sitprtnode2case	OTM	case	case_node2site_part	Related cases using the system-level installed part
selected_prd2case	OTM	case	covrd_ppi2site_part	Related cases using the part for service entitlement
sitprtde2case	OTM	case	de_product2site_part	Related cases using the installed part for diagnostics
site_part2case	OTM	case	case_prod2site_part	Related cases for the installed part
site_part2con_sp_role	OTM	con_sp_role	con_sp_role2site_part	Contact role for installed part
site_part2contact	MTM	contact	contact2site_part	Contacts for the installed part	mtm_site_part22_ contact6
site_part2contr_inst	OTM	contr_inst	install_prod2site_part	Related installed products covered by a contract/quote
site_part2contr_itm	OTM	contr_itm	contr_itm2site_part	Contract line item covering this part
dir_sitepart2contract	MTM	contract	contract2dir_sitepart	Contracts covering the top-level installed part in a installed part hierarchy	mtm_site_part24_ contract5
site_part2contract	MTM	contract	contract2site_part	Contracts covering the subordinate installed part in an installed part hierarchy. Valid only for Contract Manager	mtm_site_part4_ contract2
sitprt2demand_dtl	OTM	demand_dtl	demand_dtl2site_part	Part requests related to the installed part
site_part2doc_inst	OTM	doc_inst	doc_inst2site_part	Document attachments related to the installed part
part2e_addr	OTM	e_addr	eaddr2site_part	Electronic addresses for the installed part
site_part2primary	MTO	employee	primary2site_part	Primary employee
site_part2backup	MTO	employee	backup2site_part	Backup employee
site_part2extern_id	OTM	extern_id	extern_id2site_part	Several different entities in the external systems can be mapped to one installed part			extern_for	clarify_type	clarify_objid
site_part2fa_site_part	OTM	fa_site_part	fa_site_part2site_part
site_part2fr_agrmnt	MTO	fr_agrmnt	fr_agrmnt2site_part	Framework agreement covering installed part
site_part2interact	OTM	interact	interact2site_part	Interactions about the installed part
site_part2part_info	MTO	mod_level	part_info2site_part	Part revision of the installed part		Search (14)
site_part2offering	MTO	offering	offering2site_part	The offering that the installed part originated from
site_part2offr_prod	MTO	offr_prod	offr_prod2site_part	Offering product originated installed part
site_part_subs2order_action	OTM	order_action	order_action_subs2site_part	Order actions (subscription) affecting installed part
bus_site_part2order_action	OTM	order_action	order_action_bus2site_part	The orders associated with the top account level product
site_part_svc2order_action	OTM	order_action	order_action_svc2site_part	Order actions (service) affecting installed part
site_part2order_line	MTO	order_line	order_line2site_part	Order line that originated an installed part		Search (1)
affected_order_line2site_part	OTM	order_line	affected2site_part	The orders affecting the site_part
site_part2part_detail	OTOP	part_detail	part_detail2site_part	System management detail for the part
part_key2part_detail	OTOF	part_detail	detail_key2site_part	System management detail for the part; used for index on part_detail
site_part2part_event	OTM	part_event	part_event2site_part	Reported faults on the installed part
inst_site_part2part_used	OTM	part_used	part_used2inst_site_part	Parts used transactions for the installed part
site_part2part_used	OTM	part_used	part_used2site_part	Part install transactions under the current part
rem_site_part2part_used	OTM	part_used	part_used2rem_site_part	Removed part used in parts used transactions
part2per_prt_role	OTM	per_prt_role	pprt_role2site_part	Person roles for the installed part
site_part2phone	OTM	phone	phone2site_part	If a modem is connected to part, this contains the phone information
site_part2productbin	MTO	productbin	productbin2site_part	Bin in which the part resides
role_for2prt_prt_role	OTM	prt_prt_role	role_for2site_part	Roles received from other intalled parts
player2prt_prt_role	OTM	prt_prt_role	player2site_part	Roles played for other intalled parts
site_part2prtkp_set	OTOF	prtkp_set	prtkp_set2site_part	Reserved; not used
site_part2req_to_extern	OTM	req_to_extern	req_to_extern2site_part	Request can be related to a site_part (subscriber)
site_part2schedule	OTM	schedule	schedule2site_part	Schedule record for service interuption data
site_part2scr_run	OTM	scr_run	scr_run2site_part	Call scripts run from the installed part
part2sit_prt_role	OTM	sit_prt_role	prt_role2site_part	Site roles for the installed part
all_site_part2site	MTO	site	site2all_site_part	Indicates the site at which the part is installed		Search (8)
site_part2site	MTO	site	customer2site_part	For top-level parts in a configuration only; indicates the site at which they are located		Search (3)
inc2site_part	OTM	site_part	site_part2site_part	Relation to another installed part as part of part hierarchy; this is the child relation
site_part2site_part	MTO	site_part	inc2site_part	Relation to another installed part as part of part hierarchy; this is the parent relation
top_level2site_part	OTM	site_part	level2site_part	All site_part records in the hierarchy below this top level site_part
level2site_part	MTO	site_part	top_level2site_part	A relation from every site_part to its top level site_part
site_part2site_part_extern	OTM	site_part_extern	site_part_extern2site_part	External system key related to installed part
site_part2sitprt_cf	OTM	sitprt_cf	prd_config2site_part	Reserved; future

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

Index Name	Fields	Additional Information
ii0015	instance_id	nonclustered located on PRIMARY
ind_all_site_part2site	all_site_part2site	nonclustered located on PRIMARY
ind_bin_objid	bin_objid	nonclustered located on PRIMARY
ind_dir_site_objid	dir_site_objid	nonclustered located on PRIMARY
ind_inst_objid	inst_objid	nonclustered located on PRIMARY
ind_instance_name	instance_name	nonclustered located on PRIMARY
ind_level_to_bin	level_to_bin	nonclustered located on PRIMARY
ind_level_to_part	level_to_part	nonclustered located on PRIMARY
ind_serial_no	serial_no	nonclustered located on PRIMARY
ind_service_end_dt	service_end_dt	nonclustered located on PRIMARY
ind_site_objid	site_objid	nonclustered located on PRIMARY
ind_site_part2part_info	site_part2part_info	nonclustered located on PRIMARY
ind_site_part2productbin	site_part2productbin	nonclustered located on PRIMARY
ind_site_part2site_part	site_part2site_part	nonclustered located on PRIMARY
l2sp0015	level2site_part	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY
sp2ol0015	site_part2order_line	nonclustered located on PRIMARY
sp2op0015	site_part2offr_prod	nonclustered located on PRIMARY
sp2s0015	site_part2site	nonclustered located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
105	pinst2pml2shwgrp	mod_level, prtnum_cat, site_part
187	pinst_alst	act_entry, gbst_elm, site_part, user
293	site_svc_appt	appointment, gbst_elm, schedule, site, site_part
304	addrsitepmhpml	address, mod_level, part_num, site, site_part
307	prtused_view	mod_level, part_num, part_used, site_part
308	prtuse1_view	mod_level, part_num, part_used, site_part
309	prtuse2_view	mod_level, part_num, part_used, site_part
337	scm_view	mod_level, part_num, site_part
4618	fc_site_part_view	bus_org, bus_site_role, mod_level, part_num, site, site_part
5063	contr_sp_chk	condition, contr_itm, contr_schedule, contract, mod_level, site, site_part
5065	contract_itm_lst	contr_itm, contr_schedule, mod_level, part_num, price_inst, purchase_ord, site, site_part
5097	c_install_part	mod_level, part_num, site, site_part
5100	svc_part_view	mod_level, part_num, sit_prt_role, site, site_part
5143	sp_role_sp	address, mod_level, part_num, prt_prt_role, site, site_part
5183	prod_svc_itm	condition, contr_itm, contr_schedule, contract, site_part
5196	pd_amt_line	contr_itm, mod_level, part_num, period_amt, site_part
5217	ccc_rundsply	bug, bus_org, campaign, case, contact, contr_itm, contract, demand_dtl, employee, lead_source, opportunity, probdesc, scr_run, site, site_part, subcase, task
5221	sitepartcase	case, condition, contact, gbst_elm, site_part
5222	servicecase	case, condition, contact, gbst_elm, prt_prt_role, site_part
5223	prodcase	case, condition, contact, gbst_elm, prt_prt_role, site_part
5298	spart_site_srole	sit_prt_role, site, site_part
5462	wap_case_info	address, case, condition, contact, contract, employee, gbst_elm, queue, site, site_part, user, wipbin
5651	svc_part_view2	mod_level, part_num, site, site_part
5652	addrsitepmhpml2	mod_level, part_num, site, site_part
5715	vw_con_site_part	con_sp_role, contact, site_part
5734	vw_addrsitepmhpml	address, mod_level, part_num, site, site_part
5735	scm_vw	mod_level, part_num, site_part
5738	sp_rol_site_rol_contact	con_sp_role, contact, contact_role, site, site_part
5739	case_overview	address, case, condition, contact, contact_role, contract, country, gbst_elm, mod_level, queue, site, site_part, user, workaround
5744	sitepart_prodbin_vw	productbin, site_part, site_part_extern
5745	sitepart_address_vw	address, site, site_part, site_part_extern
5750	installed_all_view	site_part
5789	related_contacts_v	con_sp_role, contact, site_part
5797	related_services_v	part_num, prt_prt_role, site_part
5798	sp_order_line_actions_v	contract, order_action, order_line, site_part
5801	sp_order_actions_v	contract, order_action, site_part
5819	ba_bi_role_view	ba_bi_role, billable_itm, blg_argmnt, bus_org, site_part
5821	contact_subscription	con_sp_role, contact, site_part
5870	con_sp_role_view	con_sp_role, contact, site_part
5871	sp_bus_con_view	bus_org, con_sp_role, contact, site_part
6027	prtuse_view1	mod_level, part_num, part_used, site_part, user
6028	prtuse_view2	mod_level, part_used, site_part, user
6030	cont_subs_for_sim	bus_org, bus_site_role, con_sp_role, contact, site_part
6031	sp_orders_v	bus_org, condition, contact, contract, gbst_elm, order_action, order_line, site_part
6048	bus_org_subscription	bus_org, bus_prt_role, site_part
6066	contr_itm_lst_vw	contr_itm, contr_schedule, contract, currency, mod_level, part_num, price_inst, purchase_ord, site, site_part
9880	oa_prt_prt_view	mod_level, part_num, prt_prt_role, site_part
9881	svc_role_svc_view	mod_level, part_num, prt_prt_role, site_part

My Recent Objects

site_part

Quick Links

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