Stores annual exceedance probability summary losses for one analysis.
For each year that generated loss, Touchstone Re creates multiple rows. Each row represents one combination of financial perspective and aggregate EP, occurrence EP, aggregate TVAR, or occurrence TVAR. If losses for a given financial perspective in a given year are zero, Touchstone Re does not generate a row for the losses.
| Creation Date | 4/11/2022 6:17 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 corresponding 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 | 3 | ||||
| EPCurveTypeCode | Code that indicates whether the loss is based on AIR’s default EP curve. Currently, Touchstone Re supports only AIR's default EP curve. For a complete list of codes, see tEPCurveType Table. | varchar | 3 | ||||
| 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 used to display the losses. For a complete list of codes, see tFinancialPerspective Table. | varchar | 4 | ||||
| EPTargetTypeCode | Code that represents the target of the analysis for which losses were produced. For a complete list of codes, see tEPTargetType Table. | varchar | 5 | ||||
| EPTargetSID | Unique system-generated sequential identifier for the analysis target that generated the losses. | int | 4 |  | |||
| ExpectedValue | Mean annual expected loss, which is the sum of all expected losses for the simulation divided by the number of years of the simulation. | float | 9 | | |||
| StandardDeviation | Standard deviation from the ExpectedValue. | 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 eigth 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 | | |||
| ExhaustionProbability | Probability that the limit will be exhausted. | int | 4 | | |||
| AttachmentProbability | Probability that loss will exceed the retention and result in a contract loss. | float | 9 | | |||
| ExpectedLossRatio | Percentage of the loss that a program or layer is expected to incur in a given year. | int | 4 | |