| Table Name: | hgbst_lst |
| Table Number: | 216 |
| Group: | Policy Mgr |
| Description: | Defines 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 |
|---|---|---|---|---|---|---|---|---|
| deletable | LONG | int | DIRECT | Indicates if list can be deleted; i.e., 0=can be deleted, 1=cannot be deleted | ||||
| description | CHAR | varchar | 50 | Description/explanation of the list | ||||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| list_id | LONG | int | DIRECT | Unique ID of the list for a language | ||||
| locale | LONG | smallint | 0 | DIRECT | Preferred list language; i.e., 0=English, 1=SJIS, 2=French, 3=German, 4=Spanish, 5=Chinese Big5 (traditional character), 6=Chinese GB (simplified character), 7=Korean, 8-12 (Reserved), Default=0 | |||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (2) | ||
| title | CHAR | varchar | 2 | 30 | Title/name of list | Search (1) |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| hgbst_lst2hgbst_show | OTOP | hgbst_show | hgbst_show2hgbst_lst | Related information about display and behavior of the hierarchical list | Search (2) | ||
| hgbst_l2pro_hgl_role | OTM | pro_hgl_role | pro_hgl2hgbst_lst | List usage for Exchange protocols |
| Index Name | Fields | Flags |
|---|---|---|
| title_index | title | UNIQUE |
| Index Name | Fields | Additional Information |
|---|---|---|
| ind_hgbst_lst2hgbst_show | hgbst_lst2hgbst_show | nonclustered located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| title_index | title | nonclustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 383 | hgsl2hshow | hgbst_lst, hgbst_show |
| 6016 | hgsl2hgse | hgbst_elm, hgbst_lst |
| hgbst_lst | |||