Unique system-generated sequential identifier for the results record.

For a complete list of records, see tAnalysisResult Table.

Numeric code for the single peril or set of perils.

For a complete list of codes, see tPerilSet Table.

Unique system-generated sequential identifier for the event set record.

For a complete list of records, see tEventSet Table.

Unique system-generated sequential identifier for the program record.

For a complete list of records, see tProgram Table.

Code that represents how the facultative option is applied.

For a complete list of codes, see tFacultativeOption Table.

Code that represents the financial perspective loss on which CatExcess of loss treaties are applied.

For a complete list of codes, see tFinancialPerspective Table.

Code that represents the type of output generated during the analysis.

For a complete list of codes, see tOutputType Table.

Code that represents the type of AAL summary that was output for the analysis.

For a complete list of codes, see tOutputDetailedAAL Table.

Code that represents the geographic level.

For a complete list of codes, see tGeoLevel Table.

Code that represents the group in which the output is organized.

For a complete list of codes, see tOutputGroupBy Table.

Code that indicates whether the average properties option was enabled. When ‘On’, the data is analyzed at a coarser geographic resolution.

For a complete list of codes, see tAveragePropertyOption Table.

Indicates whether disaggregation was used on aggregate location data.

• 1 = Yes (disaggregate)
• 0 = No (no disaggregation)

Indicates whether location terms were applied in residential contracts.

• 1 = Yes (applied)
• 0 = No (not applied)

Indicates whether invalid construction/occupancy combination were ignored or mapped to the default combinations.

• 1 = Yes (mapped to defaults)
• 0 = No (ignored)

• 1 = Yes
• 0 = No

Code that represents how demand surge was applied.

For a complete list of codes, see tDemandSurgeOption Table.

Indicates whether marine craft geocodes were moved to the coast.

• 1 = Yes (moved)
• 0 = No (not moved)

• 1 = Yes (saved)
• 0 = No (not saved)

Indicates whether Retained loss results were saved.

• 1 = Yes (saved)
• 0 = No (not saved)

• 1 = Yes (saved)
• 0 = No (not saved)

Indicates whether Gross loss results were saved.

• 1 = Yes (saved)
• 0 = No (not saved)

Indicates whether Net-of-Pre loss results are saved.

• 1 = Yes (saved)
• 0 = No (not saved)

Indicates whether Net-of-Post loss results were saved.

• 1 = Yes (saved)
• 0 = No (not saved)

Indicates whether coverage data for a given financial perspective was saved. For example, when Ground-Up is selected and coverage option is chosen, the resultant table would include Ground-Up loss for Coverage A, Coverage B , Coverage C, and Coverage D.

• 1 = Yes (saved)
• 0 = No (not saved)

Indicates whether claims count were saved.

• 1 = Yes (saved)
• 0 = No (not saved)

Code for the unit of measure used to express the price of oil.

For a complete list of codes, see tUnit Table.

Code for the unit of measure used to express the price of oil.

For a complete list of codes, see tUnit Table.

Indicates whether Maximum Any One Life terms were saved.

• 1 = Yes (saved)
• 0 = No (not saved)

Unique system-generated sequential identifier for the base analysis record.

For a compete list of records, see tAnalysis Table.

XML string that defines the loss modification option.  Used internally by Touchstone.

Unique system-generated sequential identifier for the loss modification template.

For a complete list of records, see tLossModTemplate Table.

System-provided status code for the record in the table. 

For a complete list of codes, see dbo.tStatus Table.

Product version associated with the event set.

This enables users to view results generated from previous version of Touchstone,  even when the models are updated.

Note that for old model results, event description are not accessible because catalog files no longer exist in the Touchstone system.

Version of the product used to perform the analysis.

This enables users to view results generated from previous version of Touchstone,  even when the models are updated.

Code that represents the component/model used during the analysis.

Indicates whether a summary of losses by peril was saved.

• 1 = Yes (saved)
• 0 = No (not saved)

Indicates whether a summary of losses by model was saved.

• 1 = Yes (saved)
• 0 = No (not saved)

Indicates whether a summary of losses by geographic zone was saved.

• 1 = Yes (saved)
• 0 = No (not saved)

Indicates whether the event set included in the analysis corresponds to the current or previous version of the AIR models.

• 1 = Yes (previous version)
• 0 = No (current version)

Indicates whether the custom vulnerability set is included in the analysis.

• 1 = Yes
• 0 = No

Indicates whether you want to save loss results by sub peril.

• 1 = Yes
• 0 = No

Indicates whether you want to save loss results by sub peril.

• 1 = Yes
• 0 = No

Indicates whether you want to save loss results by sub peril.

• 1 = Yes
• 0 = No

Indicates whether you want to run the detailed loss analysis with a custom frequency set template.

• 1 = Yes
• 0 = No

Indicated whether you want to run the custom frequency set analysis with the default AIR Analysis mode. If unselected, the analysis will not apply AIR model results.

• 1 = Yes
• 0 = No