Touchstone 4.0 Database Documentation
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 Date5/31/2016 9:45 AM
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 AccumulatorIDIdentifier for the zones, rings, or polygons in which exposure concentration is accumulated for a specified peril in a Geospatial analysis.Integer4   
Primary Key PerilSetCode

Numeric code for the single peril or set of perils.

For a complete list of codes, see tPerilSet Table.

Integer4   
Primary Key SubAccumulatorIDUnique 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.Integer4   
 LocationsNumber of locations included in the accumulation area.Integer4   
 RisksNumber of risks included in the accumulation area.Integer4   
 TotalReplacementValueAccumulated replacement values of all Coverages (A, B, C, and D) within the analyzed area.Double9  
 ExposedGroundUpTotal exposure before applying financial terms, but after applying any custom damage ratio. This is equal to the TotalReplacementValue (TRV) multiplied by the damage ratio.Double9  
 ExposedGrossTotal 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.Double9  
 ExposedPreCATNetTotal 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.Double9  
 ExposedPostCATNetTotal 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.Double9  
 ReplacementValueAAccumulated Coverage A replacement value for all locations within the analyzed area.Double9  
 ReplacementValueBAccumulated Coverage B replacement value for all locations within the analyzed area.Double9  
 ReplacementValueCAccumulated Coverage C replacement value for all locations within the analyzed area.Double9  
 ReplacementValueDAccumulated Coverage D replacement value for all locations within the analyzed area.Double9  
 ExposedGroundUp_ATotal 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.Double9  
 ExposedGroundUp_BTotal 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.Double9  
 ExposedGroundUp_CTotal 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.Double9  
 ExposedGroundUp_DTotal 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.Double9  
 ExposedGross_ATotal 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.Double9  
 ExposedGross_BTotal 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.Double9  
 ExposedGross_CTotal 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.Double9  
 ExposedGross_DTotal 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.Double9  
 ExposedPreCATNet_AAccumulated 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.Double9  
 ExposedPreCATNet_BAccumulated 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.Double9  
 ExposedPreCATNet_CAccumulated 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.Double9  
 ExposedPreCATNet_DAccumulated 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.Double9  
 EmployeesAccumulated employee count within the analyzed area.Double9  
 DayShiftEmployeesAccumulated count of day-shift employees within the analyzed area.Double9  
 EveningShiftEmployeesAccumulated count of evening-shift employees within the analyzed area.Double9  
 NightShiftEmployeesAccumulated count of night-shift employees within the analyzed area.Double9  
See Also

Related Objects

AIRResult
Locating Results for a Specific Analysis

 

 


AIR Client Confidential

© 2016. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact AIR Worldwide with questions or comments. For database questions. For documentation comments.