Configuring Siebel eBusiness Applications > Creating and Administering Lists of Values >

About the Language Independent Code


The LOV table contains a Display Value column and a Language Independent Code column. Both monolingual and multilingual lists of values display values from Display Value column to the user. However, after the user selects a value in a picklist, the actual value stored in the database is different for monolingual and multilingual lists of values.

  • A monolingual picklist stores the Display Value.
  • A multilingual picklist stores the Language Independent Code.

For example consider the values in Table 53. A multilingual picklist would display the Display Value (Mr., Seņor, or Herr) depending on the active language of the user, but it would store the value Mr. in the database, because that is the value defined in the Language Independent Code column.

Table 53.  Example LIC
Display Value
Language Independent Code

Mr.

Mr.

Seņor

Mr.

Herr

Mr.

NOTE:  Generally the language-independent code value is the same as the American-English version of a particular selection value.

Storing the value from LIC column rather than the Display Value column allows the data to be stored in a form that users working in other languages are able to retrieve and allows the roll up of data for management reports, regardless of the language of the users who enter the data.

CAUTION:  The length of the language-independent code (the value stored in the database) must be equal to the longest display value for the MLOV. If it is not, the display value will be truncated. If the standard column does not meet your requirements and you are using a custom extension column, the column must be VARCHAR and have a maximum length (width) of 30.

Configuring Siebel eBusiness Applications