Table Name:	func_group
Table Number:	9752
Group:	Process Manager
Description:	Contains one instance for each group of functions within a process. The function group gives the process its structure
Flags:
Baseline/Custom:	Baseline

select * from table_func_group

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
checkpoint_mode	LONG	int				DIRECT, ALLOW_NULL	0 = Automatic, 1 = Manual	Search (2)
cond_attrib_name	CHAR	varchar		64			Condition path target attribute name	Search (2)
cond_attrib_type	LONG	int				DIRECT	Attribute type, one of String, Number, Date	Search (2)
cond_filter_list	CHAR	varchar		255			Condition reverse path filter list	Search (2)
cond_focus	LONG	int				DIRECT	0 = Current focus object, 1 = current group_inst	Search (5)
cond_is_flexible	LONG	int				DIRECT	0 = attribute is fixed, 1 = attribute is flexible	Search (2)
cond_path	CHAR	varchar		255			Conditional expression	Search (9)
cond_rev_path	CHAR	varchar		255			Condition reverse path	Search (2)
cond_sqlfrom	CHAR	varchar		255			FROM clause for conditional value SQL statement	Search (2)
cond_sqlwhere	CHAR	varchar		255			WHERE clause for conditional value SQL statement	Search (2)
cond_target_id	LONG	int				DIRECT	Condition path target type ID	Search (2)
cond_target_name	CHAR	varchar		64			Condition path target object name	Search (2)
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
exec_type	LONG	int				DIRECT, ALLOW_NULL	0 = Default, 1 = foreground, 2 = detached	Search (2)
id	CHAR	varchar		80			Function Group ID	Search (11)
is_milestone	LONG	int				DIRECT, ALLOW_NULL	0 = No, 1 = Completion of this group is a milestone in the process	Search (5)
iter	LONG	int				DIRECT	Type of iteration 0=Not iterative, 1=iterative, 2=iterative sequential	Search (12)
iter_expected	LONG	int				DIRECT, ALLOW_NULL	Expected iteration count for forecasting sequential iteration	Search (5)
iter_filter_list	CHAR	varchar		255			Iteration reverse path filter list
iter_focus	LONG	int				DIRECT	0 = Current focus object, 1 = current group_inst	Search (4)
iter_order	CHAR	varchar		255			Colon separated list of fields to order the iteration for sequential processing	Search (3)
iter_path	CHAR	varchar		255			Iteration path	Search (4)
iter_rev_path	CHAR	varchar		255			Iteration reverse path	Search (2)
iter_sqlfrom	CHAR	varchar		255			FROM clause for iterative path SQL statement	Search (2)
iter_sqlwhere	CHAR	varchar		255			WHERE clause for iterative path SQL statement	Search (2)
iter_target_id	LONG	int				DIRECT	Iteration path target type ID	Search (1)
iter_target_name	CHAR	varchar		64			Iteration path target object name	Search (3)
iterated_item	CHAR	varchar		255		ALLOW_NULL	For non-database iteration, defines the location of the iterated item within each iterated occurrence of the group	Search (1)
objid	LONG	int	3			DIRECT	Internal record number	Search (22)
type	LONG	int				DIRECT	Type of Group 1=Serial, 2=Parallel, 3=Conditional	Search (14)

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Used in Views
func_group2cdo_context	OTM	cdo_context	cdo_context2func_group	CDO context for a foreground group
contains2function	OTM	function	belongs2func_group	The functions contained in this group. This is the parent or owning relation
func_group2function	OTM	function	function2func_group	A sub-group within a function group. this is the child or member of reation
inst2group_inst	OTM	group_inst	group2func_group	Instance of this generic group. Created when the owning process is executed and this group is initiated
func_group2proc_fc_item	OTM	proc_fc_item	fc_item2func_group	Forecasts related to this group
func_group2process	OTOP	process	process2func_group	Only the top level function group in a process will have this relation set	Search (4)

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

Index Name	Fields	Additional Information
fg2p9752	func_group2process	nonclustered located on PRIMARY
objindex	objid	clustered, unique 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
9853	process_function_view	func_group, function, process, svc_rqst
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
9858	process_node_view	func_group, function, process, svc_rqst
9860	func_cond_val_fld	func_group, function
9861	group_cond_exp_fld	func_group
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
9875	dummy_svcrqst_view	func_group, function, svc_rqst
9885	fc_group_view	func_group, function, proc_fc_item, proc_forecast, proc_inst
9886	fc_rqst_view	func_group, function, proc_fc_item, proc_forecast, proc_inst, svc_rqst
9887	fc_subproc_view	func_group, function, proc_fc_item, proc_forecast, proc_inst, process
9893	procdef_view	func_group, process
9894	procdef_node_view	func_group, function, process, svc_rqst
9896	procinst_group_view	context_inst, func_group, function, group_inst, proc_inst, process
9902	process_grp_view	func_group, function, group_inst

My Recent Objects

func_group

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