Table Name:	bug
Table Number:	192
Group:	Quality
Description:	Main change request object
Flags:	CACHEOBJIDS
Baseline/Custom:	Baseline

select * from table_bug

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
attribute1	CHAR	varchar		40			Used to store CR Class information. This is a user-defined pop up with default name CR_CLASS
attribute2	CHAR	varchar		30			Reserved; not used
attribute3	CHAR	varchar		30			Reserved; not used
attribute4	CHAR	varchar		30			Reserved; not used
attribute5	CHAR	varchar		30			Reserved; not used
attribute6	CHAR	varchar		30			Reserved; not used
attribute7	CHAR	varchar		30			Reserved; not used
attribute8	CHAR	varchar		30			Reserved; not used
cclist1	CHAR	varchar	44	255			Recipient on carbon copy list #1
cclist2	CHAR	varchar	45	255			Recipient on carbon copy list #2
cpu	CHAR	varchar		40			CPU the CR was found on. This is from a level of a hierarchical user-defined pop up list with default name CR_DESC and level name CPU
creation_time	CLK_TIME	datetime	1				Creation date/time of the change request	Search (4)
date_found	CLK_TIME	datetime					Creation_time of the case if the CR was created from a solution for a case
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
dist	LONG	int				DIRECT	Reserved; not used
fixed_date	CLK_TIME	datetime					Reserved; not used. Use act_entry for the CR's fixed or closed event instead
history	CHAR	text	23			ALLOW_NULL	History text field for the change request
id_number	CHAR	varchar	4	32			Change request number; generated via auto-numbering	Search (15)
initial_desc	CHAR	varchar		255			Reserved; not used
memory	CHAR	varchar		40			Memory in the system the CR was found on. This is from a level of a hierarchical user-defined pop up list with default name CR_DESC and level name Memory
modify_stmp	CLK_TIME	datetime	48				The date and time when object is saved
objid	LONG	int	3			DIRECT	Internal record number	Search (19)
os	CHAR	varchar		40			Operating System the CR was found on. This is from a level of a hierarchical user-defined pop up list with default name CR_DESC and level name OS
ownership_stmp	CLK_TIME	datetime	47				The date and time when ownership changes
release_rev	CHAR	varchar		40			Fixed in release version. A user-defined pop up list with default name FIX RELEASE	Search (6)
title	CHAR	varchar	2	80			Title of the change request	Search (7)
ttest_name	CHAR	varchar		80			Name of test that is to be used to verify the CR
yank_flag	LONG	int				DIRECT	Reserved; not used

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views	Set Name	Type ID Stored in	Objid Stored In
								Exclusive Set Relations
bug2act_entry	OTM	act_entry	act_entry2bug	Activity log entries for the CR
duplicate_parent2bug	OTM	bug	duplicate_bug2bug	CR is parent to duplicate CRs
duplicate_bug2bug	MTO	bug	duplicate_parent2bug	Relation from the duplicate CR to its parent CR			Search (2)
cr_replicate2cr_master	MTO	bug	cr_master2cr_replicate	Relation from replicate CR to its parent CR			Search (2)
cr_master2cr_replicate	OTM	bug	cr_replicate2cr_master	CR that were replicated from the CR
cr_replicate2cr_root	MTO	bug	cr_root2cr_replicate	Related top-level-ancestor in a chain of replicated CRs
cr_root2cr_replicate	OTM	bug	cr_replicate2cr_root	Related replicated CRs decending from the root CR
role_for2bug_bug_role	OTM	bug_bug_role	role_for2bug	Bug receiving the role
player2bug_bug_role	OTM	bug_bug_role	player2bug	Bug playing the role
bug2bug_module	OTM	bug_module	bug_module2bug	Source modules checked out for the CR
bug_cmit2commit_log	OTM	commit_log	bug_commit2bug	Reserved; not used
bug_condit2condition	OTOP	condition	bug_condition2bug	Condition of CR; e.g., open, closed, etc			Search (15)
bug_attach2doc_inst	OTM	doc_inst	doc_inst2bug	Documents attached to the CR
bug_email2email_log	OTM	email_log	bug_email2bug	Related email logs
bug_cc_list2employee	OTM	employee	cc_list2bug	Employees copied on the change request. Reserved; obsolete. See fields cclist1 and cclist2 above
bug_escal2escalation	OTM	escalation	bug_escalate2bug	Reserved; obsolete
bug_type2gbst_elm	MTO	gbst_elm	bug_type2bug	Relation to pop up list for CR type			Search (3)
bug_priority2gbst_elm	MTO	gbst_elm	priority2bug	Relation to pop up list for CR priority			Search (4)
bug_sevrity2gbst_elm	MTO	gbst_elm	severity2bug	Relation to pop up list for CR reproducibility
bug_sts2gbst_elm	MTO	gbst_elm	status2bug	Relation to pop up list for CR type. (See bug.attribute1 for CR status)			Search (12)
bug_domain2gbst_elm	MTO	gbst_elm	domain2bug	Relation to pop up list for CR intro phase
bug_class2gbst_elm	MTO	gbst_elm	class2bug	Relation to pop up list for CR class
bug_product2part_info	MTO	mod_level	part_info2bug	Part revision of part selected for CR			Search (5)
bug_view2monitor	MTM	monitor	monitor2bug	Reserved; obsolete		mtm_monitor9_ bug20	Search (2)
bug_notes2notes_log	OTM	notes_log	bug_notes2bug	Notes log entries for the CR
bug_desc2notes_log	OTOP	notes_log	notes_log2bug_desc	CR description is stored in a notes log
bug2probdesc	MTM	probdesc	probdesc2bug	Relation to solutions that address the CR		mtm_probdesc12_ bug28	Search (2)
bug_currq2queue	MTO	queue	queue2bug	Queue to which the CR has been dispatched			Search (1)
bug_prevq2queue	MTO	queue	prevq2bug	Queue to which the CR was previously dispatched
bug2r_rqst	OTM	r_rqst	r_rqst2bug	Routing requests for the CR				route_for	source_type	source_lowid
bg_rej_rsn2reject_msg	OTM	reject_msg	reject_reason2bug	Reject messages for a CR that has been rejected
bug_rip2ripbin	MTO	ripbin	bug_ripbin2bug	Reserved; obsolete			Search (1)
bug2scr_run	OTM	scr_run	scr_run2bug	Script runs initiated by the CR
bug_reporter2site	OTM	site	report_site2bug	Reserved; not used
instalatn2site_part	MTO	site_part	site_part2bug	Reserved; not used
bug_pid2site_part	MTO	site_part	selected_prd2bug	Reserved; not used
bg_statchg2status_chg	OTM	status_chg	status_chg2bug	Status change entries for the CR
bug2tag	MTM	tag	tag2bug		USER_DEFINED	mtm_bug40_ tag5
bug_originator2user	MTO	user	originator2bug	User that created the CR
bug_owner2user	MTO	user	owner2bug	User that currently owns the CR			Search (9)
bug_wip2wipbin	MTO	wipbin	wipbin2bug	WIPbin into which the CR has been accepted			Search (1)

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
bug_index	id_number	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
bc2c0192	bug_condit2condition, bug_sts2gbst_elm	nonclustered located on PRIMARY
bc2q0192	bug_currq2queue, objid	nonclustered, unique located on PRIMARY
bug_index	id_number	nonclustered, unique located on PRIMARY
ind_bug_creation_time	creation_time	nonclustered located on PRIMARY
ind_bug_owner2user	bug_owner2user, bug_wip2wipbin	nonclustered located on PRIMARY
ind_bug_product2part_info	bug_product2part_info	nonclustered located on PRIMARY
ind_bug_wip2wipbin	bug_wip2wipbin, objid	nonclustered, unique located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
195	wipelm_bug	bug, condition, gbst_elm, part_num, wipbin
196	queelm_bug	bug, condition, gbst_elm, part_num, queue
197	ripelm_bug	bug, ripbin
198	bug_view	bug, condition, gbst_elm, user
199	monelm_bug	bug, condition, gbst_elm, monitor, user
207	bug_alst	act_entry, bug, gbst_elm, user
209	qry_bug_view	bug, condition, gbst_elm, part_num, user
215	qry_bug	bug, condition, gbst_elm, part_num, user
247	probdesc2bug	bug, condition, gbst_elm, probdesc
295	assoc_bugs	bug, condition, gbst_elm, user
296	master_bug	bug, condition, gbst_elm, user
369	bug_attch	bug, doc_inst, doc_path
398	rep_bugs	bug, condition, gbst_elm, user
4603	assoc_bugs_master	bug, condition, gbst_elm, user
4604	rep_bugs_master	bug, condition, gbst_elm, user
4619	fc_bug_view	bug, bus_org, bus_site_role, case, gbst_elm, mod_level, part_num, probdesc, site, workaround
4678	tagged_crs	bug, condition, tag, user
4679	dt_linked_crs	bug
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

My Recent Objects

bug

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