Document toolboxDocument toolbox

sp901_language_codes

Owned by Jason Andrew
Oct 02, 2024

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
Nullable
LANGUAGE_CODEnumber(2)n/a(error)
ISO_CODEvarchar2(10)n/a(error)
FIELD_IDvarchar2(100)n/a(error)

Keys

primary key (language_code)

Column Descriptions

FieldDescription
LANGUAGE_CODE

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

LANGUAGE_CODESP900.Description (in English)
0English
1German
2Turkish
3French
ISO_CODE

The ISO 639 code for the language.

LANGUAGE_CODEISO_CODELanguage
0enEnglish
1deGerman
2trTurkish
3frFrench
FIELD_IDA 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.