Table Name:	flex_defn
Table Number:	5802
Group:	Flexible Attributes
Description:	Defines Flexible Attributes for all objects
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_flex_defn

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
attribute_datatype	LONG	int				DIRECT	The datatype of the flexible attribute
attribute_name	CHAR	varchar		255			The user supplied name of the flexible attribute
default_value	CHAR	varchar		255			The default value for the flexible attribute
description	CHAR	varchar		255			A user supplied description of the flexible attribute
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
effective_end_date	CLK_TIME	datetime					Final date at which this definition ceases to be usable. If not set, attribute stays active forever
effective_start_date	CLK_TIME	datetime					Initial date at which this definition becomes usable. If not set, there's no start date - attribute is active unless we passed an end date
flags	LONG	int				DIRECT	Bitmask for holding application specific flags for this definition
is_required	LONG	tinyint			0	DIRECT, ALLOW_NULL	Specifies if this is a required flexible attribute. 0=No, 1=Yes; Default=0
is_searchable	LONG	tinyint			0	DIRECT, ALLOW_NULL	Specifies if this field is case insensitive. 0=No, 1=Yes; Default=0
label	CHAR	varchar		255			Displayable label or name for use by this attribute
objid	LONG	int	3			DIRECT	Internal record number
valid_values	CHAR	varchar		255			String that holds the valid values for this attribute

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
flex_defn2fa_case	OTM	fa_case	fa_case2flex_defn
flex_defn2fa_contr_itm	OTM	fa_contr_itm	fa_contr_itm2flex_defn
flex_defn2fa_contract	OTM	fa_contract	fa_contract2flex_defn
flex_defn2fa_group_inst	OTM	fa_group_inst	fa_group_inst2flex_defn
flex_defn2fa_order_action	OTM	fa_order_action	fa_order_action2flex_defn
flex_defn2fa_part_num	OTM	fa_part_num	fa_part_num2flex_defn
flex_defn2fa_site_part	OTM	fa_site_part	fa_site_part2flex_defn
flex_defn2fa_subcase	OTM	fa_subcase	fa_subcase2flex_defn
flex_defn2flex_tmpl	MTM	flex_tmpl	flex_tmpl2flex_defn	Flexible attribute template related to flexible attribute template		mtm_flex_defn0_ flex_tmpl0

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

Referenced in Views:

View ID	View Name	Tables

My Recent Objects

flex_defn

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user