Share this page

# KNTA_USER_REGIONAL_SETTINGS

This table stores regional settings for each user. These regional settings indicates the formats in which the user would see dates/time and numbers as well as the Language and Region Settings (Locale) of the user.

## Foreign Keys

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

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
USER_REGIONAL_SETTINGS_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
ENTITY_LAST_UPDATE_DATE | NOT NULL | DATE | Date a record in the entity was last updated
USER_ID | NOT NULL | NUMBER | Indicates the user associated with these regional settings
DEFAULT_SETTING_FLAG | NOT NULL | VARCHAR2(1) | Determines whether the user has his default settings checked
SHORT_DATE_FORMAT_CODE | NULLABLE | VARCHAR2(50) | Determines the user's short date pattern preference
MEDIUM_DATE_FORMAT_CODE | NULLABLE | VARCHAR2(50) | Determines the user's medium date pattern preference
LONG_DATE_FORMAT_CODE | NULLABLE | VARCHAR2(50) | Determines the user's long date pattern preference
DATE_SEPARATOR_CODE | NULLABLE | VARCHAR2(10) | Determines the user's date separator preference
HOUR_STYLE_FORMAT_CODE | NULLABLE | VARCHAR2(50) | Determines the user's hour style preference
AM_SYMBOL | NULLABLE | VARCHAR2(10) | Determines the user's am symbol preference
PM_SYMBOL | NULLABLE | VARCHAR2(10) | Determines the user's pm symbol preference
TIME_SEPARATOR | NULLABLE | VARCHAR2(10) | Determines the user's time separator preference
DECIMAL_SYMBOL | NULLABLE | VARCHAR2(10) | Determines the user's decimal symbol preference
NUM_DIGITS_IN_GROUP | NULLABLE | NUMBER | Determines the user's number of digits in a group preference
DIGIT_GROUP_SYMBOL | NULLABLE | VARCHAR2(10) | Determines the user's Digit Group Symbol
PERCENTAGE_SYMBOL | NULLABLE | VARCHAR2(10) | Determines the user's Percent Symbol
LANGUAGE_FORMAT_CODE | NULLABLE | VARCHAR2(10) | Determines the user's ISO language code used to format dates/time and numbers
REGION_FORMAT_CODE | NULLABLE | VARCHAR2(10) | Determines the user's ISO Region code used to format dates/time and numbers
LANGUAGE_CODE | NULLABLE | VARCHAR2(10) | Indicates the user's ISO Language code that is used as the language of display
REGION_CODE | NULLABLE | VARCHAR2(10) | Indicates the user's ISO Region code that determines the Region of the user which is used to determine the users locale
DISPLAY_LANGUAGE | NULLABLE | VARCHAR2(10) |
FORMAT_DISPLAY_LANGUAGE | NULLABLE | VARCHAR2(120) |
FORMAT_DISPLAY_TERRITORY | NULLABLE | VARCHAR2(120) |

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KNTA_USER_REGIONAL_SETTINGS_U1 | UNIQUE | 1 | USER_REGIONAL_SETTINGS_ID
KNTA_USER_REGIONAL_SETTINGS_U2 | UNIQUE | 1 | USER_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
KNTA_USER_REGIONAL_SETTINGS_S | USER_REGIONAL_SETTINGS_ID

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: