Stores annual exceedance probability losses for one analysis by zone.
Touchstone creates one table for each analysis that included Zone as an output option. By default, for each combination of year 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.
| Creation Date | 4/11/2022 6:15 PM |
| 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 |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | 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. | 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 of the losses. For a complete list of codes, see tFinancialPerspective Table. | varchar | 10 | |||
| | EPTargetTypeCode | Code that represents the type of analysis target. For a complete list of codes, see tEPTargetType Table. | varchar | 10 | |||
| | GlobalZoneSID | Unique system-generated sequential identifier for the zone that generated the losses. For a complete list of codes, see tGlobalZone Table. | int | 4 | |||
| | 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. | int | 4 | |||
| | EPTargetSID | Unique system-generated sequential identifier for the analysis target. | int | 4 | |||
| | Rank | Unique identifier of the event that produced the highest loss in the simulated year. | int | 4 | |||
| EventID | Identifier of the event that produced the highest loss in the simulated year. | int | 4 |  | |||
| ModelCode | Code that represents the catastrophe model. For a complete list of codes, see tModel Table. | smallint | 2 | ||||
| YearID | In multi-year catalogs, each scenario actually consists of five modeled years. The unique identifier tracks the scenario. | int | 4 | | |||
| ExceedanceProbability | Probability that the loss for the simulated year will be equaled or exceeded in any other year. | float | 9 | | |||
| ReturnPeriodYears | Expected value of the interval of time (in years) between years having greater or equal loss. | float | 9 | | |||
| EPLoss | Expected annual loss for the corresponding point on the exceedance probability curve. | float | 9 | | |||
| TVARLoss | Tail value at risk, which is the average annual loss for the years beyond the corresponding point on the EP curve. | float | 9 | | |||
| MaxLoss | Maximum annual loss for the corresponding point on the EP curve. Used to calculate confidence intervals. | float | 9 | | |||
| SDLoss | Standard deviation from the mean annual expected loss (EV). | float | 9 | |