Stores annual exceedance probability summary losses by each combination of peril and model.
Touchstone creates one table for each analysis. By default, the table contains rows for each financial perspective included in the analysis and rows for the corresponding aggregate EP, occurrence EP, aggregate TVAR, and occurrence TVAR. 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 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 | |||
| | EPTypeCode | Code that indicates whether the losses represent exceedance probability losses or TVAR losses. For a complete list of codes, see tEPType 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 the analysis target. For a complete list of codes, see tEPTargetType Table. | varchar | 10 | |||
| | PerilSetCode | Numeric code for the single peril or set of perils. For a complete list of codes, see tPerilSet Table. | int | 4 | |||
| | ModelCode | Code that represents the catastrophe model. For a complete list of codes, see tModel Table. | int | 4 | |||
| | ExposureDataSourceSID | Unique system-generated sequential identifier for the exposure data source record in which 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 | |||
| ExpectedValue | The mean annual expected loss (“expected value”), which is determined by taking the sum of all expected losses for the simulation and dividing by the number of years of the simulation. | float | 9 | ||||
| StandardDeviation | Standard deviation from the mean annual expected loss (EV). | float | 9 | ||||
| EP1Loss | Loss for the first user-specified point on the exceedance probability curve. | float | 9 |  | |||
| EP2Loss | Loss for the second user-specified point on the exceedance probability curve. | float | 9 | | |||
| EP3Loss | Loss for the third user-specified point on the exceedance probability curve. | float | 9 | | |||
| EP4Loss | Loss for the fourth user-specified point on the exceedance probability curve. | float | 9 | | |||
| EP5Loss | Loss for the fifth user-specified point on the exceedance probability curve. | float | 9 | | |||
| EP6Loss | Loss for the sixth user-specified point on the exceedance probability curve. | float | 9 | | |||
| EP7Loss | Loss for the seventh user-specified point on the exceedance probability curve. | float | 9 | | |||
| EP8Loss | Loss for the eighth user-specified point on the exceedance probability curve. | float | 9 | | |||
| EP9Loss | Loss for the ninth user-specified point on the exceedance probability curve. | float | 9 | | |||
| EP10Loss | Loss for the tenth user-specified point on the exceedance probability curve. | float | 9 | | |||
| EP11Loss | Loss for the eleventh user-specified point on the exceedance probability curve. | float | 9 | | |||
| EP12Loss | Loss for the twelfth user-specified point on the exceedance probability curve. | float | 9 | | |||
| EP13Loss | Loss for the thirteenth user-specified point on the exceedance probability curve. | float | 9 | | |||
| EP14Loss | Loss for the fourteenth user-specified point on the exceedance probability curve. | float | 9 | | |||
| EP15Loss | Loss for the fifteenth user-specified point on the exceedance probability curve. | float | 9 | |