View Name:	list_subcase
View Number:	272
Group:	Support
Description:	Site for which the report was run. Used by form Select Subcases (433)
Flags:	VIEW_OPTIMIZED
Baseline/Custom:	Baseline

View Field Name	Table Name	Field Name	Comment	Generic Field Id
case_objid	case	objid	Case internal record number
elm_objid	subcase	objid	Subcase internal record number	3 (UNIQUE)
clarify_state	condition	condition	Code number for condition type	8
user_objid	user	objid	User internal record number
behavior	subcase	behavior	Internal field indicating the behavior of the subcase type; i.e., 1=normal, 2=administrative subcase	31
id_number	subcase	id_number	Unique ID number for the subcase; consists of case number-#	4
owner	user	login_name	User login name
condition	condition	title	Title of condition	7
status	gbst_elm	title	Reserved; not used	17
title	subcase	title	Subcase title	2
sub_type	subcase	sub_type	Subcase type; general or administrative	32

Join From	Join To
(subcase).subcase2case	(case).case2subcase
(subcase).subc_owner2user	(user).curr_owner2subcase
(subcase).subc_state2condition	(condition).subc_conditn2subcase
(subcase).subc_casests2gbst_elm	(gbst_elm).case_status2subcase

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