Table Name:hgbst_show
Table Number:218
Group:Policy Mgr
Description:Defines a level of a custom list (user-defined, hierarchical pop up list)
Flags: 
Baseline/Custom:Baseline
select * from table_hgbst_show
Keyboard shortcuts available
Fields:

(double-click a column header to select column text)

Field Name
Common Type
Database Type
Generic Field ID
Array Size
Default
Flags
Comment
Field Used in Views
def_valLONGint  0 DIRECT Indicates which element in the level is the default element  
devLONGint151 1 DIRECT, ALLOW_NULL Row version number for mobile distribution purposes  
last_mod_timeCLK_TIMEdatetime    Shows date and time last modified. Reserved; future  
objidLONGint3  DIRECT Internal record number Search (2)
show_infoARRAY10 DIRECT, BINARY Associated binary array object Search (2)
titleCHARvarchar 30  Title/name of the level  
Relations:
Relation
Type
Target Object
Inverse Relation
Comment
Flags
MTM Table
Used in Views
hgbst_show2hgbst_elmMTMhgbst_elmhgbst_elm2hgbst_showElements in the level of the user-defined pop up list  mtm_hgbst_elm0_
hgbst_show1		Search (2)
hgbst_show2hgbst_lstOTOFhgbst_lsthgbst_lst2hgbst_showIf the top level hgbst_show in the hierarchy, the user-defined pop up list that contains the level    
prnt_chld2hgbst_showOTMhgbst_showchld_prnt2hgbst_showRelated child level in hierarchical user-defined pop up list    
chld_prnt2hgbst_showMTOhgbst_showprnt_chld2hgbst_showIf not the top level show in the hierarchy, the parent level hgbst_show in the hierarchy    
Indexes: (Defined in Clarify Schema)
Index Name
Fields
Flags
Indexes (Defined in Database):
Index Name
Fields
Additional Information
objindexobjidclustered, unique located on PRIMARY
Referenced in Views:
View ID
View Name
Tables
383hgsl2hshow hgbst_lst, hgbst_show
384hshow2hgse hgbst_elm, hgbst_show
My Recent Objects
hgbst_show      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user