Touchstone 2022 Database Reference
tRRRR_IMPACT_TopImpact Table
AIRExposureSummary Database : tRRRR_IMPACT_TopImpact Table
Description
Stores the ten highest losses in a marginal impact analysis.
Properties
Creation Date4/11/2022 6:15 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows0
Data Space Used0.00 KB
Index Space Used0.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key ImpactAdminBoundaryPerilId

Identifier for the administrative boundary and peril combination associated with the results.

For a complete list of combinations, see tImpactAdminBoundaryPerilSetXref Table.

smallint2   
Primary Key FinancialPerspectiveCode

Code that represents the financial perspective used to display the results.

For a complete list of codes, see tFinancialPerspective Table.

varchar10   
Primary Key EPAnnualTypeCode

Code that indicates whether the losses are for all events that occurred during one simulated year (aggregate) or the largest loss that occurred during one simulated year (occurrence).

For a complete list of codes, see tEPAnnualType Table.

varchar10   
Primary Key EPTypeCode

Code that indicates whether the losses represent exceedance probability losses or tail value at risk (TVAR) losses.

For a complete list of codes, see tEPType Table.

varchar10   
Primary Key ExceedanceProbabilityProbability that the loss for the simulated year will be equaled or exceeded in a given year.float9   
Primary Key ReturnPeriodYearsExpected value of the interval of time (in years) between years having greater or equal loss.float9   
 EPLossExpected annual loss for the corresponding point on the exceedance probability curve.float9  
See Also

Related Objects

AIRExposureSummary Database

 

 

Verisk Analytics Client Confidential

© 2022. AIR Worldwide is now Extreme Event Solutions. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact Verisk Analytics with questions or comments.