Stores information about the reinsurance program that is applicable to a given Accumulator and Peril combination.
Touchstone 2022 Database Reference
tRRRR_EC_ByReinsurance Table
| Creation Date | 4/11/2022 6:15 PM |
| 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 |
| 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. | int | 4 | |||
| | PerilSetCode | Numeric code for the single peril or set of perils. For a complete list of codes, see tPerilSet Table. | int | 4 | |||
| | ReinsuranceSID | Unique system-generated sequential identifier for the reinsurance record. For a complete list of records, see tReinsurance Table. | int | 4 | |||
| 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. | float | 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. | float | 9 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tRRRR_EC_DimReinsurance | Table | Stores reinsurance program attributes such as its ID and type. tRRRR_EC_ByReinsurance Table refers to the data in this parent table. | 1 |