Touchstone 4.0 Database Documentation
tDefaultUserOption Table
Description

Stores the default non-catastrophe Loss analysis options. 

Properties
Creation Date5/31/2016 9:46 AM
File GroupPRIMARY
Text File GroupPRIMARY
System Object
Published for Replication
Rows2
Data Space Used8.00 KB
Index Space Used56.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key DefaultUserOptionSIDUnique system-generated sequential identifier for the default user options record.Integer4   
 BusinessUnitSID

Unique system-generated sequential identifier for the business unit record.

Integer4   
 AnalysisCurrencyExchangeRateSetSID

Unique system-generated sequential identifier for the currency exchange rate set record that used during the analysis.

For a complete list of records, see tCurrencyExchangeRateSet Table.

Integer4   
 AnalysisCurrencyCode

ISO 3-character code for the currency used during the analysis.

For a complete list of codes, see tCurrency Table.

Char3   
 ViewingCurrencyExchangeRateSetSID

Unique system-generated sequential identifier for the currency exchange rate set record used to display the results.

For a complete list of records, see tCurrencyExchangeRateSet Table.

Integer4  
 ViewingCurrencyCode

ISO 3-character code for the currency used to present the results.

For a complete list of codes, see tCurrency Table.

Char3  
 ResultDataSourceSID

Unique system-generated sequential identifier for the data source (database) in which the results are stored.

For a complete list of records, see tDataSource Table.

Integer4  
 ResultDataSourceNameName of the data source (database) in which the results are stored.VarChar255  
 IsInternationaGeocodingEnabled

Indicates whether geocoding of international locations in enabled.

  • 1 = Yes (enabled)
  • 0 = No (disabled)
Boolean1 
((0))
 
 GeocodeOption

XML string that defines the geocode option.  Used internally by Touchstone.

Xml16  
Check Constraints
NameDescriptionExpression
CKC_ISINTERNATIONAGEO_TDEFAULT 
([IsInternationaGeocodingEnabled]>=(0) AND [IsInternationaGeocodingEnabled]<=(1))
Objects that tDefaultUserOption depends on
 Database ObjectObject TypeDescriptionDep Level
tCurrencyExchangeRateSet tabletCurrencyExchangeRateSetTable

Stores information about the currency exchange rate sets available in Touchstone. 

Detailed information about the exchange rate for each currency is available in tCurrencyExchangeRateSetConversion Table.

2
tCurrencyExchangeRateSetConversion tabletCurrencyExchangeRateSetConversionTable

Stores detailed information about the exchange rate for each currency available in Touchstone. 

Information about the exchange rate sets is available in tCurrencyExchangeRateSet Table.

1
See Also

Related Objects

AIRUserSetting Database

 

 


AIR Client Confidential

© 2016. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact AIR Worldwide with questions or comments. For database questions. For documentation comments.