Siebel Applications Administration Guide > Working with Lists of Values >

List-of-Values Fields


Some list-of-values fields, such as High, Low, and Weighting Factor, are for use by specialized Siebel C++ code to store additional information about the selected list-of-values record. In addition, pick maps can use list-of-value fields such as High, Low, and Weighting Factor. Pick maps normally use the Display Value field, which causes the list item selected by the user to be stored in the Siebel database exactly as it appears in the list. These fields can be used to populate other fields of the business component in which the pick map is defined.

If you must use the High or Low fields, or other extra fields, then use Siebel Tools to extend the PickList Generic BusComp by adding fields mapped to the corresponding columns on the S_LST_OF_VAL table. For example, you can use the High and Low fields to automatically populate the high and low temperatures when a user picks a Month value in a Date drop-down list. To do so, you add two pick maps to the Month field by adding the High and Low list-of-value fields to the Pick List field of Pick Map. For more information about the PickList Generic BusComp, and about configuring static drop-down lists and pick maps, see Configuring Siebel Business Applications.

NOTE:  The Target High and Target Low fields are used exclusively with Smart Reports. For more information, see Siebel Reports Guide.

Table 11 shows the fields for List-of-Values records. Not all fields for list-of-values records appear in the standard user interface. You can use the Columns Displayed option in the menu for the cogwheel icon to display a field that does not appear.

Table 11. List-of-Values Fields
Field
Description

Type

The type of list of values (the field name).

Display Value

The value appears in the drop-down list.

Translate

A check box that, when checked, indicates that internationalization is needed. (No client or server functionality ia associated with this field.)

Language Independent Code

A value that, along with the Display Value, uniquely identifies a value for a particular LOV type. In most cases the Language Independent Code is the same as the Display Value. However, the Language Independent Code and Display Value are different for multilingual lists of values (MLOVs). MLOVs allow a single logical list item to support multiple display values for users who are accessing the Siebel application in different languages.

For example if the MR_MS (Personal Title) list of values were multilingual, then there might be three list-of-values items with a Language Independent Code of Mr. These lists of values might have a display value and language of Mr. (English-American), Senor (Spanish - Modern), and Herr (German), respectively. German users see Herr in the Personal Title drop-down list, Spanish users see Senor and English users see Mr. Although the display values vary across language instances, the value stored in the Siebel database when a user selects any one of these values is always Mr. because that is the Language Independent Code associated with Herr, Senor, and Mr.

Values entered in the Language Independent Code field are sometimes referred to as LIVs (language independent values).

Parent LIC

The Language Independent Code of a parent list of values. This field is used in hierarchical lists of values, where the values that appear in a drop-down list are constrained by the value selected in the parent drop-down list of values. For more information, see Constrained Lists of Values.

There are only parents and children in this hierarchy. Grandchildren are not allowed. This hierarchy is enforced by limiting the values in the Pick Parent dialog box to those values that do not themselves have parent display values.

Replication Level

A value that specifies whether the translation is intended for use at all levels in the translation hierarchy or only at the regional level.

High

An extra field available for use by pick maps or for customization.

Low

An extra field available for use by pick maps or for customization.

Order

The numerical order in which a value appears within a drop-down list.

Active

A check box that, when checked, indicates that the value appears to the user, and that when unchecked, indicates that the value does not appear to the user.

Language Name

The language used for the Display Value field in the list of values.

Target Low

An extra field used in Smart Reports.

Target High

An extra field used in Smart Reports.

Weighting Factor

An extra field available for use by pick maps or for customization.

Bitmap

The bitmap file that appears.

Description

A description of a specific value.

Siebel Applications Administration Guide Copyright © 2015, Oracle and/or its affiliates. All rights reserved. Legal Notices.