Applications Administration Guide > Working with Lists of Values >

About Lists of Values


A list of values (LOV) is a set of values that populates a static picklist, which is accessed when a user clicks a drop-down list in the user interface.

Drop-down lists can be based on two types of picklists: static picklists and dynamic picklists.

  • A static picklist has a selection list that is a static list of values. An example of a static picklist is a drop-down list containing postal abbreviations for states and countries.
  • A dynamic picklist has a selection list that usually contains transactional data. An example of a dynamic picklist is a drop-down list containing account names.

    As a rule of thumb, dynamic picklists include all picklists that do not retrieve values stored in the S_LST_OF_VAL table. Dynamic picklists are typically rendered through a pick applet, such as the picklist used to choose an account for a contact. However, they can be configured to appear as a drop-down list.

The remainder of this section focuses on static picklists, whose contents can be administered from the list-of-values views. For information on how to set up a new list of values and configure both static and dynamic picklists, see Configuring Siebel eBusiness Applications.

This section describes how to work with the values that populate static picklists, including how to create or modify values in an existing list of values, and inactivate values when you do not want them to display. In addition, it describes how lists of values can be constrained by selections in other lists.

NOTE:  If you will be creating multilingual lists of values (MLOV), you should also review Configuring Siebel eBusiness Applications.

There are two views in the Administration - Data screen in which you can view list-of-values data:

  • In the List of Values view, a list view
  • In the LOV Explorer view

The values in these two views are the same. Only the format in which the information is presented is different. The procedures in this section give instructions that specify using the list view. If you prefer to use the explorer view, you may do so.

Your Siebel applications come with numerous lists of values that support the static picklists used throughout Siebel screens. You can use these as they are, or you can modify them through the list-of-values views to support your organization's requirements.

Applications Administration Guide