Table Name:	rqst_inst
Table Number:	9758
Group:	Process Manager
Description:	Contains one instance for each service request that has been executed
Flags:	CACHEOBJIDS
Baseline/Custom:	Baseline

select * from table_rqst_inst

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
async_pending_count	LONG	int				DIRECT, ALLOW_NULL	The number of asynchronous return field pending for this action	Search (1)
busy	LONG	int				DIRECT	0 = request is idle, 1 = request is busy	Search (3)
depends_count	LONG	int				DIRECT, ALLOW_NULL	The number of dependent/activation fields pending for this action	Search (1)
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 function was completed	Search (3)
err_code	CHAR	varchar		30			Error Code	Search (2)
err_info	CHAR	varchar		128			Additional info for an error	Search (2)
err_mess	CHAR	varchar		255			Error message	Search (2)
err_type	CHAR	varchar		30			Type of error eg USER, SYSTEM	Search (2)
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 (3)
focus_object	CHAR	varchar		64			Focus object as text (focus_type is less useful!)	Search (3)
focus_type	LONG	int				DIRECT	Focus object for group	Search (3)
id	CHAR	varchar		80		ALLOW_NULL	Action instance ID	Search (3)
interface_err_code	CHAR	varchar		30			Error code returned by interface	Search (1)
objid	LONG	int	3			DIRECT	Internal record number	Search (13)
resume_focus_lowid	LONG	int				DIRECT	Resume focus lowid for error group	Search (2)
resume_focus_type	LONG	int				DIRECT	Resume focus type for error group	Search (2)
retry_count	LONG	int				DIRECT	Retry count	Search (2)
start_time	CLK_TIME	datetime					Date and time the function was executed	Search (7)
status	CHAR	varchar		30			Active, Complete, Suspended, Error	Search (7)
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
rqst_inst2fld_inst	OTM	fld_inst	fld2rqst_inst	Field instances for the request instance
rqst2function	MTO	function	function2rqst_inst	Function for this request instance	Search (4)
rqst_inst2group_inst	MTO	group_inst	group2rqst_inst	Function group instance for the request instance	Search (6)
rqst_inst2proc_fc_item	OTOF	proc_fc_item	fc_item2rqst_inst	Forecast related to this action (svc rqst) instance
rqst_inst2proc_inst	MTO	proc_inst	proc_inst2rqst_inst	Process instance that owns the request instance	Search (4)
rqst2rqst_pending	OTM	rqst_pending	pending2rqst_inst	Number of pending fields for this request
rqst2queue	OTM	rqst_queue	queue2rqst_inst	Execution queue for this request
rqst_inst2svc_rqst	MTO	svc_rqst	inst2rqst_inst	Generic service request for the request instance	Search (6)

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

Index Name	Fields	Additional Information
fl9758	focus_lowid	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY
r2f9758	rqst2function	nonclustered located on PRIMARY
ri2gi9758	rqst_inst2group_inst	nonclustered located on PRIMARY
ri2pi9758	rqst_inst2proc_inst	nonclustered located on PRIMARY
ri2sr9758	rqst_inst2svc_rqst	nonclustered located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
9851	svc_rqst_inst_view	func_group, function, group_inst, rqst_inst
9855	rqstinst_node_view	func_group, function, group_inst, rqst_inst, svc_rqst
9862	fld_status_view	fld_inst, rqst_inst, svc_fld
9863	process_rqst_view	func_group, function, group_inst, rqst_inst, svc_rqst
9868	rqst_search_view	rqst_inst, svc_rqst
9873	process_rqst_inst_view	proc_inst, rqst_inst, svc_fld, svc_rqst
9874	process_fld_inst_view	fld_inst, rqst_inst, svc_fld, svc_rqst
9891	forecast_type_view	proc_inst, process, rqst_inst
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
9904	fld_inst_view	fld_inst, rqst_inst, svc_fld

My Recent Objects

rqst_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