Internal values
Internal values are used when consistent or literal strings are required, for example, in a workflow condition, a static filter in a system report, or a formula. Internal values are stored in the main storage table, also named the T_ table.
The internal value determines the value that is displayed in forms and reports when a translation is not available for the user language. For example, the internal values are written in Brazilian Portuguese and French is a secondary language. A French user views a record, and the description field does not have a French translation. The Brazilian Portuguese value of the field is displayed. In another example, a French user views a field that does not have French translation, and the value of this field was included with IBM® TRIRIGA®. The text displays the internal value which is created in the default language, US English.
The internal values of the application records that are included with IBM TRIRIGA are in US English, which is the default base language. If a record is created, the first value is stored in the main storage table. Subsequent values are stored in the main storage or language tables according to the rules outlined in the following table:
| Base language | User language | Data storage and display |
|---|---|---|
| US English | US English | The main table (T_). |
| US English | Not US English (for example, Italian) | The language table (L_) where the LANGUAGE_ID column corresponds to the language ID of the user. |
| Not US English | US English | The language table (L_) where the LANGUAGE_ID column is 1. |
| Not US English | Not US English | The language table (L_) where the LANGUAGE_ID column corresponds to the language ID of the user. |
Users who are not administrators can update internal values only if the base language and the user language are US English.
Administrator users can also import internal values by using the following tools:
- Object Migration (OM) tool
- When the OM package contains records, and those records are imported using the OM tool, the values of those records are saved to the T_ tables. Values that are imported from the OM package become the internal values regardless of the base language or the user language.
- DataConnect
- When the DC_JOB process is run by a US English user and the base language is US English, the data is imported into internal values.