Touchstone 4.0 Database Documentation

tRRRR_IMPACT_AnnualEPSummary Table

AIRExposureSummary Database : tRRRR_IMPACT_AnnualEPSummary Table |

Description

Stores annual exceedance probability summary losses for a marginal impact assessment.

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

ImpactRegionPerilSetCode | Numeric code for the single peril or set of perils which impact the region. For a complete list of codes, see tPerilSet Table. | SmallInt | 2 | ||||

OutputTypeCode | Numeric code for the single peril or set of perils which impact the region. For a complete list of codes, see tPerilSet Table. | VarChar | 10 | ||||

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

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

EPCurveTypeCode | 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 tEPCurveType Table. | VarChar | 10 | ||||

EPTypeCode | Code that represents the type of Exceedance Probability curve. For a complete list of codes, see tEPType Table. | VarChar | 10 | ||||

EPTargetTypeCode | Code that represents type of data represented in the EP curve. 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, f the EP target type is Contract, then this is the | Integer | 4 | ||||

ExpectedValue | 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.thier | 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