Localization tables in the database

PolicyCenter stores the localized values for columns that have a localization element in separate localization tables in the database. PolicyCenter generates localization tables automatically. Guidewire recommends that you use the following format for the table name attribute. 

mainEntityNameAbbrevation_columnNameAbbreviation_l10n
Important: The length of the table name must not exceed 16 characters.

For example, the localization table name for the Subject column of the ActivityPattern entity uses the abbreviation actpat for the main entity and sbj for the column name: 

actpat_sbj_l10n

Localization tables have the following columns:

  • Owner – An integer that represents an ID of the owner
  • Language – A typekey to the LanguageType typelist
  • Value – A column of type String

Localization tables contain localized values for configured languages other than the default application language. The localized column itself contains values for the default application language.