Touchstone 4.0 Database Documentation

tRRRR_TTTT_CMPLOSS_AnnualEP Table

AIRResult : tRRRR_TTTT_CMPLOSS_AnnualEP Table |

Description

Stores the deltas for the aggregate annual exceedance probability losses 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:45 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 | ||||

Rank | Unique identifier of the highest annual exceedance probability loss in the simulated year. | Integer | 4 | ||||

EventRowID | System-assigned table row identifier for the event | BigInt | 8 | ||||

ExceedanceProbability | Exceedance probability delta for the simulated year. | Double | 9 | ||||

ReturnPeriodYears | Value of the interval of time (in years) between years. | Double | 9 | ||||

EPLoss | Annual loss delta for the corresponding point on the exceedance probability curve. | Double | 9 | ||||

TVARLoss | Average annual loss delta for the years beyond the corresponding point on the EP curve (i.e., Tail Value at Risk [TVAR]). | Double | 9 | ||||

MaxLoss | Maximum annual loss delta for the corresponding point on the exceedance probability curve. | Double | 9 | ||||

SDLoss | Standard deviation delta of the mean annual expected loss (EV). | Double | 9 |

Objects that tRRRR_TTTT_CMPLOSS_AnnualEP 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 | |

tRRRR_CMPLOSS_EventKey | Table | Stores information about the events used during the Comparative Loss analysis. | 1 |

See Also