Touchstone 4.0 Database Documentation

tRRRR_EC_ByAccumulator Table

AIRResult : tRRRR_EC_ByAccumulator Table |

Description

Stores the results of the Geospatial Accumulation analysis. An Accumulation analysis determines the accumulation of risk in peril-specific high risk areas. One or more of the properties in this table can be accumulated, such as location, risk, replacement value, and loss.

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

AccumulatorID | Identifier for the zones, rings, or polygons in which exposure concentration is accumulated for a specified peril in a Geospatial analysis. | Integer | 4 | ||||

PerilSetCode | Numeric code for the single peril or set of perils. For a complete list of codes, see tPerilSet Table. | Integer | 4 | ||||

SubAccumulatorID | Unique system-generated identifier that acts as a primary key to relate to the DIM Accumulator table. It identifies a single concentric ring in which exposure concentration is accumulated for a specified peril during the Geospatial analysis. | Integer | 4 | ||||

Locations | Number of locations included in the accumulation area. | Integer | 4 | ||||

Risks | Number of risks included in the accumulation area. | Integer | 4 | ||||

TotalReplacementValue | Accumulated replacement values of all Coverages (A, B, C, and D) within the analyzed area. | Double | 9 | ||||

ExposedGroundUp | Total exposure before applying financial terms, but after applying any custom damage ratio. This is equal to the TotalReplacementValue (TRV) multiplied by the damage ratio. | Double | 9 | ||||

ExposedGross | Total exposure after applying location and contract financial terms, such as limits and deductibles. The TotalReplacementValue (TRV) is multiplied by the damage ratio before the financial terms are applied. | Double | 9 | ||||

ExposedPreCATNet | Total exposure after applying all re-insurance treaties except for CAT Excess-of-Loss (XOL) treaties. The TotalReplacementValue (TRV) is multiplied by the damage ratio before the financial terms are applied. | Double | 9 | ||||

ExposedPostCATNet | Total exposure after applying all re-insurance treaties, including CAT Excess-of-Loss (XOL) treaties. The TotalReplacementValue (TRV) is multiplied by the damage ratio before the financial terms are applied. | Double | 9 | ||||

ReplacementValueA | Accumulated Coverage A replacement value for all locations within the analyzed area. | Double | 9 | ||||

ReplacementValueB | Accumulated Coverage B replacement value for all locations within the analyzed area. | Double | 9 | ||||

ReplacementValueC | Accumulated Coverage C replacement value for all locations within the analyzed area. | Double | 9 | ||||

ReplacementValueD | Accumulated Coverage D replacement value for all locations within the analyzed area. | Double | 9 | ||||

ExposedGroundUp_A | Total Coverage A exposure before applying financial terms, such as limits and deductibles, but after applying any custom damage ratio. This is equal to the sum of all Coverage A exposure multiplied by the damage ratio. | Double | 9 | ||||

ExposedGroundUp_B | Total Coverage B exposure before applying financial terms, such as limits and deductibles, but after applying any custom damage ratio. This is equal to the sum of all Coverage B exposure multiplied by the damage ratio. | Double | 9 | ||||

ExposedGroundUp_C | Total Coverage C exposure before applying financial terms, such as limits and deductibles, but after applying any custom damage ratio. This is equal to the sum of all Coverage C exposure multiplied by the damage ratio. | Double | 9 | ||||

ExposedGroundUp_D | Total Coverage D exposure before applying financial terms, such as limits and deductibles, but after applying any custom damage ratio. This is equal to the sum of all Coverage D exposure multiplied by the damage ratio. | Double | 9 | ||||

ExposedGross_A | Total Coverage A exposure of all covered buildings after applying location and contract financial terms, such as limits and deductibles. The TotalReplacementValue (TRV) is multiplied by the damage ratio before the financial terms are applied. | Double | 9 | ||||

ExposedGross_B | Total Coverage B exposure of all covered buildings after applying location and contract financial terms, such as limits and deductibles. The TotalReplacementValue (TRV) is multiplied by the damage ratio before the financial terms are applied. | Double | 9 | ||||

ExposedGross_C | Total Coverage C exposure of all covered buildings after applying location and contract financial terms, such as limits and deductibles. The TotalReplacementValue (TRV) is multiplied by the damage ratio before the financial terms are applied. | Double | 9 | ||||

ExposedGross_D | Total Coverage D exposure of all covered buildings after applying location and contract financial terms, such as limits and deductibles. The TotalReplacementValue (TRV) is multiplied by the damage ratio before the financial terms are applied. | Double | 9 | ||||

ExposedPreCATNet_A | Accumulated Coverage A exposure after applying all reinsurance treaties, except for CAT Excess of Loss (XOL) treaties. The TotalReplacementValue (TRV) is multiplied by the damage ratio before the financial terms are applied. | Double | 9 | ||||

ExposedPreCATNet_B | Accumulated Coverage B exposure after applying all reinsurance treaties, except for CAT Excess of Loss (XOL) treaties. The TotalReplacementValue (TRV) is multiplied by the damage ratio before the financial terms are applied. | Double | 9 | ||||

ExposedPreCATNet_C | Accumulated Coverage C exposure after applying all reinsurance treaties, except for CAT Excess of Loss (XOL) treaties. The TotalReplacementValue (TRV) is multiplied by the damage ratio before the financial terms are applied. | Double | 9 | ||||

ExposedPreCATNet_D | Accumulated Coverage D exposure after applying all reinsurance treaties, except for CAT Excess of Loss (XOL) treaties. The TotalReplacementValue (TRV) is multiplied by the damage ratio before the financial terms are applied. | Double | 9 | ||||

Employees | Accumulated employee count within the analyzed area. | Double | 9 | ||||

DayShiftEmployees | Accumulated count of day-shift employees within the analyzed area. | Double | 9 | ||||

EveningShiftEmployees | Accumulated count of evening-shift employees within the analyzed area. | Double | 9 | ||||

NightShiftEmployees | Accumulated count of night-shift employees within the analyzed area. | Double | 9 |

See Also