Stores the results of the Geospatial analysis at the layer level.
Touchstone 2022 Database Reference
tRRRR_EC_ByLayer 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.Stores the results of the Geospatial analysis at the layer-level. | 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 | |||
| | LayerSID | Unique system-generated sequential identifier for the layer record. For a complete list of records, see tLayer Table. | int | 4 | |||
| 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 D 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 D 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 D 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 layer, for all contract layers within the analyzed area. | float | 9 | | |||
| ShiftEmployees | float | 9 | | ||||
| TotalEmployeePayout | float | 9 | | ||||
| TotalAccumulatedExposure | float | 9 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tRRRR_EC_DimLayer | Table | Stores information about each layer defined for an analysis. tRRRR_EC_ByLayer Table refers to the data in this parent table. | 1 |