Touchstone 2022 Database Reference
tLocaleOverride Table
AIRUserSetting Database : tLocaleOverride Table
Description

Stores information used to override region and language settings defined within the computer's operating system.

Properties
Creation Date4/4/2022 3:02 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows0
Data Space Used0.00 KB
Index Space Used0.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key ModuleCodeUnique, system-generated code assigned to the module.varchar10   
 UseLocaleOverride

Indicates whether Touchstone should use the locale overrides.

  • 1 = Yes (use override)
  • 0 = No (do not use override)
bit1 
((0))
 
 UseDecimalSymbol

Indicates whether Touchstone should use the decimal symbol defined in DecimalSymbol.

  • 1 = Yes (use symbol)
  • 0 = No (do not use symbol)
bit1 
((0))
 
 DecimalSymbolSymbol that represents the decimal mark. Different countries officially designate different symbols for the decimal mark, for example a comma.nvarchar3  
 UseDecimalNumDigitsAfterDecimal

Indicates whether Touchstone should use value defined in DecimalNumDigitsAfterDecimal to present the number of digits after the decimal mark.

  • 1 = Yes (use value)
  • 0 = No (do not use value)
bit1 
((0))
 
 DecimalNumDigitsAfterDecimalRepresents the number of digits after the decimal mark.tinyint1  
 UseDecimalDigitGroupingSymbol

Indicates whether Touchstone should use the symbol defined in DecimalDigitGroupingSymbol to present the digit grouping.

  • 1 = Yes (use symbol)
  • 0 = No (do not use symbol)
bit1 
((0))
 
 DecimalDigitGroupingSymbolSymbol that represents the digit grouping.nvarchar3  
 UseDecimalDigitGrouping

Indicates whether Touchstone should use the digit grouping defined in DecimalDigitGrouping.

  • 1 = Yes (use grouping)
  • 0 = No (do not use grouping)
bit1 
((0))
 
 DecimalDigitGroupingRepresents the grouping of the digits, such as [123 456 789] or [12 34 56 789].nvarchar128  
 UseDecimalNegativeSignSymbol

Indicates whether Touchstone should use the symbol defined in DecimalNegativeSignSymbol. to present a negative value.

  • 1 = Yes (use symbol)
  • 0 = No (do not use symbol)
bit1 
((0))
 
 DecimalNegativeSignSymbolSymbol that represents the negative sign in a number.nvarchar4  
 UseDecimalNegativeNumberFormat

Indicates whether Touchstone should use the format defined in DecimalNegativeNumberFormat to present a negative value.

  • 1 = Yes (use format)
  • 0 = No (do not use format)
bit1 
((0))
 
 DecimalNegativeNumberFormatRepresents the format in which the negative sign is presented in a number, such as [-123] or [123].tinyint1  
 UseDecimalListSeparator

Indicates whether Touchstone should use the separator defined in DecimalListSeparator when listing numbers.

  • 1 = Yes (use separator)
  • 0 = No (do not use separator)
bit1 
((0))
 
 DecimalListSeparatorThe separator used between numbers in a list, such as a semicolon (123; 456) or comma (123, 456).nvarchar3  
 UseDecimalNativeDigits

Indicates whether Touchstone should use the native digits as indicated in DecimalNativeDigits.

  • 1 = Yes (use native digits)
  • 0 = No (do not use native digits)
bit1 
((0))
 
 DecimalNativeDigits

Represents when native digits are to be used.

nvarchar64  
 UseCurrencySymbol

Indicates whether Touchstone should use the symbol defined in CurrencySymbol when presenting financial values.

  • 1 = Yes (use symbol)
  • 0 = No (do not use symbol)
bit1 
((0))
 
 CurrencySymbolSymbol that represent the currency, such as € for Euro.nvarchar12  
 UseCurrencyPositiveFormat

Indicates whether Touchstone should use the format defined in CurrencyPositiveFormat to present a positive financial value.

  • 1 = Yes (use format)
  • 0 = No (do not use format)
bit1 
((0))
 
 CurrencyPositiveFormat

Represents the format in which a positive financial value is presented, such as [€123] or [123€].

tinyint1  
 UseCurrencyNegativeFormat

Indicates whether the negative currency format should be used.

  • 1 = Yes (use format)
  • 0 = No (do not use format)
bit1 
((0))
 
 CurrencyNegativeFormat

Represents the format in which a negative financial value is presented, such as [€-123] or [-123€].

tinyint1  
 UseCurrencyDecimalSymbol

Indicates whether Touchstone should use the decimal symbol defined in CurrencyDecimalSymbol to present the currency.

  • 1 = Yes (use symbol)
  • 0 = No (do not use symbol)
bit1 
((0))
 
 CurrencyDecimalSymbol

Symbol that represents the decimal mark in a financial value.

nvarchar3  
 UseCurrencyNumDigitsAfterDecimal

Indicates whether Touchstone should use value defined in CurrencyNumDigitsAfterDecimal to present the number of digits after the decimal mark.

  • 1 = Yes (use value)
  • 0 = No (do not use value)
bit1 
((0))
 
 CurrencyNumDigitsAfterDecimal

Represents the number of digits after the decimal mark.

tinyint1  
 UseCurrencyDigitGroupingSymbol

Indicates whether Touchstone should use the symbol defined in CurrencyDigitGroupingSymbol to present the digital groping.           

  • 1 = Yes (use symbol)
  • 0 = No (do not use symbol)
bit1 
((0))
 
 CurrencyDigitGroupingSymbol

Symbol that represents the digit grouping.

nvarchar3  
 UseCurrencyDigitGrouping

Indicates whether Touchstone should use the digit grouping defined in CurrencyDigitGrouping.

  • 1 = Yes (use grouping)
  • 0 = No (do not use grouping)
bit1 
((0))
 
 CurrencyDigitGrouping

Represents the grouping of the digits, such as [123 456 789] or [12 34 56 789].

nvarchar128  
 UseTimeFormatShort

Indicates whether Touchstone should use the format defined in TimeFormatShort when presenting time in short format.

  • 1 = Yes (use format)
  • 0 = No (do not use format)
bit1 
((0))
 
 TimeFormatShortRepresents the short format in which a time is presented, such as h:mm tt or HH:mm.nvarchar64  
 UseTimeFormatLong

Indicates whether Touchstone should use the format defined in TimeFormatLong when presenting time in long format.

  • 1 = Yes (use format)
  • 0 = No (do not use format)
bit1 
((0))
 
 TimeFormatLongRepresents the long format in which a time is presented, such as h:mm:ss tt or HH:mm:ss.nvarchar64  
 UseTimeAMSymbol

Indicates whether Touchstone should use value defined in TimeAMSymbol.

  • 1 = Yes (use symbol)
  • 0 = No (do not use symbol)
bit1 
((0))
 
 TimeAMSymbol

Represents the symbol used to represent the AM time period.

nvarchar12  
 UseTimePMSymbol

Indicates whether Touchstone should use value defined in TimePMSymbol.

  • 1 = Yes (use symbol)
  • 0 = No (do not use symbol)
bit1 
((0))
 
 TimePMSymbol

Represents the symbol used to represent the PM time period.

nvarchar12  
 UseDateFormatShort

Indicates whether Touchstone should use the format defined in DateFormatShort when presenting the date in short format.

  • 1 = Yes (use format)
  • 0 = No (do not use format)
bit1 
((0))
 
 DateFormatShort

Represents the short format in which the date is presented, such as M/d/yyyy or yyyy-MM-dd.

nvarchar64  
 UseDateFormatLong

Indicates whether Touchstone should use the format defined in DateFormatLong when presenting the date in long format.

  • 1 = Yes (use format)
  • 0 = No (do not use format)
bit1 
((0))
 
 DateFormatLong

Represents the long format in which the date is presented, such as dd MMMM, yyyy or  dddd, MMMM dd, yyyy.

nvarchar64  
 UseTwoDigitYearMax

Indicates whether Touchstone should the two-digit year format.

  • 1 = Yes (use format)
  • 0 = No (do not use format)
bit1 
((0))
 
 TwoDigitYearMax

When a two-digit year is used, this value represents the last year that the system will interpret. 

For example, if this value is 2029 but the user enters a two-digit year of "39", Touchstone will not interpreted "39" as a year.

smallint2  
 UseFirstDayOfWeek

Indicates whether Touchstone should use the day defined in FirstDayOfWeek as the start of the week.

  • 1 = Yes (use day
  • 0 = No (do not use day)
bit1 
((0))
 
 FirstDayOfWeekRepresents the first day of the week.tinyint1  
Check Constraints
NameDescriptionExpression
ck_tLocaleOverride_CurrencyNegativeFormat 
([CurrencyNegativeFormat] IS NULL OR [CurrencyNegativeFormat]>=(0) AND [CurrencyNegativeFormat]<=(15))
ck_tLocaleOverride_CurrencyNumDigitsAfterDecimal 
([CurrencyNumDigitsAfterDecimal] IS NULL OR [CurrencyNumDigitsAfterDecimal]>=(0) AND [CurrencyNumDigitsAfterDecimal]<=(9))
ck_tLocaleOverride_CurrencyPositiveFormat 
([CurrencyPositiveFormat] IS NULL OR [CurrencyPositiveFormat]>=(0) AND [CurrencyPositiveFormat]<=(3))
ck_tLocaleOverride_DecimalNegativeNumberFormat 
([DecimalNegativeNumberFormat] IS NULL OR [DecimalNegativeNumberFormat]>=(0) AND [DecimalNegativeNumberFormat]<=(4))
ck_tLocaleOverride_DecimalNumDigitsAfterDecimal 
([DecimalNumDigitsAfterDecimal] IS NULL OR [DecimalNumDigitsAfterDecimal]>=(0) AND [DecimalNumDigitsAfterDecimal]<=(9))
ck_tLocaleOverride_FirstDayOfWeek 
([FirstDayOfWeek] IS NULL OR [FirstDayOfWeek]>=(0) AND [FirstDayOfWeek]<=(6))
ck_tLocaleOverride_TwoDigitYearMax 
([TwoDigitYearMax] IS NULL OR [TwoDigitYearMax]>=(99) AND [TwoDigitYearMax]<=(9999))
See Also

Related Objects

AIRUserSetting Database

 

 

Verisk Analytics Client Confidential

© 2022. AIR Worldwide is now Extreme Event Solutions. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact Verisk Analytics with questions or comments.