Stores administrator-specified default currency rate settings.
Touchstone Re 2022 Database Reference
tDefaultUserOption Table
Stores administrator-specified default currency rate settings.
| Creation Date | 4/4/2022 3:02 AM |
| File Group | PRIMARY |
| Text File Group | PRIMARY |
| System Object |  |
| Published for Replication | |
| Rows | 3 |
| Data Space Used | 8.00 KB |
| Index Space Used | 56.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | DefaultUserOptionSID | Unique system-generated sequential identifier for the default user options record. | int | 4 | |||
| BusinessUnitSID | Unique system-generated sequential identifier for the business unit associated with the default options. | int | 4 | ||||
| AnalysisCurrencyExchangeRateSetSID | Unique system-generated sequential identifier for the default currency exchange rate set used during analysis. For a complete list of records, see tCurrencyExchangeRateSet Table. | int | 4 | ||||
| AnalysisCurrencyCode | ISO 3-character code for the default currency used during analyses. For a complete list of codes, see tCurrency Table. | char | 3 | ||||
| ViewingCurrencyExchangeRateSetSID | Unique system-generated sequential identifier for the default currency exchange rate set used to display results. For a complete list of records, see tCurrencyExchangeRateSet Table. | int | 4 |  | |||
| ViewingCurrencyCode | ISO 3-character code for the default currency used to display results. For a complete list of codes, see tCurrency Table. | char | 3 | | |||
| ResultDataSourceSID |
Not used by Touchstone Re. | int | 4 | | |||
| ResultDataSourceName | Not used by Touchstone Re. | varchar | 255 | | |||
| IsInternationaGeocodingEnabled | Not used by Touchstone Re. | bit | 1 | ((0)) | |||
| GeocodeOption | Not used by Touchstone Re. | xml | 0 | | |||
| ViewingCurrencyUnit | Code that represents the user-specified default units used to display currency values throughout the application. For a complete list of codes, see tCurrencyUnit Table. | tinyint | 1 | | ((1)) |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tCurrencyExchangeRateSet | Table | Stores information about the exchange rate sets available in the application. For more information about the currency exchange rate sets, see tCurrencyExchangeRateSetConversion Table. | 2 |
| tCurrencyExchangeRateSetConversion | Table | Stores information about the exchange rate set that corresponds to each currency in the application. For more information about the exchange rate sets, see tCurrencyExchangeRateSet Table. | 1 |