Siebel Applications Administration Guide > Working with Lists of Values >

List-of-Values Fields


List-of-values records have the fields shown in Table 12. Not all fields for list-of-values records are displayed in the standard user interface. You can use the Columns Displayed menu option to see a field that is not displayed.

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 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 need to use the High or Low fields, or other extra fields, 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 could use the High and Low fields to automatically fill in the high and low temperatures when a user picks a Month value in a Date drop-down list. To do so, you would 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 picklists 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 Administration Guide.

Table 12. List-of-Values Fields
Field
Description

Type

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

Display Value

Value as displayed in the drop-down list.

Translate

When checked, indicates that internationalization is needed. (There is no client or server functionality associated with this field.)

Language Independent Code (LIC)

Along with the Display Value, the Language Independent Code 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, there might be three list-of-values items with a Language Independent Code of Mr. These might have a display value and language of Mr. (English-American), Senor (Spanish - Modern), and Herr (German), respectively. German users would see Herr in the Personal Title drop-down list, Spanish users would see Senor and English users would see Mr. Although the display values vary across language instances, the value stored in the database when a user selects any one of these 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 (Language Independent Code)

The Language Independent Code of a parent list of values. Used in hierarchical lists of values, where the values that will display 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 is enforced by limiting the values in the Pick Parent dialog box to those values which do not themselves have parent display values.

Replication Level

Specifies whether the translation is intended for use at all levels in the translation hierarchy or only at the regional level.

High

Extra field available for use by pick maps or for customization.

Low

Extra field available for use by pick maps or for customization.

Order

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

Active

When checked, indicates that the value is displayed to the end user. When unchecked, indicates that the value is not displayed to the end user.

Language Name

Language used for the list of values Display Value field.

Target Low

Extra field used in Smart Reports.

Target High

Extra field used in Smart Reports.

Weighting Factor

Extra field available for use by pick maps or for customization.

Bitmap

Bitmap file that is displayed.

Description

Description of a specific value.

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