Table Name:	proc_inst
Table Number:	9756
Group:	Process Manager
Description:	Contains one instance for each generic process that has been executed
Flags:	CACHEOBJIDS
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_proc_inst

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
arch_ind	LONG	int				DIRECT, ALLOW_NULL	When set to 1, indicates the object is ready for purge/archive
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
duration	LONG	int				DIRECT, ALLOW_NULL	Maximum duration (number of seconds before timeout)	Search (1)
end_time	CLK_TIME	datetime					Date and time the process execution completed	Search (2)
err_code	CHAR	varchar		30			Error Code	Search (1)
err_mess	CHAR	varchar		255			Error message text	Search (1)
exec_tag	CHAR	varchar		30		ALLOW_NULL	Identifying tag that determines eligibility to run non active processes
focus_lowid	LONG	int				DIRECT	Exclusive realtion objid for thge owning object instance
focus_type	LONG	int				DIRECT	Exclusive realtion type for thge owning object instance
objid	LONG	int	3			DIRECT	Internal record number	Search (15)
score	LONG	int				DIRECT, ALLOW_NULL	Accumulated numeric score for responses in script run	Search (1)
start_time	CLK_TIME	datetime					Date and time the process was executed	Search (2)
status	CHAR	varchar		30			Active, Complete, Suspended	Search (2)
system_suspend	LONG	tinyint				DIRECT, ALLOW_NULL	Set to 1 if the instances was SUSPENDED for a system passivate

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
proc_inst2biz_cal_hdr	MTO	biz_cal_hdr	biz_cal_hdr2proc_inst	Business calendar for the process instance
proc_inst2campaign	MTO	campaign	campaign2proc_inst	Sales campaign that runs this process/script
proc_inst2contact	MTO	contact	contact2proc_inst	Contact contacted in this process/script run
proc_inst2context_inst	OTM	context_inst	context_inst2proc_inst	Initial context for the process instance
proc2group_inst	OTM	group_inst	group2proc_inst	Top level function group instance for this process instance
proc_inst2all_group_inst	OTM	group_inst	all_group_inst2proc_inst	Group_inst owned by proc_inst
proc_inst2intrxn	MTO	intrxn	intrxn2proc_inst	Interaction created in this process/script run
proc_inst2lead	MTO	lead	lead2proc_inst	Lead contacted in this process/script run
proc_inst2mod_level	MTM	mod_level	mod_level2proc_inst	Product mod_level presented in this process/script run		mtm_mod_level55_ proc_inst10
proc_inst2offering	MTM	offering	offering2proc_inst	Offering presented in this process/script run		mtm_offering10_ proc_inst9
proc_inst2proc_forecast	OTOF	proc_forecast	fc2proc_inst	The forecast for the process instance
proc_inst2proc_inst_log	OTOF	proc_inst_log	proc_inst_log2proc_inst	Log corresponds to this process instance
proc_inst2process	MTO	process	inst2proc_inst	Generic process for this instance			Search (8)
proc_inst2rqst_inst	OTM	rqst_inst	rqst_inst2proc_inst	Request instances owned by this process instance
proc_inst_owner2user	MTO	user	owner2proc_inst	Owner of the process instance			Search (1)

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

Index Name	Fields	Additional Information
objindex	objid	clustered, unique located on PRIMARY
pi2p9756	proc_inst2process	nonclustered located on PRIMARY
pio2u9756	proc_inst_owner2user	nonclustered located on PRIMARY
s9756	status	nonclustered located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
5857	scr_proc_inst_view	proc_inst, proc_inst_log, process, user
9850	group_inst_view	func_group, group_inst, proc_inst, process
9857	select_proc_inst	group_inst, proc_inst, process
9869	top_level_node_view	func_group, group_inst, proc_inst
9873	process_rqst_inst_view	proc_inst, rqst_inst, svc_fld, svc_rqst
9882	proc_fc_item_view	proc_fc_item, proc_forecast, proc_inst
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
9891	forecast_type_view	proc_inst, process, rqst_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
9903	stall_leaf_node_view	group_inst, proc_inst, process, rqst_inst, svc_rqst

My Recent Objects

proc_inst

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user