Touchstone 2022 Database Reference
tRRRR_EC_ByAccumulator Table
AIRExposureSummary Database : tRRRR_EC_ByAccumulator Table
Description
Stores the accumulated results of a Exposure Concentration analysis within a user-defined area (zones, rings, or polygons).  One or more of the properties can be accumulated, such as location, risk, replacement value, employee count, and loss.
Properties
Creation Date4/11/2022 6:15 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows0
Data Space Used0.00 KB
Index Space Used0.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key Identifier for the user-defined area (zones, rings, or polygons) used during the Exposure Concentration analysis.int4   
Primary Key 

Numeric code for the single peril or set of perils.

For a complete list of codes, see tPerilSet Table.

int4   
Primary Key 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 Exposure Concentration analysis.int4   
 Number of locations included in the accumulation area.int4   
 Number of risks included in the accumulation area.bigint8   
 Accumulated replacement values of all Coverages (A, B, C, and D) within the analyzed area.float9  
 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.float9  
 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.float9  
 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.float9  
 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.float9  
  float9  
  float9  
  float9  
  float9  
  float9  
  float9  
  float9  
  float9  
 Accumulated Coverage A replacement value for all locations within the analyzed area.float9  
 Accumulated Coverage B replacement value for all locations within the analyzed area.float9  
 Accumulated Coverage C replacement value for all locations within the analyzed area.float9  
 Accumulated Coverage D replacement value for all locations within the analyzed area.float9  
 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 D exposure multiplied by the damage ratio.float9  
 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 D exposure multiplied by the damage ratio.float9  
 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 D exposure multiplied by the damage ratio.float9  
 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.float9  
 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.float9  
 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.float9  
 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.float9  
 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.float9  
 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.float9  
 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.float9  
 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.float9  
 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.float9  
 Accumulated employee count within the analyzed area.float9  
  float9  
  float9  
  float9  
See Also

Related Objects

AIRExposureSummary Database