Table Name:	process
Table Number:	9751
Group:	Process Manager
Description:	Contains one instance for each generic process
Flags:
Baseline/Custom:	Baseline

select * from table_process

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
bizcal_filter_list	CHAR	varchar		255		ALLOW_NULL	Business calendar reverse path filter list	Search (1)
bizcal_path	CHAR	varchar		255		ALLOW_NULL	Business calendar path	Search (3)
bizcal_rev_path	CHAR	varchar		255		ALLOW_NULL	Business calendar reverse path	Search (1)
bizcal_sqlfrom	CHAR	varchar		255		ALLOW_NULL	FROM clause for business calendar path SQL statement	Search (1)
bizcal_sqlwhere	CHAR	varchar		255		ALLOW_NULL	WHERE clause for business calendar path SQL statement	Search (1)
category	CHAR	varchar		40		ALLOW_NULL	User=defined category - user-defined popup list 'Script Category'	Search (2)
creation_time	CLK_TIME	datetime				ALLOW_NULL	Date and time the process definition was created
description	CHAR	varchar		255			A brief description of the nature of the process	Search (3)
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
duration	LONG	int				DIRECT	Max. duration (number of seconds before timeout)	Search (3)
flags	LONG	int				DIRECT	Flags that control the way a process is used
focus_object	CHAR	varchar		64			The focus object of the process	Search (5)
forecasting	LONG	int				DIRECT, ALLOW_NULL	Forecasting mode: 0 = None, 1 = Forecast at creation, 2 = Reforecast each step	Search (5)
id	CHAR	varchar		128			Process ID	Search (9)
is_agent_runnable	LONG	tinyint				DIRECT, ALLOW_NULL	Controls if the process/script may be selected and run by an agent choice: 0 = no, 1 = yes	Search (1)
is_transient	LONG	tinyint			0	DIRECT, ALLOW_NULL	Defines a process as transient, in which case it does not create any instance data when executed.	Search (2)
is_validated	LONG	tinyint				DIRECT, ALLOW_NULL	0 = the process definition is not validated, 1 = the definition is validated and may be made active	Search (1)
last_mod_time	CLK_TIME	datetime	46			ALLOW_NULL	Date and time the process definition was last modified	Search (1)
objid	LONG	int	3			DIRECT	Internal record number	Search (16)
owner_filter_list	CHAR	varchar		255		ALLOW_NULL	Owner reverse path filter list	Search (1)
owner_path	CHAR	varchar		255		ALLOW_NULL	Owner path	Search (3)
owner_rev_path	CHAR	varchar		255		ALLOW_NULL	Owner reverse path	Search (1)
owner_sqlfrom	CHAR	varchar		255		ALLOW_NULL	FROM clause for owner path SQL statement	Search (1)
owner_sqlwhere	CHAR	varchar		255		ALLOW_NULL	WHERE clause for owner path SQL statement	Search (1)
status	CHAR	varchar		40			Status of the process - New, Verified, Active, Obsolete	Search (3)
tlist	CHAR	varchar		255		ALLOW_NULL	Semicolon delimited list of tags that define process instances that can run non-ACTIVE versions of this definition	Search (2)
type	LONG	tinyint				DIRECT, ALLOW_NULL	Process type: 0 = Process, 1 = Script	Search (2)
version	LONG	int				DIRECT	Version	Search (10)

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	MTM Table	Used in Views
process2campaign	MTM	campaign	campaign2process	Sales campaigns that may run this process/script	mtm_campaign9_ process6
process2func_group	OTOF	func_group	func_group2process	Top level function group for the process. Note each process has exactly one function group
process2function	OTM	function	function2process	Functions to this sub-process
process_status2gbst_elm	MTO	gbst_elm	status2process	Status code for the process		Search (1)
process2mod_level	MTM	mod_level	mod_level2process	Product mod_levels that may be presented in this process/script	mtm_mod_level54_ process8
process2offering	MTM	offering	offering2process	Offerings that may be presented in this process/script	mtm_offering9_ process7
process2proc_diag	OTM	proc_diag	proc_diag2process	The graphical diagrams that represent this process definition
inst2proc_inst	OTM	proc_inst	proc_inst2process	Instances of this generic process. Created when this process is executed
author2user	MTO	user	process_author2process	The user who created this process definition		Search (1)

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
I9751	id:version	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
a2u9751	author2user	nonclustered located on PRIMARY
d9751	description	nonclustered located on PRIMARY
fo9751	focus_object	nonclustered located on PRIMARY
I9751	id, version	nonclustered, unique located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY
s9751	status	nonclustered located on PRIMARY
tlist9751	tlist	nonclustered located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
5848	open_script_v	gbst_elm, process, user
5857	scr_proc_inst_view	proc_inst, proc_inst_log, process, user
5982	open_script_distinct_v	process
9850	group_inst_view	func_group, group_inst, proc_inst, process
9853	process_function_view	func_group, function, process, svc_rqst
9856	procinst_node_view	func_group, function, group_inst, process
9857	select_proc_inst	group_inst, proc_inst, process
9858	process_node_view	func_group, function, process, svc_rqst
9887	fc_subproc_view	func_group, function, proc_fc_item, proc_forecast, proc_inst, process
9888	proc_assoc_bizcal_fld	process
9889	proc_owning_user_fld	process
9891	forecast_type_view	proc_inst, process, rqst_inst
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
9897	procinst_action_view	function, group_inst, proc_inst, process, rqst_inst, svc_rqst
9901	rqst_inst_rcvry_view	group_inst, proc_inst, process, rqst_inst
9903	stall_leaf_node_view	group_inst, proc_inst, process, rqst_inst, svc_rqst

My Recent Objects

process

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