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