Touchstone 4.0 Database Documentation

tRRRR_LOSS_AnnualEP Table

AIRExposureSummary Database : tRRRR_LOSS_AnnualEP Table |

Description

Stores annual exceedance probability losses for an analysis. This table is created for each analysis. By default, for each year in the analysis that experienced loss, the table will contain at most one Aggregate row and one Occurrence row per financial perspective for the Standard EP curve. But if losses for a particular financial perspective in that year were 0, no row is generated. The table may contain additional rows if the user requests additional EP curves for subsets of the results.

Properties

Creation Date | 5/31/2016 9:46 AM |

File Group | PRIMARY |

Text File Group | |

System Object | |

Published for Replication | |

Rows | 0 |

Data Space Used | 0.00 KB |

Index Space Used | 0.00 KB |

Columns

Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
---|---|---|---|---|---|---|---|

EPAnnualTypeCode | Code that indicates whether the losses 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. | VarChar | 10 | ||||

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

FinancialPerspectiveCode | Code that represents the financial perspective used to display the losses. For a complete list of codes, see tFinancialPerspective Table. | VarChar | 10 | ||||

EPTargetTypeCode | Code that represents the target of the analysis for which losses were produced. For a complete list of codes, see tEPTargetType Table. | VarChar | 10 | ||||

ExposureDataSourceSID | Unique system-generated sequential identifier for the exposure data source record in which the For a complete list of records, see tDataSource Table. | Integer | 4 | ||||

EPTargetSID | Unique system-generated sequential identifier for the target record for which the losses were aggregated For example, if the EP target type is Contract, then this is the ContractSID. | Integer | 4 | ||||

Rank | Unique identifier of the event that produced the highest loss in the simulated year. | Integer | 4 | ||||

EventID | Identifier of the event that produced the highest loss in the simulated year | Integer | 4 | ||||

ModelCode | Code that represents the catastrophe model. For a complete list of codes, see tModel Table. | UnsignedTinyInt | 1 | ||||

YearID | In multi-year catalogs, each scenario actually consists of five modeled years. The unique identifier tracks the scenario. | Integer | 4 | ||||

PerilSetCode | Numeric code for the single peril or set of perils associated with the event that produced the highest loss in the simulated year . For a complete list of codes, see tPerilSet Table. | Integer | 4 | ||||

ExceedanceProbability | Probability that the loss for the simulated year will be equaled or exceeded in any other year. | Double | 9 | ||||

ReturnPeriodYears | Expected value of the interval of time (in years) between years having greater or equal loss. | Double | 9 | ||||

EPLoss | Expected annual loss for the corresponding point on the exceedance probability curve. | Double | 9 | ||||

TVARLoss | Average annual loss for the years beyond the corresponding point on the EP curve (i.e., Tail Value at Risk [TVAR]). | Double | 9 | ||||

MaxLoss | Maximum annual loss for the corresponding point on the exceedance probability curve. Used to calculate confidence intervals. | Double | 9 | ||||

SDLoss | Standard deviation from the mean annual expected loss (EV). | Double | 9 |

See Also