14.1 sp901_language_codes

This table provides a list of UI languages offered by the system. These are referred to by the SP900_LANGUAGE_TRANSLATION table.

Table Definition

Field	Type	Default
`LANGUAGE_CODE`	`number(2)`	n/a
`ISO_CODE`	`varchar2(10)`	n/a
`FIELD_ID`	`varchar2(100)`	n/a

Keys

primary key (language_code)

Column Descriptions

Field Description

LANGUAGE_CODE

An integer primary key. The initial codes are the same as the historic values used in SP900.

LANGUAGE_CODE	SP900.Description (in English)
0	English
1	German
2	Turkish
3	French

ISO_CODE

The ISO 639 code for the language.

LANGUAGE_CODE	ISO_CODE	Language
0	en	English
1	de	German
2	tr	Turkish
3	fr	French

FIELD_ID A reference to rows in the SP900 table that give the name of the language. The FIELD_ID should start "SP901_DESC_" following by an integer key that identifies the translation row(s) in the SP900 table.