Stores information about aggregate loss analysis targets.

Stores information about the database version.

Stores annual exceedance probability losses for one analysis.

Touchstone Re creates one table for each analysis.

Stores annual exceedance probability losses for one analysis by peril.

For each year that generated loss, Touchstone Re creates multiple rows. Each row represents aggregate or occurrence losses for one financial perspective. If losses for a given financial perspective in a given year are zero, Touchstone Re does not generate a row for the losses.

Stores annual exceedance probability losses for one analysis by geographic zone.

For each year that generated loss, Touchstone Re creates multiple rows. Each row represents aggregate or occurrence losses for one financial perspective. If losses for a given financial perspective in a given year are zero, Touchstone Re does not generate a row for the losses.

Stores annual exceedance probability losses for one analysis by each combination of geographic zone and peril.

For each year that generated loss, Touchstone Re creates multiple rows. Each row represents aggregate or occurrence losses for one financial perspective. If losses for a given financial perspective in a given year are zero, Touchstone Re does not generate a row for the losses.

Stores annual exceedance probability summary losses for one analysis.

For each year that generated loss, Touchstone Re creates multiple rows. Each row represents one combination of financial perspective and aggregate EP, occurrence EP, aggregate TVAR, or occurrence TVAR. If losses for a given financial perspective in a given year are zero, Touchstone Re does not generate a row for the losses.

Stores annual exceedance probability summary losses for one analysis by each combination of geographic zone and peril.

For each year that generated loss, Touchstone Re creates multiple rows. Each row represents one combination of financial perspective and aggregate EP, occurrence EP, aggregate TVAR, or occurrence TVAR. If losses for a given financial perspective in a given year are zero, Touchstone Re does not generate a row for the losses.

Stores event losses for one analysis by company.

Touchstone Re creates one table for each analysis.

Stores event losses for one analysis by each combination of company and geography.

Touchstone Re creates one table for each analysis that includes Area or Subarea as an output option.

Stores event losses for one analysis by each combination of company, line of business (LOB), and geography.

Touchstone Re creates one table for each analysis that includes Geography and LOB as output options.

Stores event losses for one analysis by each combination of company, line of business (LOB), and zone.

Touchstone Re creates one table for each analysis that includes Geography and Zone as output options.

Stores event losses for one analysis by reinsurance portfolio.

Touchstone Re creates one table for each analysis that includes a reinsurance portfolio as the analysis target.

Stores event losses for one analysis by each combination of reinsurance portfolio, line of business (LOB), and geography.

Touchstone Re creates one table for each analysis that includes a reinsurance portfolio as the analysis target and LOB and Geography as output options.

Stores event losses for one analysis by each combination of reinsurance portfolio, line of business (LOB), and zone.

Touchstone Re creates one table for each portfolio analysis that includes a reinsurance portfolio as the analysis target and LOB and Zone as output options.

Stores event losses for one analysis by reinsurance program.

Touchstone Re creates one table for each analysis that includes a reinsurance program as the analysis target.

Stores event losses for one analysis by each combination of reinsurance program and geography.

Touchstone Re creates one table for each analysis that includes a reinsurance program as the analysis target and Geography as an output option.

Stores event losses for one analysis by each combination of reinsurance program and zone.

Touchstone Re creates one table for each analysis that includes a reinsurance program as the analysis target and Program and Zone as output options.

Stores event losses for one analysis by reinsurance treaty.

Touchstone Re creates one table for each analysis.

Stores average annual losses for one analysis by reinsurance treaty.

Touchstone Re creates one table for each analysis that includes a reinsurance portfolio as the analysis target.

Stores event losses for one analysis by each combination of reinsurance treaty and geography.

Touchstone Re creates one table for each analysis that includes Treaty and Geography as output options.

Stores event losses for one analysis by each combination of reinsurance treaty, line of business (LOB), and geography.

Touchstone Re creates one table for each analysis that includes Treaty, LOB, and Geography as output options.

Stores event losses for one analysis by each combination of reinsurance treaty, line of business (LOB), and zone.

Touchstone Re creates one table for each analysis that includesTreaty, LOB, and Zone as output options.

Stores information about each geography record that generated loss during a loss analysis. Touchstone generates the table only for analyses that a user transferred to Touchstone Re using the company loss association feature.

Stores information about the reinsurance treaties or layers that generated loss during a portfolio loss analysis. 

Touchstone Re creates one table for each portfolio loss analysis.

Stores information about the currency exchange rates associated with reinsurance treaties or layers during a portfolio loss analysis.

This table stores the user-provided currency option to save and export loss results.

Stores information about the reinsurance treaties that generated loss during a loss analysis. 

Touchstone Re creates one table for each analysis that includes Treaty as an output option.

Stores information about the reinsurance treaties and zones that generated loss during a loss analysis. 

Touchstone Re creates one table for each analysis that includes Treaty and Zone as output options.

Stores information about the Multi Peril Crop Insurance Model for the United States.

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. 

Stores the number of events associated with each combination of catalog type, model, and year included in a detailed loss analysis. Touchstone generates the table only for analyses that a user transferred to Touchstone Re using the company loss association feature.

During a company loss association, Touchstone writes information about a company loss file (CLF) set to the AIRCompanyLoss database and Touchstone Re associates the CLF set with a Touchstone Re company.

Stores results by treaty for one portfolio loss analysis 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.