Table Name:	svc_rqst
Table Number:	9754
Group:	Process Manager
Description:	Contains one instance for each service request
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_svc_rqst

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
action_spec	CHAR	text				ALLOW_NULL	The action_spec XML that defines the action	Search (1)
cb_exesub	LONG	int				DIRECT	0 = svc_name is Tux service, 1 = svc_name is sub func. name written to subfld, subsvc=Tux service, 2: Tux service = CB_EXESUB, subsvc is CLFY_SUB	Search (2)
description	CHAR	varchar		255			A description of the request	Search (1)
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
duration	LONG	int				DIRECT	Maximum duration (number of seconds before timeout)	Search (7)
id	CHAR	varchar		80			Function ID	Search (7)
is_rerunnable	LONG	tinyint				DIRECT, ALLOW_NULL	Set to 1 if the service call can be safely re-executed after a system failure	Search (2)
max_retries	LONG	int				DIRECT	Maximum retries	Search (3)
objid	LONG	int	3			DIRECT	Internal record number	Search (15)
retry_interval	LONG	int				DIRECT	Retry Interval	Search (3)
showpage_type	LONG	tinyint				DIRECT, ALLOW_NULL	For showpage actions: 0 - normal, 1 = No Display, 2 = Display Only	Search (1)
stall_delay	LONG	int				DIRECT	The time to wait before this action is considered to be stalled.	Search (2)
sub_field	CHAR	varchar		64			The FML field that svc_name is written to	Search (2)
sub_service	CHAR	varchar		30			COntrolled by cb_exesub, the tux service, or sub-service to call	Search (2)
svc_name	CHAR	varchar		128			The Tuxedo service name that this function will call	Search (3)
type	LONG	int				DIRECT	0 = Service call, 1 = Null, 2 = Fallout, 3 = Raise Error 4 = Resume 5 = Raise Cancel 6 = ShowPage	Search (8)
use_elapsed	LONG	int				DIRECT	For forecasting: 0 = use bizcal hours, 1 = use elapsed time	Search (3)

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
svc_rqst2function	OTM	function	function2svc_rqst	The function associated with this item
svc_rqst2proc_fc_item	OTM	proc_fc_item	fc_item2svc_rqst	Forecasts related to this service request
svc_rqst2rqst_def	MTO	rqst_def	rqst_def2svc_rqst	The definition that this request is based on
inst2rqst_inst	OTM	rqst_inst	rqst_inst2svc_rqst	Instances of this generic request. Created when the owning process is executed and this request is initiated
svc_rqst2showpage	MTO	showpage	showpage2svc_rqst	Related showpage definition for ShowPage service requests			Search (1)
rqst2svc_fld	OTM	svc_fld	fld2svc_rqst	The fields used by the function

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
sn9754	svc_name	nonclustered located on PRIMARY
sr2rd9754	svc_rqst2rqst_def	nonclustered located on PRIMARY
t9754	type	nonclustered located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
9852	svc_fld_view	function, svc_fld, svc_rqst
9853	process_function_view	func_group, function, process, svc_rqst
9855	rqstinst_node_view	func_group, function, group_inst, rqst_inst, svc_rqst
9858	process_node_view	func_group, function, process, svc_rqst
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
9875	dummy_svcrqst_view	func_group, function, svc_rqst
9886	fc_rqst_view	func_group, function, proc_fc_item, proc_forecast, proc_inst, svc_rqst
9890	inst_dependent_field	proc_fc_item, svc_fld, svc_rqst
9894	procdef_node_view	func_group, function, process, svc_rqst
9895	procdef_action_view	showpage, svc_fld, svc_rqst
9897	procinst_action_view	function, group_inst, proc_inst, process, rqst_inst, svc_rqst
9903	stall_leaf_node_view	group_inst, proc_inst, process, rqst_inst, svc_rqst

My Recent Objects

svc_rqst

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user