Touchstone 4.0 Database Documentation

tRRRR_TTTT_CMPLOSS_AnnualEPSummary Table

AIRExposureSummary Database : tRRRR_TTTT_CMPLOSS_AnnualEPSummary Table |

Description

Stores the deltas for the aggregate annual exceedance probability summary that are calculated during a Comparative Loss analysis.

tRRRR denotes the Results SID for the Comparative Loss analysis and TTTT represents the identifier for the loss analysis. |

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

AnnualEPRowID | System-assigned table row identifier for the annual EP. | Integer | 4 | ||||

ExpectedValue | The delta in the mean annual expected loss (“expected value”). | Double | 9 | ||||

StandardDeviation | Standard deviation delta. | Double | 9 | ||||

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Objects that tRRRR_TTTT_CMPLOSS_AnnualEPSummary depends on

Database Object | Object Type | Description | Dep Level | |
---|---|---|---|---|

tRRRR_CMPLOSS_AnnualEPKey | Table | Stores annual exceedance probability losses to be used a Comparative Loss analysis. This table is created for each comparative Loss analysis. By default, for each year in the analysis that experienced loss, the table will contain at most one Aggregate row and one Occurrence row per financial perspective for the Standard EP curve. But if losses for a particular financial perspective in that year were 0, no row is generated. The table may contain additional rows if the user requests additional EP curves for subsets of the results. | 1 |

See Also