Skip to content
Autana Business Partners

List of Values & Picklists

Published on 2 min read

autanabp

List of values

The value lists entity is a fairly simple entity in Siebel and with very limited use of displaying values from the picklist.

  • Set of values to teach in a picklist;
  • Only the values in the list that have the Asset Flag selected are taught

The values in a list can be used in:

  • Picklists
  • Scripts
  • calculated fields
  • expressions

They are used for:

  • Comply with business rules
  • Facilitate data insertion
  • Facilitate future changes without having to touch code

Unify the way to represent the same value

  • Avoid mistakes
  • Avoid different ways of representing the same value

Picklist

It is what allows the user to choose a value from a list. A picklist can have a search specification to restrict the values in the List of values to be taught or a sort specification to indicate how the values in the list will be presented.

Types of Picklists

  • Static
    • Visible values by drop-down list
    • Displays values saved in table S_LST_OF_VAL
    • Based on the business component Picklist Generic or Picklist hierarchical
    • Values can be bounded or unbounded
    • Values do not change at run time
  • Dynamics
    • Values visible by pick applet
    • Displays values from any business component (to be chosen)
    • Dynamic values that depend on business component records
    • Values change at run time
  • Limited (bounded)
    • User can define a value from a range of predefined values
    • The user cannot, when choosing a value from the list, enter a value that suits him
    • An error is thrown when trying
  • Unbounded
    • User can define a value from a range of predefined values
    • User can insert other values that are not in the list

Picklist Generic

A simple picklist, it shows the value and has no dependencies. Example: MR_MS

Picklist Hierarchical

A picklist that has dependencies. There are values that depend on a parent value. Example: The Area and Subarea fields of the Service Request entity. They respectively have the picklists "PickList SR Area" and "PickList SR Hierarchical Sub-Area". The value of the Subarea field will show values that will depend on the value you choose in the Area field.

  • Why use a Hierarchical Picklist?
    • To better model the client's business needs
    • To restrict values based on other picklists or other values in the same picklist

Updated on

Tags

← Back to the blog

  • Data Management

    Optimization of energy consumption

    Discover how the optimization of energy consumption reduces costs and environmental impact. Learn to analyze data, simulate scenarios, and implement energy-saving strategies.

    Read article

  • Analytics

    Talent retention in the digital age: how analytics can help

    Learn how talent retention in the digital age benefits from analytics. Discover how data helps reduce turnover and retain your top employees.

    Read article

  • Success Stories

    Proyect Sourcing Optimization

    In the digital age, Project Sourcing Optimization has become essential for companies aiming to enhance their purchasing processes. By integrating data-driven decision-making and…

    Read article