Touchstone 4.0 Database Documentation
tRRRR_EC_ByContract Table
Description
Stores the results of the Geospatial analysis at the contract-level.
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 ExposureDataSourceSID

Unique system-generated sequential identifier for the exposure data source record.

For a complete list of records, see tDataSource Table.

Integer4   
Primary Key ContractSID

Unique system-generated sequential identifier for the contract record.

For a complete list of records, see tContract Table.

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  
 EmployeesEmployee count, by contract, within the analyzed area.Double9  
 DayShiftEmployeesDay-shift employee count, by contract, within the analyzed area.Double9  
 EveningShiftEmployeesEvening-shift employee count, by contract, within the analyzed area.Double9  
 NightShiftEmployeesNight-shift employee count, by contract, within the analyzed area.Double9  
Objects that tRRRR_EC_ByContract depends on
 Database ObjectObject TypeDescriptionDep Level
tRRRR_EC_DimContract tabletRRRR_EC_DimContractTableStores attributes associated with each contract. These attributes are displayed on the user interface together with data from table tRRRR_EC_ByContract Table.1
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.