Touchstone 2022 Database Reference
tRRRR_LOSS_AnnualEP_ByPerilByZone Table
AIRExposureSummary Database : tRRRR_LOSS_AnnualEP_ByPerilByZone Table
Description

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

Touchstone creates one table for each analysis that included Zones by Peril as an output option. By default, for each combination of year, peril, and geographic zone that generated losses, the table contains at most one row for aggregate losses and one row for occurrence losses for each financial perspective for the standard EP curve. Touchstone may create more rows if you request additional EP curves for subsets of the results.

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 EPAnnualTypeCode

Code that indicates whether the losses by peril and zone are based on all events that occurred during a year (aggregate) or on the single largest loss caused by all events in a year (occurrence).

For a complete list of codes, see tEPAnnualType Table. 

varchar10   
Primary Key EPCurveTypeCode

Code that indicates whether the losses are based on AIR’s default EP curve or on user-specified loss uncertainty percentiles.

For a complete list of codes, see tEPCurveType Table. 

varchar10   
Primary Key FinancialPerspectiveCode

Code that represents the financial perspective of the losses.

For a complete list of codes, see tFinancialPerspective Table.

varchar10   
Primary Key EPTargetTypeCode

Code that represents the type of analysis target.

For a complete list of codes, see tEPTargetType Table.

varchar10   
Primary Key PerilSetCode

Numeric code for the peril or set of perils that generated the losses.

For a complete list of codes, see tPerilSet Table.

int4   
Primary Key GlobalZoneSID

Unique system-generated sequential identifier for the zone that generated the losses.

For a complete list of codes, see tGlobalZone Table.

int4   
Primary Key ExposureDataSourceSID

Unique system-generated sequential identifier for the exposure data source record where the EPTargetSID can be found.

For a complete list of records, see tDataSource Table.

int4   
Primary Key EPTargetSID

Unique system-generated sequential identifier for the analysis target.

int4   
Primary Key RankUnique identifier of the event that produced the highest loss in the simulated year.int4   
 EventIDIdentifier of the event that produced the highest loss in the simulated year.int4  
 ModelCode

Code that represents the catastrophe model.

For a complete list of codes, see tModel Table.

smallint2   
 YearIDIn multi-year catalogs, each scenario actually consists of five modeled years. The unique identifier tracks the scenario.int4  
 ExceedanceProbabilityProbability that the loss for the simulated year will be equaled or exceeded in any other year.float9  
 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  
 TVARLossTail value at risk, which is the average annual loss for the years beyond the corresponding point on the EP curve.float9  
 MaxLossMaximum annual loss for the corresponding point on the EP curve. Used to calculate confidence intervals.float9  
 SDLossStandard deviation from the mean annual expected loss (EV).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.