Configuration Guide for Siebel Offline Client for Life Sciences > Extending the Basic Content in the Sales Application > Process of Adding and Making Static Fields Available >

Finding the List of Values Name for the Picklist Field


This task is a step in Process of Adding and Making Static Fields Available. It is recommended that you locate the List of Values (LOV) for the picklist field using an SQLite database administrator tool. For more information about this tool, see Inspecting Data Sources and Databases.

To find the LOV name for the picklist field

  1. Synchronize the Sales application with Siebel CRM.
  2. Use an SQLite Database Administrator Tool to open the local database.
  3. Find and open the SYS_LOV table.
  4. Sort the LOVType column.
  5. Find the LOV type for the required field and note the name as shown, for example, in the following table.
    Product
    LOV Type for the Field

    Siebel CRM

    MR_MS

Configuration Guide for Siebel Offline Client for Life Sciences Copyright © 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices.