Table Name:	probdesc
Table Number:	1
Group:	Support
Description:	Solution object: Description of known solutions
Flags:	CACHEOBJIDS
Baseline/Custom:	Baseline

select * from table_probdesc

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
creation_time	CLK_TIME	datetime	1				Date and time the solution was created	Search (5)
description	CHAR	text				ALLOW_NULL	Full description of the solution
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
dist	LONG	int				DIRECT	Reserved; not used
end_gates	ARRAY		1	0		DIRECT, BINARY	Associated binary array object	Search (17)
hits	LONG	int				DIRECT	Number of times the solution has been linked to a case	Search (2)
id_number	CHAR	varchar	4	32			Unique ID number for the solution; assigned according to auto-numbering definition	Search (11)
modify_stmp	CLK_TIME	datetime	48				The date and time when object is saved	Search (1)
objid	LONG	int	3			DIRECT	Internal record number	Search (17)
ownership_stmp	CLK_TIME	datetime	47				The date and time when ownership changes
public_ind	LONG	smallint			0	DIRECT	Indicates whether the solution is available for public view (i.e., 0=no, 1=yes, default=0) and via which method (e.g., WebBrowser)
rating	LONG	int				DIRECT	Solution rating	Search (4)
solns	LONG	int				DIRECT	Number of resolutions for the solution. Reserved; not used
title	CHAR	varchar	2	255			Solution title -describes main details of the solution	Search (9)
x_fc_public_ind	CHAR	varchar		40		USER_DEFINED	Public Solution Indicator for FTS Indexing
x_res1	CHAR	varchar		20		USER_DEFINED	Restriction field	Search (3)
x_res2	CHAR	varchar		20		USER_DEFINED	Restriction field	Search (3)
x_res3	CHAR	varchar		20		USER_DEFINED	Restriction field	Search (3)
x_res4	CHAR	varchar		20		USER_DEFINED	Restriction field	Search (3)
x_res5	CHAR	varchar		20		USER_DEFINED	Restriction field	Search (3)
x_solution_type	CHAR	varchar		120		USER_DEFINED	Solution Type
yank_flag	LONG	int				DIRECT	Indicates whether solution is being modified externally. 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
probdesc2act_entry	OTM	act_entry	act_entry2probdesc	Activity log entries for the solution
probdesc2bug	MTM	bug	bug2probdesc	Change request related to the solution		mtm_probdesc12_ bug28
probdesc2condition	OTOP	condition	condition2probdesc	Condition of the solution			Search (8)
probdesc2contact	MTO	contact	contact2probdesc		USER_DEFINED
probdesc_emp2employee	MTM	employee	creator2probdesc	Employee who added the solution		mtm_probdesc10_ employee6
keywords2keyword_text	OTOF	keyword_text	keywords2probdesc	Keyword text for the solution
probdesc_view2monitor	MTM	monitor	monitor2probdesc	Reserved; obsolete		mtm_probdesc11_ monitor8
probdesc2notes_log	OTM	notes_log	notes_log2probdesc		USER_DEFINED
probdesc2prog_logic	OTM	prog_logic	prog_logic2probdesc	Program logic objects using the solution. Reserved; not used
probdesc_q2queue	MTO	queue	queue2probdesc	Queue the solution is dispatched to			Search (2)
probdesc_prevq2queue	MTO	queue	prevq2probdesc	Immediately prior queue the solution was dispatched to; used in temporary accept feature
probdesc2r_rqst	OTM	r_rqst	r_rqst2probdesc	Routing requests for the description for a known problem				route_for	source_type	source_lowid
probdesc2reject_msg	OTM	reject_msg	rej_reason2probdesc	Reject messages for the solution
probdesc2scr_run	OTM	scr_run	scr_run2probdesc	Call scripts initiated from the solution
probdesc2status_chg	OTM	status_chg	status_chg2probdesc	Status change for the solution
probdesc2tag	MTM	tag	tag2probdesc		USER_DEFINED	mtm_probdesc17_ tag2
probdesc_owner2user	MTO	user	curr_owner2probdesc	Owner of the solution			Search (7)
probdesc_orig2user	MTO	user	originator2probdesc	Originator of the solution
probdesc_wip2wipbin	MTO	wipbin	wipbin2probdesc	Wipbin into which the soluction is accepted			Search (1)
probdesc2workaround	OTM	workaround	workaround2probdesc	Workarounds related to the solution

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
finale_index	id_number	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
finale_index	id_number	nonclustered, unique located on PRIMARY
ind_probdesc_owner2user	probdesc_owner2user	nonclustered located on PRIMARY
ind_probdesc_q2queue	probdesc_q2queue	nonclustered located on PRIMARY
ind_probdesc_title	title	nonclustered located on PRIMARY
ind_probdesc_wip2wipbin	probdesc_wip2wipbin	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY
p2c0001	probdesc2condition	nonclustered located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
34	finale_lst	probdesc, user
38	fnl_alst	act_entry, gbst_elm, probdesc, user
74	scn_finale	probdesc
96	wipelm_fnl	condition, probdesc, wipbin
97	queelm_fnl	condition, probdesc, queue
164	finale_view	probdesc, user
165	monelm_fnl	condition, monitor, probdesc, user
185	rating	probdesc, prog_logic
247	probdesc2bug	bug, condition, gbst_elm, probdesc
311	qry_finale_view	condition, probdesc, user
370	pd_attch	doc_inst, doc_path, probdesc, workaround
373	lgc2pd2class	part_class, probdesc, prog_logic
4619	fc_bug_view	bug, bus_org, bus_site_role, case, gbst_elm, mod_level, part_num, probdesc, site, workaround
4652	fc_user_solution_view	condition, employee, probdesc, queue, user
4665	tagged_solutions	condition, probdesc, tag, user
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
5682	probdesc2case	case, gbst_elm, probdesc, workaround
5689	solution_list	probdesc, user

My Recent Objects

probdesc

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