Table Name:	r_rqst_ctx
Table Number:	5392
Group:	Resource Mgr
Description:	Additional attribution of a routing request
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_r_rqst_ctx

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
d_value	DECIMAL	decimal (19,4)					Value associated with the name, if value type=4
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
f_value	FLOAT	real					Value associated with the name, if value type=3
i_value	LONG	int				DIRECT	Value associated with the name, if value type=2
name	CHAR	varchar		30			Name giving the meaning of the contents of the value field e.g. URL, NickName, etc.
objid	LONG	int	3			DIRECT	Internal record number
str_value	CHAR	varchar		255			Value associated with the name, if value_type=1
title	CHAR	varchar	2	80			Case or service call title; summary of case details
value_type	LONG	tinyint				DIRECT	Indicates the data type of the value 1=text, 2=integer, 3=floating point, 4=decimal

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
r_rqst_ctx2r_rqst	MTO	r_rqst	r_rqst2r_rqst_ctx	Routing request bearing the attribution

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
r_rqst_ind	r_rqst_ctx2r_rqst:name	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
ind_name	name	nonclustered located on PRIMARY
ind_title	title	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY
r_rqst_ind	r_rqst_ctx2r_rqst, name	nonclustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables

My Recent Objects

r_rqst_ctx

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user