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. 

AIRResultRe.dbo.tDimReCurrencyExchangeRateSetConversion

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 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.

This table stores information about the exceedance probability (EP) summary losses curve for reinsurance programs.

Touchstone Re generates this table at the time of conversion of EP summary losses to ULF for further analyses in Touchstone Re. The system can run a single or multiple loss curves at a time.

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.

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. In addition, Touchstone Re generates the following intermediate template tables in AIRWork (proprietary) database when you submit an EP to ULF conversion activity. After conversion, these template tables are no longer available in the database.

Stores information about the reinsurance program option specified at the time of an aggregate loss analysis.

AIR has updated the event sets to stay abreast with the government of Japan's decision to define areas by prefecture. AIR has enhanced the industry loss files to include events sets in the Industry Exposure Database (IED), added three new events for the historical catalog, revised policy conditions for residential and reinsurance terms, created the ability to select seismicity source for the event sets, and updated prefecture boundaries for the exposure and loss maps.

Stores information about Take-up rates for industry loss and exposure data for a reinsurance program. 

Take-up rates are the percentage of insurable properties that are actually insured.

The loss files packaged in Touchstone include total insurable loss for each modeled event. To derive insured loss, AIR estimates the percentage of risks covered by peril, by line of business, and by geographic location, then apply this estimate to the insurable loss values. These estimates are called take-up rates.

Take-up rates can be entered manually in the Exposures screen, Market Shares tab or brought in from a UNICEDE file.

Stores information on whether loss is disaggregated at the area or subarea or by line-of-business (LOB) level. AIR has added a new 'AreaDetail' column to the company loss catalog to identify the disaggregation of loss.

AIRReference.dbo.tActivityType

AIR has implemented two new activity types for the exceedance probability(EP) and event loss to ULF features. When you initiate a job for converting an EP or ELT to ULF, Touchstone Re triggers the appropriate activity type code.

• EPTOULF = EP To ULF Import
• EVTLOSSULF = Event Loss to ULF Import

AIR has implemented the PRE, PRO, and POST activity phases for the event-level losses to ULF and exceedance probability (EP) to ULF features.

• EVTLOSSULF = PRE:   15
• EVTLOSSULF = PRO:   75
• EVTLOSSULF = POST: 10

• EPTOULF = PRE: 15
• ELTOULF = PRO: 75
• EPTOULF = POST: 15

AIRResultRe.dbo

• tRRRR_LOSS_AnnualEP_Peril
• tRRRR_LOSS_AnnualEP_Zone
• tRRRR_LOSS_AnnualEP_ZonePeril
• tRRRR_LOSS_ByReAnnualEP_Peril
• tRRRR_LOSS_ByReAnnualEP_Zone
• tRRRR_LOSS_ByReAnnualEP_ZonePeril
• tRRRR_LOSS_ByReCompany
• tRRRR_LOSS_ByReCompanyGeo
• tRRRR_LOSS_ByReCompanyLOBGeo
• tRRRR_LOSS_ByReCompanyLOBZone
• tRRRR_LOSS_ByRePortfolio
• tRRRR_LOSS_ByRePortfolioLOBGeo
• tRRRR_LOSS_ByRePortfolioLOBZone
• tRRRR_LOSS_ByReProgram
• tRRRR_LOSS_ByReProgramGeo
• tRRRR_LOSS_ByReProgramZone
• tRRRR_LOSS_ByReTreaty
• tRRRR_LOSS_ByReTreatyGeo
• tRRRR_LOSS_ByReTreatyLOBGeo
• tRRRR_LOSS_ByReTreatyLOBZone

AIR has implemented 'Day of Year' in loss tables, which is maintained in the AIRResultsRe database. For example, when a date is specified during a loss analysis, the loss tables stores the corresponding date in the 'DayID' column. This date is used to apply order of application of aggregate terms, and the distribution of events across each year in the catalog.

AIR has made the following changes to several loss-specific tables:                               

• Removed the 'MultiYearIterationID' column.
• Added the 'DayID' column.

Stores information about upgrade scripts.

Added in several databases.

Stores information about database upgrades associated with the company loss association (CLA) records.

The Touchstone Re company upgrade process will now support both legacy and the latest geographies and its corresponding line of business for each company loss file (CLF). The UI update is in conjuction with Model 27 update for Carribean countries where a peril could span across multiple countries. For example, a peril could start from the Florida coastline and then traverse across various Caribbean countries.

The tCLAUpgradeLog table stores old and new area information for each CLF record. Enabling you to track the legacy and new geographies as well as the line of businesses before and after the database upgrade for the company loss files.

Stores information about each upgrade activity, including the unique sequential identifiers and duration of upgrade for CLA records.

When CLA upgrade runs in parallel, Touchstone Re generates the tCLAUpgradeLogTiming table to record the performance of the upgrade. The Touchstone Re Company Import upgrade enables you to copy specific CLF for a selected company or automatically copy all the CLFs available in the source folder. Touchstone Re generates the CLAUpgradeLogTiming table to monitor the performance of CLA upgrade process. You can use the information in the table to analyze the duration and results of upgraded records.

Stores information about reinstatement treaties included in reinsurance programs.

The TblConiditon table in Catrader stores the same reinstatement provision for all reinstatements. Whereas, Touchstone Re 8.0 generates the tReinsuranceTreatyReinstatement table to store reinstatement provision for each reinstatement record. During migration of Catrader data to Touchstone Re, the reinstatement provisions stored in the TblCondition table is transferred to tReinsuranceTreatyReinstatement table.

Stores mapping between AM Best lines of business (LOBs) supported in Touchstone Re and LOBs supported in AIR's Industry Exposure Database.

The AM Best premium database contains information that you can use to derive and calculate market shares. To produce the database, AM Best compiles data from the year-end annual reports of more than 2,000 companies. If you license the AM Best premium database, you can access the database from Touchstone Re.

Stores encoded industry exposure data for the calendar year 2019.

[AIRReference].[dbo].[tActivityType]

New activity type codes:

[tDbHistory] for all databases

Added columns IsIgnorable, IsRolledBack, RolledBackScript for several databases:

• [AIRCompanyLoss].[dbo].[tDbHistory]
• [AIRExposureRe].[dbo].[tDbHistory]
• [AIRGeography].[dbo].[tDbHistory]
• [AIRDBAdmin].[dbo].[tDbHistory]
• [AIRGlobalSetting].[dbo].[tDbHistory]
• [AIRReference].[dbo].[tDbHistory]
• [AIRIndustry].[dbo].[tDbHistory]
• [AIRProject].[dbo].[tDbHistory]
• [AIRResultRe].[dbo].[tDbHistory]

Added the following rows:

Added the following rows:

Added the following rows:

Added the following columns:

• IsCustomLOBOn
• CoversCustomLOB
• DefaultClusterSetSID
• Reinstatements
• Reinsurance Premiums
• AmountProvision
• TimeProvision
• CoversChinaMPCIBarley
• CoversChinaMPCIPeanut
• CoversChinaMPCIPotato
• CoversChinaMPCISugar
• CoversChinaMPCIRubber
• CoversChinaMPCIDairyCattle
• CoversChinaMPCIOtherCattle
• CoversChinaMPCIBreederSow
• CoversChinaMPCIPig
• CoversChinaMPCIPoultry
• CoversChinaMPCISheep
• CoversChinaMPCILivestock

Removed column:

• IsMarketTrendOn

Removed tables:

• TblIndustry2013
• TblIndustry2014

Temporarily stores metadata that Touchstone uses to generate company loss files (CLFs). Touchstone creates the table prior to generating the CLFs. The metadata comes from the corresponding tCLEXPORT_NNNN_AAAA, tCLEXPORT_MAOL_NNNN_AAAA, and tCLEXPORT_TREATY_TTTT_NNNN_AAAA tables, where:

• NNNN represents the acitivity SID (sequential identifier). You can use the activity SID to view the log for the export job in the Touchstone Activity Monitor.
• AAAA represents the analysis SID. You can use the analysis SID to view the analysis options associated with the exported data in tCLEXPORT_LossAnalysisOption Table.
• TTTT represents the treaty name.

For example, for each batch of 100,000 loss records, the table specifies the number of events, year range, model code, and catalog type of the associated loss records in the corresponding tCLEXPORT_NNNN_AAAA instance.

After Touchstone generates the CLFs, the application deletes the table.

System table, used internally by the system to apply packages.

Stores information about the packages applied to the environment.

During system events such as register or upgrade events, the system uses the information in the table to determine whether a package applies to a target database.

Stores the SQL scripts that comprise packages.

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.

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.

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.

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.

Stores values used to disaggregate program data in China from the province (area) or city level to a higher resolution. The values are based on weighted averages developed using AIR's Industry Exposure Database.

For example, Touchstone Re uses the ratios supplied in the table to disaggregate premiums, define limits and retentions by county or city, and so on.

Stores values used to disaggregate exposures in China from the province (area) or city level to the county (subarea) level. The values are based on weighted averages developed using AIR's Industry Exposure Database.

For example, Touchstone Re may multiply the total exposure for each province, peril, and line of business by the ratios supplied in the table to determine the portion of the exposure to associate with each county. How Touchstone Re computes exposure depends on whether a user excluded any provinces or cities from the computation.

Stores geographic information that Touchstone Re uses to support the Multiple Peril Crop Insurance (MPCI) Model for India. For example, the table stores the areas and subareas that the model supports.

The geographic information in the table is specific to the MPCI peril.

In the Exposure Set pane of the Touchstone Re user interface, India is listed as two countries: India and India Crop. For India, Touchstone Re uses the geographical information in tGeography Table. For India Crop, Touchstone Re uses the geographic information in tIndiaCropGeography Table.

Stores information about the clusters supported in 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.

The geographic information in the table is specific to the MPCI peril.

Stores information about the state-to-district disaggregation factors supported in 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.

Stores information about the sets of state-to-district disaggregation factors supported in 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.

Stores the AIR lines of business (LOBs) that you can associate with custom (administrator-defined) LOBs.

You define custom LOBs for each country in the Administration Console. You must license Custom Models and LOBs to use the custom LOB feature.

Stores the supported types of event-based adjustment factor files.

You specify event-based adjustment factors in comma-separated values (CSV) files. An event-based adjustment factor file may contain factors for each event or each combination of event, area, and line of business associated with a given model.

Stores the lines of business supported for the Multiple Peril Crop Insurance (MPCI) Model for India by country, exposure type, and growing season.

Stores codes that represent the types of scaling methods that Touchstone Re uses to apply EP (exceedance probability curve) adjustments.

A scaling method dictates how Touchstone Re restores the monotonicity of an EP curve after applying program-specific EP adjustments.

Stores codes that represent types of values associated with the Multiple Peril Crop Insurance (MPCI) Model for the United States (U.S.).

For example, Touchstone Re stores the government-specified and user-specified Standard Reinsurance Agreement (SRA) group numbers associated with each U.S. (United States) state in the tUSMPCIGroupAssignments Table. In the context of the table, the USMPCITypeCode indicates whether the group number in a given row is government specified or user specified.

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 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 transfered 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.

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.

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.

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.

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.                

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.

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.

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.

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.

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.

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.

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.

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. 

Added columns: CustomLOBOptionCode, EPAdjustmentOptionCode, EventBasedAdjFactorSetSID, IsSeismic, IsUseSavedResults

Removed columns: AdjustmentFactFileSet and CustomLOB

New activity types:

• CEDEIMPORT = CEDE import
• CMP_EXPORT = Touchstone Re company export
• CMP_IMPORT = Touchstone Re company import                 
• DFF_EXPORT = Damage Factor File (DFF) export
• DFF_GEN = DFF sample generation
• DFF_IMPORT = DFF import
• EBAF_DWNLD = Event-Based adjustment factor (EBAF) download
• EBAF_EXP = EBAF Export
• EBAF_IMP = EBAF Import
• LMS = Loss market shares

New stages to support new activity types.

Modified PLA flags:

• 0 = PLA Program Specific
• 1 = PLA On
• 2 = PLA Off

New aggregate data type:

• CUTSUMS = Custom Sums Insured

New aggregate exposure type:

• 21 = C (Custom Sums Insured)

New analysis target type:

• CATLOSS = Standalone CAT loss treaty

Added the following rows:

Added the following row:

Added the following row:

New industry line of business for New Zealand:

• 5

Added the following rows:

New currency:

• VES = Venezuelan Bolivar Soberano

Added the following rows:

New export type:

• CMP_EXPORT = Touchstone Re Company Export

New exposure type:

• C = Custom Sums Insured

New models:

• 87 = AIR Multiple Peril Crop Insurance Model for India
• 89 = AIR Multiple Peril Crop Insurance Model for Canada

Added column: IsPreviousVersionModel

Added new peril sets for models 1, 7, 41, 53, 81, 85, 86, 93, and 95.

Added column: IsPreviousVersionModel

New model and country combinations:

Added the following rows:

New object type:

• EBAF_FILE_SET = Event-Based Adjustment Factor Set

New perils:

• HL = Hail
• LQ = Liquefaction
• TD = Tornado

Added column: CoversLiquefaction

Added and modified peril sets to account for new and updated models.

Added and modified rows to account for new and updated models.

New lines of business:

• 209 = MPCI Kharif Rice
• 210 = MPCI Kharif Rice Irrigated
• 211 = MPCI Kharif Rice Rainfed
• 212 = MPCI Kharif Cotton
• 213 = MPCI Kharif Cotton Irrigated
• 214 = MPCI Kharif Cotton Rainfed
• 215 = MPCI Kharif Soybean
• 216 = MPCI Kharif Soybean Irrigated
• 217 = MPCI Kharif Soybean Rainfed
• 218 = MPCI Kharif Maize
• 219 = MPCI Kharif Maize Irrigated
• 220 = MPCI Kharif Maize Rainfed
• 221 = MPCI Kharif Peanut 
• 222 = MPCI Kharif Peanut Irrigated
• 223 = MPCI Kharif Peanut Rainfed
• 224 = MPCI Kharif Pearl Millet
• 225 = MPCI Kharif Pearl Millet Irrigated
• 226 = MPCI Kharif Pearl Millet Rainfed
• 227 = MPCI Kharif Other
• 228 = MPCI Rabi Wheat
• 229 = MPCI Rabi Wheat Irrigated
• 230 = MPCI Rabi Wheat Rainfed
• 231 = MPCI Rabi Rice
• 232 = MPCI Rabi Rice Irrigated
• 233 = MPCI Rabi Rice Rainfed
• 234 = MPCI Rabi Chickpea
• 235 = MPCI Rabi Chickpea Irrigated
• 236 = MPCI Rabi Chickpea Rainfed
• 237 = MPCI Rabi Sorghum
• 238 = MPCI Rabi Sorghum Irrigated
• 239 = MPCI Rabi Sorghum Rainfed
• 240 = MPCI Rabi Mustard
• 241 = MPCI Rabi Mustard Irrigated
• 242 = MPCI Rabi Mustard Rainfed
• 243 = MPCI Rabi Other
• 249 = LOB Residential Land
• 251 = MPCI Barley
• 252 = MPCI Blueberry
• 253 = MPCI Canola
• 254 = MPCI Flax
• 255 = MPCI Lentil
• 256 = MPCI Oat
• 257 = MPCI Pea
• 258 = MPCI Potato
• 259 = MPCI Other Crops
• 260 = Residential Land
• 261 = LOB Coverage Percentage Residential Land

Added the following row:

Removed the following rows:

Added the following rows:

New status:

• NEW = New

Removed column: CustomLOB

Added columns: CustomLOBOptionCode, IsSeismic, EventBasedAdjFactorSet, and IsCustomLoss

intModel

intCountry