| Table | Description |
|---|
| tCatBondAttribute | Stores the attributes that users in each business unit can specify for catastrophe bond reinsurance programs, for example, the sponsors or covered perils.
Currently, Touchstone Re supports only one business unit.
|
| tCurrencyExchangeRateSet | Stores information about the exchange rate sets available in the application.
For more information about the currency exchange rate sets, see tCurrencyExchangeRateSetConversion Table. |
| tCurrencyExchangeRateSetConversion | 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. |
| tCustomLOB | Stores the custom (administrator-defined) lines of business (LOB) that are available for each country. Additionally, the table stores the AIR LOB that corresponds to each custom LOB.
You must license Custom Models and LOBs to use the custom LOB feature. |
| tDbHistory | Stores information about any packages applied to the database. |
| tDBVersion | Stores the version of the database. |
| tDefaultAppliesToArea | Stores the names of user-specified default Applies to Area definitions.
An Applies to Area definition specifies the country, area, or subarea that a reinsurance treaty or layer applies to. A default Applies to Area definition applies to every reinsurance treaty or layer in a business unit. |
| tDefaultAppliesToAreaGeoXref | Stores the country, area, or subarea associated with each Applies to Area definition.
An Applies to Area definition specifies the country, area, or subarea that a reinsurance treaty or layer applies to. A default Applies to Area definition applies to every reinsurance treaty or layer in a business unit. |
| tDefaultDatabaseOption | Stores administrator-defined prefixes for the AIRResultRe and AIRExposureRe databases.
You define the prefixes in the Business Unit Management section of the Administration Console. The application automatically prepends the prefixes to any user-specified database names. |
| tDefaultEnterpriseOption | Stores administrator-specified default values for each business unit. For example, an administrator can specify that the demand surge option is enabled by default for all analyses in a given business unit.
The application uses the values to pre-fill fields. However, users can optionally override the default values.
The application stores additional defaults in tDefaultUserOption Table. |
| tDefaultLossAnalysisOption | Stores default loss analysis options, such as the EP points to include in the analysis results. |
| tDefaultTerrorismOption | Stores the administrator-defined default terrorism option for loss analyses. |
| tDefaultUserOption | Stores administrator-specified default currency rate settings. |
| tDemandSurge | Stores information about the standard demand surge curves that are available in Touchstone Re.
For information about the custom, user-specified demand surge function, see tDemandSurgeFunction Table. |
| tDemandSurgeFunction | Stores information about custom, administrator-specified demand surge functions.
For information about the AIR-provided demand surge curves, see tDemandSurge Table. |
| tEventBasedAdjFactorFile | Stores information about the comma-separated values (CSV) files used to specify event-based adjustment factors in the Administration Console.
An event-based adjustment factor enables you to adjust ground up modeled loss estimates. You can specify event-based adjustment factors for each event or each combination of event, area, and line of business associated with a given model.
You must license event-based adjustment factors to use the event-based adjustment factors feature. |
| tEventBasedAdjFactorSet | Stores the details of each set of event-based adjustment factors defined in the Administration Console.
An event-based adjustment factor enables you to adjust ground up modeled loss estimates. You can specify event-based adjustment factors for each event or each combination of event, area, and line of business associated with a given model.
You must license event-based adjustment factors to use the event-based adjustment factors feature. |
| tIndiaMPCICluster | Stores information about each cluster defined in the Administration Console for the Multiple Peril Crop Insurance (MPCI) Model for India. A cluster is a government-defined group of districts created to smooth out the risk to crop insurance providers.
The geographic information in the table is specific to the MPCI peril. |
| tIndiaMPCIClusterSet | Stores information about each cluster set defined in the Administration Console for the Multiple Peril Crop Insurance (MPCI) Model for India. A cluster set is a collection of government-defined group of districts created to smooth out the risk to crop insurance providers.
The geographic information in the table is specific to the MPCI peril. |
| tIndiaMPCIFactors | Stores information about the state-to-district disaggregation factors defined in the Administration Console for the Multiple Peril Crop Insurance (MPCI) Model for India.
Touchstone Re uses disaggregation factors to disaggregate state- or cluster-level exposure data to the district level. |
| tIndiaMPCIFactorSet | Stores information about the sets of state-to-district disaggregation factors defined in the Administration Console for the Multiple Peril Crop Insurance (MPCI) Model for India.
Touchstone Re uses disaggregation factors to disaggregate state- or cluster-level exposure data to the district level. |
| tModelInfo | Stores information about the models available in the application. |
| tObject | Stores information about the widget and template objects available in the application. |
| tReinsuranceCatalog | Stores information about the event catalogs that are available in Touchstone Re, including event catalogs for custom (user-defined) models.
You must license Custom Models and LOBs to use the custom models feature.
|
| tReinsuranceEventSet | Stores information about the event sets that are available in Touchstone Re, including event sets associated with custom (user-defined) models.
You must license Custom Models and LOBs to use the custom models feature.
|
| tReinsuranceEventSetCatalogXRef | System reference table that stores the event catalogs associated with each event set in Touchstone Re, including event sets associated with custom (user-defined) models.
You must license Custom Models and LOBs to use the custom models feature.
|
| tReinsuranceEventSetMapEx | System reference table that stores the event sets associated with each parent event set.
A parent event set is a superset of an event set. |
| tReinsuranceIndustryRate | Stores administrator-specified per-life premium rates for the pandemic peril. |
| tReinsuranceModelPeril | Stores the peril or perils associated with each model in Touchstone Re. |
| tSIDControl | Contains a list of all SID tables and the last SID value in use for each table. After each insert operation, the SID value will update. |
| tUDCClassification | Stores the user-defined classifications that Touchstone Re administrators have defined for Touchstone Re.
A user-defined classification is a criterion that you can use to identify reinsurance companies or programs. User-defined classifications are grouped in user-defined categories. |
| tUpgradeLog | Stores information about upgrade scripts. |
| tUserDefinedCategory | Stores the user-defined categories (UDCs) that Touchstone Re administrators have defined for Touchstone Re.
User-defined classifications are grouped in user-defined categories. |
| tUserDefinedEvxEventInfo | Stores information about the events in each user-defined event set. |
| tUSMPCIGroupAssignments | Stores the government-specified and user-specified Standard Reinsurance Agreement (SRA) group numbers associated with each U.S. (United States) state.
Touchstone Re uses the group assignments to apply SRA sharing ratios during loss analyses that include the Multiple Peril Crop Insurance (MPCI) Model for the United States. |
| tUSMPCIIndPremium | Stores Multiple Peril Crop Insurance (MPCI) industry premiums associated with each state in the United States (U.S.) for each supported version of the MPCI Model for the U.S.
Default industry premiums are based on government-reported premium amounts. The table also stores user-specified custom percentages that the application can apply to the default industry premiums.
Touchstone Re stores premiums for each of the three MPCI funds (BuyUp, Cat, and Revenue) and applies the premiums and custom percentages during loss analyses that include the MPCI Model for the U.S. |
| tUSMPCISRAInsurer | Stores the AIR-default and user-specified Standard Reinsurance Agreement (SRA) loss sharing percentages for policies in the assigned risk fund and the SRA-state-group-specific commercial funds.
Touchstone Re uses the loss sharing percentages during loss analyses that include the Multiple Peril Crop Insurance (MPCI) Model for the United States. |
