Touchstone 4.0 Database Documentation
tRRRR_EC_ByReinsurance Table
Stores information about the reinsurance program that is applicable to a given Accumulator and Peril combination.
Creation Date5/31/2016 9:45 AM
Text File Group
System Object
Published for Replication
Data Space Used0.00 KB
Index Space Used0.00 KB
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key AccumulatorID

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

Primary Key PerilSetCode

Numeric code for the single peril or set of perils.

For a complete list of codes, see tPerilSet Table.

Primary Key ReinsuranceSID

Unique system-generated sequential identifier for the reinsurance record.

For a complete list of records, see tReinsurance Table.

 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  
Objects that tRRRR_EC_ByReinsurance depends on
 Database ObjectObject TypeDescriptionDep Level
tRRRR_EC_DimReinsurance tabletRRRR_EC_DimReinsuranceTableStores reinsurance program attributes such as its ID and type. tRRRR_EC_ByReinsurance Table refers to the data in this parent table.1
See Also

Related Objects

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.