Share this page

# KNTA_LANGUAGES

This table stores mappings from language and locality codes used by the Oracle RDBMS to language and locality codes used by the Java VM. Currently, the mapping is always one-way, from the Oracle RDBMS to the Java VM. All information in this table are system data and must not be altered by the customer.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KNTA_USERS | USER_ID | CREATED_BY
KNTA_USERS | USER_ID | LAST_UPDATED_BY

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
LANGUAGE_ID | NOT NULL | NUMBER | System-generated identifier
CREATION_DATE | NOT NULL | DATE | Date record was created
CREATED_BY | NOT NULL | NUMBER | Identifier for the user who created the record
LAST_UPDATE_DATE | NOT NULL | DATE | Date record was last updated
LAST_UPDATED_BY | NOT NULL | NUMBER | Identifier for the user who last updated the record
NLS_LANG_CODE | NOT NULL | VARCHAR2(129) | A concatenation of Oracle NLS language and territory codes
ISO_LANG_CODE | NOT NULL | VARCHAR2(30) | An ISO language code recognized by the Java VM
ISO_COUNTRY_CODE | NULLABLE | VARCHAR2(80) | An ISO country code recognized by the Java VM
INSTALLED_LANGUAGE_FLAG | NOT NULL | VARCHAR2(1) | Indicates the Installation language of the product. Has a value to 'Y' for the installed language.
SYSTEM_LANGUAGE | NULLABLE | VARCHAR2(1) |
DEPLOYED | NULLABLE | VARCHAR2(1) |

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KNTA_LANGUAGES_U1 | UNIQUE | 1 | LANGUAGE_ID
KNTA_LANGUAGES_U2 | UNIQUE | 1 | NLS_LANG_CODE

## Sequences

This table uses no sequences.

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: