Stores the results of the Geospatial analysis at the contract-level.
Touchstone 2022 Database Reference
tRRRR_EC_ByContract Table
| Creation Date | 4/11/2022 5:46 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 | |||
| | ExposureDataSourceSID | Unique system-generated sequential identifier for the exposure data source record. For a complete list of records, see tDataSource Table. | int | 4 | |||
| | ContractSID | Unique system-generated sequential identifier for the contract record. For a complete list of records, see tContract Table. | int | 4 | |||
| Locations | Number of locations included in the accumulation area. | int | 4 | ||||
| Risks | Number of risks included in the accumulation area. | bigint | 8 | ||||
| TotalReplacementValue | Accumulated replacement values of all Coverages (A, B, C, and D) within the analyzed area. | float | 9 |  | |||
| 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 | | |||
| ExposedPreCATNet | 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. | float | 9 | | |||
| ExposedPostCATNet | 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. | float | 9 | | |||
| ExposedGroundUp_PP | float | 9 | | ||||
| ExposedGross_PP | float | 9 | | ||||
| ExposedPreCATNet_PP | float | 9 | | ||||
| ExposedPostCATNet_PP | float | 9 | | ||||
| ExposedGroundUp_WC | float | 9 | | ||||
| ExposedGross_WC | float | 9 | | ||||
| ExposedPreCATNet_WC | float | 9 | | ||||
| ExposedPostCATNet_WC | float | 9 | | ||||
| ReplacementValueA | Accumulated Coverage A replacement value for all locations within the analyzed area. | float | 9 | | |||
| ReplacementValueB | Accumulated Coverage B replacement value for all locations within the analyzed area. | float | 9 | | |||
| ReplacementValueC | Accumulated Coverage C replacement value for all locations within the analyzed area. | float | 9 | | |||
| ReplacementValueD | Accumulated Coverage D replacement value for all locations within the analyzed area. | float | 9 | | |||
| ExposedGroundUp_A | 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 A exposure multiplied by the damage ratio. | float | 9 | | |||
| ExposedGroundUp_B | 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 B exposure multiplied by the damage ratio. | float | 9 | | |||
| ExposedGroundUp_C | 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 C exposure multiplied by the damage ratio. | float | 9 | | |||
| ExposedGroundUp_D | 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. | float | 9 | | |||
| ExposedGross_A | 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. | float | 9 | | |||
| ExposedGross_B | 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. | float | 9 | | |||
| ExposedGross_C | 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. | float | 9 | | |||
| ExposedGross_D | 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. | float | 9 | | |||
| ExposedPreCATNet_A | 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. | float | 9 | | |||
| ExposedPreCATNet_B | 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. | float | 9 | | |||
| ExposedPreCATNet_C | 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. | float | 9 | | |||
| ExposedPreCATNet_D | 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. | float | 9 | | |||
| Employees | Employee count, by contract, within the analyzed area. | float | 9 | | |||
| ShiftEmployees | float | 9 | | ||||
| TotalEmployeePayout | float | 9 | | ||||
| TotalAccumulatedExposure | float | 9 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tRRRR_EC_DimContract | Table | Stores attributes associated with each contract. These attributes are displayed on the user interface together with data from table tRRRR_EC_ByContract Table. | 1 |