| Table | Description |
|---|
| tAggregateExposure | Stores aggregated exposure data. For example, one row in the table may specify the total insured value for a given subarea and line of business included in an exposure set. |
| tAppliesToArea | Stores the names of Applies to Area filters.
An Applies to Area filter specifies that a reinsurance treaty applies only to a given geographic area. |
| tAppliesToAreaGeoXRef | Stores the geography and ceded amount associated with each Applies to Area filter.
An Applies to Area filter specifies that a reinsurance treaty applies only to a given geographic area. |
| tAppliesToEventFilter | Stores information about event filters.
An event filter specifies that a reinsurance treaty applies only to events that meet certain criteria. You can create an event filter that includes event parameters, a latitude and longitude pair, or a list of areas. |
| tAppliesToEventFilterGeoXRef | Stores information about event filters that include geographic areas.
An event filter specifies that a reinsurance treaty applies only to events that meet certain criteria. You can create an event filter that includes event parameters, a latitude and longitude pair, or a list of areas. |
| tAppliesToEventFilterLatLong | Stores information about event filters that include latitude and longitude pairs.
An event filter specifies that a reinsurance treaty applies only to events that meet certain criteria. You can create an event filter that includes event parameters, a latitude and longitude pair, or a list of areas. |
| tAppliesToEventFilterRule | Stores information about event filters that include event parameters, such as earthquake depth or hurricane central pressure.
An event filter specifies that a reinsurance treaty applies only to events that meet certain criteria. You can create an event filter that includes event parameters, a latitude and longitude pair, or a list of areas. |
| tCatBondAttributeValue | Stores information about catastrophe bond reinsurance programs, for example, the sponsor and covered perils. |
| tCLFCatalog | Stores metadata about company loss files (CLF).
The metadata includes information about the event catalogs associated with each CLF. |
| tCompany | Stores information about companies. |
| tCompanyCLASizes | Stores information about the company loss file (CLF).
You can include the CLF information when you copy a company. |
| tCompanyLossAssociation | Stores relationships between company loss file (CLF) sets and companies.
You can associate a CLF set with a company in two ways:
- Importing the CLF set into Touchstone Re.
- Associating the CLF set with a Touchstone Re company when exporting the CLF set from Touchstone.
|
| tCompanyLossMarketShare | Stores loss market share information for company loss file (CLF) sets exported from Touchstone to Touchstone Re.
A loss market share represents a given company’s share of industry-wide losses. |
| tCompanyUDCClassification_Xref | Stores relationships between user-defined categories (UDCs) and companies. |
| tDbHistory | Stores information about any packages applied to the database. |
| tDBVersion | Stores information about the database version. |
| tPortfolio | Stores information about portfolios. |
| tPortfolioFilter | Stores information about portfolio filters. |
| tPortfolioReinsuranceTreaty | Stores information about reinsurance treaties or layers included in portfolios. |
| tProgramBusinessCategoryFactor | Stores coverage rates by crop line of business for each reinsurance program. |
| tReinsuraceLOBCountryOverride | Reserved for future use.
Stores relationships between countries and lines of business (LOB). |
| tReinsuranceEPCurve | This table stores information about the exceedance probability (EP) summary losses curve for reinsurance programs.
Touchstone Re generates this table during the time of conversion of EP summary losses to ULF for further analyses in Touchstone Re. |
| tReinsuranceEPCurveAdjustmentPoint | Stores information about the curve adjustment value generated at the time of conversion of EP to ULF files.
Touchstone Re generates this table to store the adjusted EP curve data after converting the exceedance probability loss summary to the user loss file format for the selected reinsurance program. |
| tReinsuranceEPCurveSet | Stores information about the input configuration of the exceedance probability (EP) summary loss curve.
Touchstone Re generates this table to store the EP curve set information including the unique identifier for the curve, user-provided reinsurance curve name, loss applies to area, and the associated perils for each EP curve. |
| tReinsuranceExposureAdjustmentFactor | Stores information about adjustment factors applied to exposure sets. |
| tReinsuranceProgram | Stores information about reinsurance programs. |
| tReinsuranceProgramCoverage | Stores the program coverages for each crop type applied to the Multiple Peril Crop Insurance (MPI) in China model. |
| tReinsuranceProgramEPAdjustment | Stores the EP (exceedance probability curve) adjustment options specified for each reinsurance program.
For each reinsurance program, you can specify model-specific EP adjustments. An EP adjustment is an amount or percentage that Touchstone Re uses to recalculate the EP curve during a loss analysis. EP adjustments apply to ground-up program losses.
For more information, refer to Touchstone Re Online Help on AIR's Client Portal. |
| tReinsuranceProgramEPAdjustmentPoints | Stores the EP (exceedance probability curve) adjustment values specified for each reinsurance program.
For each reinsurance program, you can specify model-specific EP adjustments. An EP adjustment is an amount or percentage that Touchstone Re uses to recalculate the EP curve during a loss analysis. EP adjustments apply to ground-up program losses.
For more information, refer to Touchstone Re Online Help on AIR's Client Portal. |
| tReinsuranceProgramJapanCFLRatio | Stores information about the event sets and the corresponding prefecture ratios.
Touchstone Re generates this table to calculate custom first loss in 10k event catalogs. The system validates the user-provided prefecture ratios and then automatically maps the event set with a closest first loss perspective.
|
| tReinsuranceProgramSourceInure | Stores information about the sourcing and inuring relationships between reinsurance programs. |
| tReinsuranceProgramTargetXRef | Stores the company loss file (CLF) set or CLF set and exposure set combination specified as the target of each reinsurance program. |
| tReinsuranceTreaty | Stores information about reinsurance treaties included in reinsurance programs. |
| tReinsuranceTreatyReinstatement | Stores information about reinstatement treaties included in reinsurance programs. |
| tReinsuranceTreatySavedResults | Stores information about portfolio loss analysis results saved to the Analyze Re cloud.
When you configure a portfolio loss analysis, you can optionally enable Touchstone Re to upload the results of the analysis to the Analyze Re cloud, and then use the results to speed up future analyses.
Touchstone Re uploads loss results by treaty. |
| tReinsuranceTreatyTerrorismOption | Stores information about the terrorism coverage for each reinsurance treaty. |
| tReinsuranceTreatyUDCClassification_Xref | Stores relationships between user-defined categories (UDCs) and reinsurance treaties. |
| tSIDControl | Contains a list of all SID tables and the last SID value in use for each table. After each insert operation, Touchstone Re updates the SID value. |
| tUpgradeLog | Stores information about upgrade scripts. |
| tUpgradeOption | Stores information about database upgrades. |
