Stores the results of the Geospatial analysis at the latitude/longitude location-level.
Touchstone 2022 Database Reference
tRRRR_EC_ByLocation 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 peril or set of perils included in the analysis. 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 | |||
| | LocationSID | Unique system-generated sequential identifier for the location record. For a complete list of records, see tLocation Table. | 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 location, within the analyzed area. | float | 9 | | |||
| ShiftEmployees | float | 9 | | ||||
| TotalEmployeePayout | float | 9 | | ||||
| TotalAccumulatedExposure | float | 9 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tRRRR_EC_DimLocation | Table | Stores attributes associated with each location included in the analysis. These attributes are displayed on the user interface along with data from tRRRR_EC_ByLocation Table. | 1 |