Table Name:	subcase
Table Number:	24
Group:	Support
Description:	Subcase object which contains info on a task that is being delegated and commitment date for that task
Flags:	CACHEOBJIDS, ALLOW_FLEX
Baseline/Custom:	Baseline

select * from table_subcase

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
behavior	LONG	int	31			DIRECT	Internal field indicating the behavior of the subcase type; i.e., 1=normal, 2=administrative subcase	Search (6)
creation_time	CLK_TIME	datetime	1				The date and time the subcase was created	Search (7)
description	CHAR	text	23			ALLOW_NULL, CHANGE_FIELD, DONT_DISTR_TO_CLIENT, DONT_DISTR_TO_SERVER	Subcase description	Search (3)
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
dist	LONG	int			1	DIRECT	Used by Task mgr for auto-generation preview; i.e., 0=inactive, 1=active, default=1	Search (1)
elapsed_time	LONG	int	6			DIRECT	Elapsed time in seconds	Search (2)
fcs_cc_notify	LONG	int				DIRECT	Reserved; custom
id_number	CHAR	varchar	4	32			Unique ID number for the subcase; consists of case number-#	Search (20)
modify_stmp	CLK_TIME	datetime	48			CHANGE_DATE	The date and time when object is saved	Search (1)
objid	LONG	int	3			DIRECT	Internal record number	Search (34)
ownership_stmp	CLK_TIME	datetime	47				The date and time when ownership changes
reopen_flag	LONG	int				DIRECT	Reserved; not used
required_date	CLK_TIME	datetime	43				Date and time task must be completed	Search (7)
sub_type	CHAR	varchar	32	20			Subcase type; general or administrative	Search (9)
title	CHAR	varchar	2	80			Subcase title	Search (13)
warning_time	CLK_TIME	datetime					Date and time of commitment warning	Search (3)
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
subcase_acd2acd_call	OTM	acd_call	acd_call_subcase2subcase	Related ACD calls
aux_subcase2act_entry	OTOP	act_entry	act_xentry2subcase	When a subcase is created there is a subcase-create activity log entry in the parent case. The entry is related to the subcase created
subcase2act_entry	OTM	act_entry	act_entry2subcase	Subcase activity log entries
subcase2case	MTO	case	case2subcase	Parent case			Search (19)
subcase2close_case	OTM	close_case	close_case2subcase	Related subcase closure entry
subcase2cls_factory	OTOF	cls_factory	factory2subcase	Template which uses the subcase for auto generation
subc_gen2cls_factory	MTO	cls_factory	fct_gen2subcase	Template from which the subcase was generated			Search (1)
subc_cmit2commit_log	OTM	commit_log	subc_commit2subcase	Related subcase commitment logs
subc_state2condition	OTOP	condition	subc_conditn2subcase	Subcase condition			Search (18)
subcaseinfo2demand_hdr	OTM	demand_hdr	subcaseinfo2case	Reserved; not used. Use relation from parent case to demand_hdr instead
subcase_onsite2disptchfe	OTM	disptchfe	disptchfe2subcase	FE dispatches for the subcase
subcase_attch2doc_inst	OTM	doc_inst	doc_inst2subcase	Document attachment file instances for the subcase
subc_email2email_log	OTM	email_log	subc_email2subcase	Email logs for the subcase
subc_empl2employee	MTO	employee	creator2subcase	Employee who created the subcase
subcase2escalation	OTM	escalation	subc_escalate2subcase	Reserved; obsolete
subcase2fa_subcase	OTM	fa_subcase	fa_subcase2subcase
subc_info2fcs_detail	OTM	fcs_detail	used_by2subcase	Reserved; custom
subc_info2fcs_header	OTM	fcs_header	req_by2subcase	Reserved; custom
subc_casests2gbst_elm	MTO	gbst_elm	case_status2subcase	Subcase status; defined as a Clarify-defined pop up list associated with each type of condition			Search (10)
subc_priorty2gbst_elm	MTO	gbst_elm	priority2subcase	Subcase priority; defined as a Clarify-defined pop up list			Search (8)
subc_svrity2gbst_elm	MTO	gbst_elm	severity2subcase	Subcase severity; defined as a Clarify-defined pop up list			Search (6)
subcase2job	MTO	job	job2subcase	Job which is tracking the subcase
subc_view2monitor	MTM	monitor	monitor2subcase	Reserved; obsolete		mtm_subcase21_ monitor7
subc_notes2notes_log	OTM	notes_log	subc_notes2subcase	Subcase note logs
subc_onsit2onsite_log	OTM	onsite_log	subc_onsite2subcase	Subcase T&E logs
subc_phcall2phone_log	OTM	phone_log	subc_phone2subcase	Subcase phone logs
subc_prevq2queue	MTO	queue	prevq2subcase	Previous queue; used in temporary accept to record previous queue subcase was in
subc_currq2queue	MTO	queue	currq2subcase	Queue subcase is dispatched to			Search (7)
subcase2r_rqst	OTM	r_rqst	r_rqst2subcase	Routing requests for the subcase				route_for	source_type	source_lowid
subcase2reject_msg	OTM	reject_msg	reject_reason2subcase	Reason for rejection of subcase
subc_rsrch2resrch_log	OTM	resrch_log	subc_resrch2subcase	Subcase research logs
subc_rip2ripbin	MTO	ripbin	subc_ripbin2subcase	Reserved; obsolete			Search (2)
subcase2scr_run	OTM	scr_run	scr_run2subcase	Script runs initiated by the subcase
subcase2status_chg	OTM	status_chg	subc_stat_chg2subcase	Subcase status changes
subcase2tag	MTM	tag	tag2subcase		USER_DEFINED	mtm_subcase38_ tag1
subcase2topic	OTM	topic	topic2subcase	Related topic for this subcase				interaction_for	focus_type	focus_lowid
subc_orig2user	MTO	user	originator2subcase	User that originated the subcase
subc_owner2user	MTO	user	curr_owner2subcase	User that owns subcase			Search (17)
subc_wip2wipbin	MTO	wipbin	wipbin2subcase	WIPbin that subcase is accepted into			Search (7)

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
subcase_index	id_number	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
ind_aux_subcase2act_entry	aux_subcase2act_entry	nonclustered located on PRIMARY
ind_subc_currq2queue	subc_currq2queue	nonclustered located on PRIMARY
ind_subc_empl2employee	subc_empl2employee	nonclustered located on PRIMARY
ind_subc_orig2user	subc_orig2user	nonclustered located on PRIMARY
ind_subc_owner2user	subc_owner2user, subc_wip2wipbin	nonclustered located on PRIMARY
ind_subc_prevq2queue	subc_prevq2queue	nonclustered located on PRIMARY
ind_subc_priorty2gbst_elm	subc_priorty2gbst_elm	nonclustered located on PRIMARY
ind_subc_svrity2gbst_elm	subc_svrity2gbst_elm	nonclustered located on PRIMARY
ind_subc_wip2wipbin	subc_wip2wipbin	nonclustered located on PRIMARY
ind_subcase_title	title	nonclustered located on PRIMARY
ind_subcase2case	subcase2case	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY
sc2c0024	subc_state2condition, subc_casests2gbst_elm	nonclustered located on PRIMARY
sg2cf0024	subc_gen2cls_factory	nonclustered located on PRIMARY
subcase_index	id_number	nonclustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
39	subcase_al	act_entry, gbst_elm, gbst_lst, subcase, user
57	wipelm_subcase	condition, gbst_elm, site, subcase, user, wipbin
60	queelm_subcase	condition, gbst_elm, queue, site, subcase, user
81	subc_cmitl	commit_log, gbst_elm, subcase, user
121	case2wip_sub	case, condition, subcase, wipbin
160	subcase_view	case, condition, contact, gbst_elm, subcase, user
161	monelm_subcase	condition, gbst_elm, monitor, subcase, user
166	cls_sub_view	case, condition, contact, employee, site, subcase, user, wipbin
168	num_sub_cls	case, condition, subcase
172	ripelm_subcase	ripbin, subcase
175	subcase2cnvlg	act_entry, phone_log, subcase
176	subcase2rsrch	act_entry, resrch_log, subcase
179	case2sub_cls	case, close_case, subcase
182	case2rip_sub	case, ripbin, subcase
190	v_cls_subc	case, condition, contact, site, subcase
248	qry_subcase_view	condition, contact, gbst_elm, site, subcase, user
272	list_subcase	case, condition, gbst_elm, subcase, user
279	list_sub_dfe	disptchfe, subcase
360	onsite_sub_lst	onsite_log, subcase
368	subc_attch	doc_inst, doc_path, subcase
378	subc_lst	condition, contact, subcase, user
380	subc_cmit	commit_log, contact, subcase, user
392	subcase_queued_dfe	condition, disptchfe, queue, subcase, user
394	dfe_subcase_user	disptchfe, queue, subcase, user, wipbin
4651	fc_user_subcase_view	case, condition, contact, employee, gbst_elm, queue, site, subcase, user, wipbin
4664	tagged_subcases	condition, subcase, tag, user
5047	sub_preview	cls_factory, gbst_elm, subcase, 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
5234	subc2oltsk	contact, gbst_elm, subcase, user
5364	subc_alst	act_entry, case, gbst_elm, gbst_lst, subcase, user
5679	subcase_list	case, condition, gbst_elm, subcase, user
5741	subcase_overview	case, condition, contact, gbst_elm, queue, subcase, user, wipbin
5988	subc_cmit2	commit_log, contact, subcase, user
6019	schdl_tracker_sub_v3	address, disptchfe, employee, hgsl2hgse, queue, site, subcase, user, wipbin
6051	onsite_dfe_subc	disptchfe, onsite_log, subcase
6052	v_cls_subc2	contact, site, subcase

My Recent Objects

subcase

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