Touchstone 4.0 Database Documentation
tCurrencyExchangeRateSet Table
Description

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.

Properties
Creation Date5/31/2016 9:46 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows4
Data Space Used8.00 KB
Index Space Used56.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key CurrencyExchangeRateSetSIDUnique system-generated sequential identifier for the exchange rate set record.Integer4   
 BusinessUnitSID

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

Integer4   
 BaseCurrencyCode

ISO 3-character code for the base currency used with the exchange rate set.

For a complete list of codes, see tCurrency Table.

Char3   
 CurrencyExchangeRateSetName of the currency exchange rate set.VarChar40   
 IsAIRStandard

Indicates whether the exchange rate set has been designated as "standard".

  • 1 = Yes (standard
  • 0 = No (not standard)
Boolean1 
((0))
 
 DescriptionDescription of the currency exchange rate set.VarChar4000  
 EnteredDateDate and time when the currency exchange rate set was created.VarWChar10 
(getutcdate())
 
 EditedDateDate and time when the currency exchange rate set was last modified.VarWChar10 
(getutcdate())
 
Check Constraints
NameDescriptionExpression
CKC_ISAIRSTANDARD_TCURRENC 
([IsAIRStandard]>=(0) AND [IsAIRStandard]<=(1))
Objects that depend on tCurrencyExchangeRateSet
 Database ObjectObject TypeDescriptionDep Level
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
tDefaultUserOption tabletDefaultUserOptionTable

Stores the default non-catastrophe Loss analysis options. 

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.