Touchstone 4.0 Database Documentation

tRRRR_LOSS_AnnualEPSummary Table

AIRExposureSummary Database : tRRRR_LOSS_AnnualEPSummary Table |

Description

Stores annual exceedance probability summary losses. This table is created for each analysis. By default, the table will contain rows for each financial perspective for which results are saved, one row each for aggregate EP, occurrence EP, aggregate TVAR, and occurrence TVAR. 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 | ||||

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 | 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 | ||||

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. | Double | 9 | ||||

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

EP1Loss | Loss for the first user-specified point on the exceedance probability curve. | Double | 9 | ||||

EP2Loss | Loss for the second user-specified point on the exceedance probability curve. | Double | 9 | ||||

EP3Loss | Loss for the third user-specified point on the exceedance probability curve. | Double | 9 | ||||

EP4Loss | Loss for the fourth user-specified point on the exceedance probability curve. | Double | 9 | ||||

EP5Loss | Loss for the fifth user-specified point on the exceedance probability curve. | Double | 9 | ||||

EP6Loss | Loss for the sixth user-specified point on the exceedance probability curve. | Double | 9 | ||||

EP7Loss | Loss for the seventh user-specified point on the exceedance probability curve. | Double | 9 | ||||

EP8Loss | Loss for the eighth user-specified point on the exceedance probability curve. | Double | 9 | ||||

EP9Loss | Loss for the ninth user-specified point on the exceedance probability curve. | Double | 9 | ||||

EP10Loss | Loss for the tenth user-specified point on the exceedance probability curve. | Double | 9 | ||||

EP11Loss | Loss for the eleventh user-specified point on the exceedance probability curve. | Double | 9 | ||||

EP12Loss | Loss for the twelfth user-specified point on the exceedance probability curve. | Double | 9 | ||||

EP13Loss | Loss for the thirteenth user-specified point on the exceedance probability curve. | Double | 9 | ||||

EP14Loss | Loss for the fourteenth user-specified point on the exceedance probability curve. | Double | 9 | ||||

EP15Loss | Loss for the fifteenth user-specified point on the exceedance probability curve. | Double | 9 |

See Also