Table Name:	csc_expression
Table Number:	5124
Group:	Exchange Mgr
Description:	Used when multiple STATEMENT's define a PROBLEM or RESOLUTION. The EXPRESSION form enables a Boolean (true/false) expression defining relationships between the statements using the relations: AND, OR, and NOT
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_csc_expression

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
objid	LONG	int	3			DIRECT	Internal record number
relation	CHAR	varchar		30			Relation governing this expression. Default=AND for list of statements. Other values are: AND_ORDERED, AND_UNORDERED, OR_ORDERED, OR_UNORDED, NOT
server_id	LONG	int				DIRECT	Exchange protocol server ID number

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
text2csc_admin	OTOP	csc_admin	admin2csc_expression	Related CSC expression
nested2csc_expression	OTOP	csc_expression	child2csc_expression	Nested expression to allow complex Boolean expressions to be represented
child2csc_expression	OTOF	csc_expression	nested2csc_expression	Expression in which this one is nested
text2csc_problem	MTO	csc_problem	problem2csc_expression	Problem stated with the expression
text2csc_product	MTO	csc_product	prod2csc_expression	Product identified by the expression
text2csc_resolution	MTO	csc_resolution	res2csc_expression	Resolution stated with the expression
text2csc_statement	OTM	csc_statement	text2csc_expression	Component statements

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

Index Name	Fields	Additional Information
ind_text2csc_problem	text2csc_problem	nonclustered located on PRIMARY
ind_text2text2csc_resolution	text2csc_resolution	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables

My Recent Objects

csc_expression

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user