Table Name:	function
Table Number:	9753
Group:	Process Manager
Description:	Contains one instance for function contained in a function group. Creates the many to many relation between function groups and thier children either sub_groups or service requests
Flags:
Baseline/Custom:	Baseline

select * from table_function

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
cond_expected	LONG	int				DIRECT	1 = The expected function in a conditional group	Search (5)
cond_operator	LONG	int				DIRECT	For condition groups, the operator type. 0 = equal to, 1 = greater than, 2 = less than, 3 = greater than/equal to, 4 = less than/equal to	Search (3)
cond_type	LONG	int				DIRECT	For condition groups, the function type. 0 = value, 1 = default, 2 = action	Search (5)
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
exec_loc	LONG	int				DIRECT, ALLOW_NULL	Where the function is to be executed: 0 = server, 1 = client
flags	LONG	int				DIRECT	Various flags that control the way a function is used	Search (3)
focus_object	CHAR	varchar		64			The focus object of the function (and its related group/rqst/sub-process)	Search (2)
func_type	LONG	int				DIRECT	Function type. 0 = normal, 1 = error, 2 = cancel	Search (9)
goto_cond	CHAR	varchar		255		ALLOW_NULL	The focus object of the function (and its related group/rqst/sub-process)	Search (1)
goto_cond_seqno	LONG	int				DIRECT, ALLOW_NULL	Order of evaluation of goto_cond (lowest to highest)	Search (1)
goto_seqno	LONG	int				DIRECT, ALLOW_NULL	Goto sequence number for associative group functions	Search (3)
is_checkpoint	LONG	tinyint				DIRECT, ALLOW_NULL	This is a checkpoint function in a manual checkpoint group	Search (1)
objid	LONG	int	3			DIRECT	Internal record number	Search (22)
reforecast	LONG	int				DIRECT, ALLOW_NULL	Reforecast at the completion of this function	Search (2)
seqno	LONG	int				DIRECT	Sequence number for serial functions	Search (13)
val_attrib_name	CHAR	varchar		64			Value path target attribute name	Search (2)
val_attrib_type	LONG	int				DIRECT	Attribute type: Same as N_Attribute.N_Type	Search (2)
val_filter_list	CHAR	varchar		255			Value reverse path filter list	Search (2)
val_focus	LONG	int				DIRECT	If val_type is Path then 0 = focus object, 1 =group_inst	Search (3)
val_is_flexible	LONG	int				DIRECT	0 = attribute is fixed, 1 = attribute is flexible	Search (2)
val_rev_path	CHAR	varchar		255			Where value is a path, this is the reverse path	Search (2)
val_sqlfrom	CHAR	varchar		255			FROM clause for SQL statement	Search (2)
val_sqlwhere	CHAR	varchar		255			WHERE clause for SQL statement	Search (2)
val_target_id	LONG	int				DIRECT	Value path target type ID	Search (2)
val_target_name	CHAR	varchar		64			Value path target object name	Search (2)
val_type	LONG	int				DIRECT	0 = Path, 1 = constant	Search (3)
value	CHAR	varchar		255			The value to match for a conditional group	Search (3)

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Used in Views
function2cdo_context_map	OTM	cdo_context_map	cdo_context_map2function	CDO context name mappings for this function
belongs2func_group	MTO	func_group	contains2function	The function group that this function belongs to.	Search (13)
function2func_group	MTO	func_group	func_group2function	A group associated with this function (ie a sub_group)	Search (6)
function2group_inst	OTM	group_inst	group2function	Group instances for this function
function2process	MTO	process	process2function	A process associated with this function	Search (4)
function2rqst_inst	OTM	rqst_inst	rqst2function	Request instances for this function
function2svc_rqst	MTO	svc_rqst	svc_rqst2function	A service request associated with this function	Search (6)

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
ind_function_seq	belongs2func_group:seqno	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
b2fg9753	belongs2func_group	nonclustered located on PRIMARY
f2fg9753	function2func_group	nonclustered located on PRIMARY
f2p9753	function2process	nonclustered located on PRIMARY
f2sr9753	function2svc_rqst	nonclustered located on PRIMARY
ind_function_seq	belongs2func_group, seqno	nonclustered, unique located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
9851	svc_rqst_inst_view	func_group, function, group_inst, rqst_inst
9852	svc_fld_view	function, svc_fld, svc_rqst
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
9863	process_rqst_view	func_group, function, group_inst, rqst_inst, svc_rqst
9866	process_exec_grp_view	func_group, function, group_inst
9867	process_canc_grp_view	func_group, function, group_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
9894	procdef_node_view	func_group, function, process, svc_rqst
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
9899	cdo_map_view	cdo_context, cdo_context_map, function
9900	procdef_cdomap_view	cdo_context, cdo_context_map, function
9902	process_grp_view	func_group, function, group_inst

My Recent Objects

function

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