Table Name:	hgbst_elm
Table Number:	217
Group:	Policy Mgr
Description:	Specific element <item> in a custom list (user-defined pop up list)
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_hgbst_elm

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
intval1	LONG	int			0	DIRECT	Multi-purpose field; used to attach control information to the element
objid	LONG	int	3			DIRECT	Internal record number	Search (2)
rank	LONG	int	9			DIRECT	Rank order of the item in its list	Search (1)
state	CHAR	varchar		10			Status of the item; i.e., 0=active, 1=inactive, default=2
title	CHAR	varchar	2	40			Title <name> of the item	Search (1)
x_addnl_info	CHAR	varchar		255		USER_DEFINED	Additional info for the list element

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
workgroup2canned_response	MTM	canned_resp	canned_response2workgroup	Canned Responses that this workgroup has access to	USER_DEFINED	mtm_hgbst_elm2_ canned_resp0
workgroup2dt_notice	MTM	dt_notice	dt_notice2workgroup	Notices that this workgroup can view	USER_DEFINED	mtm_hgbst_elm3_ dt_notice1
hgbst_elm2fc_loc_elm	OTM	fc_loc_elm	fc_loc_elm2hgbst_elm	HGBST Element for this locale string	USER_DEFINED
hgbst_elm2hgbst_show	MTM	hgbst_show	hgbst_show2hgbst_elm	Relation to level of the hierarchical list in which the element is contained		mtm_hgbst_elm0_ hgbst_show1

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
384	hshow2hgse	hgbst_elm, hgbst_show
6016	hgsl2hgse	hgbst_elm, hgbst_lst

My Recent Objects

hgbst_elm

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user