| 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 |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| def_val | LONG | int | 0 | DIRECT | Indicates which element in the level is the default element | |||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| last_mod_time | CLK_TIME | datetime | Shows date and time last modified. Reserved; future | |||||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (2) | ||
| show_info | ARRAY | 1 | 0 | DIRECT, BINARY | Associated binary array object | Search (2) | ||
| title | CHAR | varchar | 30 | Title/name of the level |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| hgbst_show2hgbst_elm | MTM | hgbst_elm | hgbst_elm2hgbst_show | Elements in the level of the user-defined pop up list | mtm_hgbst_elm0_ hgbst_show1 | Search (2) | |
| hgbst_show2hgbst_lst | OTOF | hgbst_lst | hgbst_lst2hgbst_show | If the top level hgbst_show in the hierarchy, the user-defined pop up list that contains the level | |||
| prnt_chld2hgbst_show | OTM | hgbst_show | chld_prnt2hgbst_show | Related child level in hierarchical user-defined pop up list | |||
| chld_prnt2hgbst_show | MTO | hgbst_show | prnt_chld2hgbst_show | If not the top level show in the hierarchy, the parent level hgbst_show in the hierarchy |
| Index Name | Fields | Flags |
|---|
| Index Name | Fields | Additional Information |
|---|---|---|
| objindex | objid | clustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 383 | hgsl2hshow | hgbst_lst, hgbst_show |
| 384 | hshow2hgse | hgbst_elm, hgbst_show |
| hgbst_show | |||