Table Name:	group_inst
Table Number:	9757
Group:	Process Manager
Description:	Contains one instance for each function group that has been executed
Flags:	CACHEOBJIDS, ALLOW_FLEX
Baseline/Custom:	Baseline

select * from table_group_inst

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
client_id	CHAR	varchar		64		ALLOW_NULL	Foreground group:Unique identifier of the last client to make a request	Search (1)
client_session_id	CHAR	varchar		128		ALLOW_NULL	Foreground group:Unique identifier of the last client to make a request	Search (1)
cond_val	CHAR	varchar		255			Conditional expression for conditional group	Search (2)
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes	Search (1)
end_time	CLK_TIME	datetime					Date and time the function was completed	Search (4)
err_code	CHAR	varchar		30			Error Code	Search (3)
err_info	CHAR	varchar		128			Additional info for an error	Search (3)
err_mess	CHAR	varchar		255			Error message text	Search (3)
err_type	CHAR	varchar		30			Type of error eg USER, SYSTEM	Search (3)
error_status	CHAR	varchar		30			Status of an error group (Active, Fallout, Resumed)	Search (3)
focus_lowid	LONG	int				DIRECT	Objid of the focus object	Search (5)
focus_object	CHAR	varchar		64			Focus object as text (focus_type is less useful!)	Search (2)
focus_type	LONG	int				DIRECT	Focus object for group	Search (3)
id	CHAR	varchar		80		ALLOW_NULL	Group instance ID	Search (5)
is_detached	LONG	tinyint				DIRECT, ALLOW_NULL	Set to 1 if the group is running detached	Search (1)
is_foreground_complete	LONG	tinyint				DIRECT, ALLOW_NULL	Set to 1 if the process is complete in the foreground, but still has (detached) groups active in the background	Search (1)
iter_instance_count	LONG	int				DIRECT	Number of concurrent iteration instances	Search (5)
iter_seqno	LONG	int				DIRECT	Sequence number of this iteration instance	Search (7)
last_client_rqst_time	CLK_TIME	datetime				ALLOW_NULL	Foreground group: Date and time of the most recent client request	Search (1)
no_functions	LONG	int				DIRECT	Number of active paralled functions	Search (2)
num_detached	LONG	int				DIRECT, ALLOW_NULL	The number of detached background groups still active for this (foreground) process	Search (1)
objid	LONG	int	3			DIRECT	Internal record number	Search (17)
resume_focus_lowid	LONG	int				DIRECT	Resume focus lowid for error group	Search (3)
resume_focus_type	LONG	int				DIRECT	Resume focus type for error group	Search (3)
seqno	LONG	int				DIRECT	Sequence number of current serial function	Search (3)
stall_check_time	CLK_TIME	datetime				ALLOW_NULL	Date and time for stall detection.	Search (1)
start_time	CLK_TIME	datetime					Date and time the function was executed	Search (4)
status	CHAR	varchar		30			Active, Complete, Suspended	Search (10)
status_code	LONG	int				DIRECT	Status code	Search (2)
step_seqno	LONG	int				DIRECT, ALLOW_NULL	Sequence number of execution in an associative group	Search (1)

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Used in Views
group_inst2context_inst	OTM	context_inst	context_inst2group_inst	Context instances for the group
group_inst2fa_group_inst	OTM	fa_group_inst	fa_group_inst2group_inst
group2func_group	MTO	func_group	inst2group_inst	Generic function group for this instance	Search (12)
group2function	MTO	function	function2group_inst	Function for this group instance	Search (3)
child2group_inst	MTO	group_inst	parent2group_inst	Parent group instance for subgroup instances	Search (8)
parent2group_inst	OTM	group_inst	child2group_inst	Children of this group instance
context_owner2group_inst	MTO	group_inst	owner_context2group_inst	The context_inst owned by group instance	Search (1)
owner_context2group_inst	OTM	group_inst	context_owner2group_inst	Group instances using this one for their context_inst
topmost_foreground2group_inst	MTO	group_inst	foreground_topmost2group_inst	The topmost foreground group instance above this one in the tree	Search (1)
foreground_topmost2group_inst	OTM	group_inst	topmost_foreground2group_inst	The group instances having this one as their topmost foreground group instance
group_inst2proc_fc_item	OTOF	proc_fc_item	fc_item2group_inst	Forecast related to this group instance
all_group_inst2proc_inst	MTO	proc_inst	proc_inst2all_group_inst	Process instance owning the group	Search (2)
group2proc_inst	MTO	proc_inst	proc2group_inst	Process instance for the top level function group instance	Search (3)
group2rqst_inst	OTM	rqst_inst	rqst_inst2group_inst	Request instances for the function group instance

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

Index Name	Fields	Additional Information
agi2pi9757	all_group_inst2proc_inst	nonclustered located on PRIMARY
c2gi9757	child2group_inst	nonclustered located on PRIMARY
co2gi9757	context_owner2group_inst	nonclustered located on PRIMARY
g2f9757	group2function	nonclustered located on PRIMARY
g2fg9757	group2func_group	nonclustered located on PRIMARY
g2pi9757	group2proc_inst	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY
s9757	status	nonclustered located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
9850	group_inst_view	func_group, group_inst, proc_inst, process
9851	svc_rqst_inst_view	func_group, function, group_inst, rqst_inst
9854	groupinst_node_view	func_group, function, group_inst
9855	rqstinst_node_view	func_group, function, group_inst, rqst_inst, svc_rqst
9856	procinst_node_view	func_group, function, group_inst, process
9857	select_proc_inst	group_inst, proc_inst, process
9863	process_rqst_view	func_group, function, group_inst, rqst_inst, svc_rqst
9865	process_funcgroup_view	func_group, group_inst
9866	process_exec_grp_view	func_group, function, group_inst
9867	process_canc_grp_view	func_group, function, group_inst
9869	top_level_node_view	func_group, group_inst, proc_inst
9872	process_error_view	func_group, function, group_inst
9896	procinst_group_view	context_inst, func_group, function, group_inst, proc_inst, process
9897	procinst_action_view	function, group_inst, proc_inst, process, rqst_inst, svc_rqst
9898	procinst_param_view	fld_inst, function, group_inst, proc_inst, rqst_inst, svc_fld
9901	rqst_inst_rcvry_view	group_inst, proc_inst, process, rqst_inst
9902	process_grp_view	func_group, function, group_inst
9903	stall_leaf_node_view	group_inst, proc_inst, process, rqst_inst, svc_rqst

My Recent Objects

group_inst

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