Stores information about each accumulation object. tRRRR_EC_ByAccumulator Table refers to the data in this parent table.
Touchstone 2022 Database Reference
tRRRR_EC_DimAccumulator 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 | |||
| AccumulatorTypeCode | Code that represents the type of accumulator. For a complete list of codes, see tAccumulatorType Table. | varchar | 10 | ||||
| GeoMatchLevelCode | Code that represents the level at which geocode match occurred. For a complete list of codes, see tGeoMatchLevel Table. | varchar | 10 |  | |||
| AccumulatorName | Name of the accumulator; Structure is {DataSet}.{PolicyID}.{LocationID}. | varchar | 500 | | |||
| City |
City in which the location resides.
| varchar | 255 | | |||
| Address | Street address for the location within the accumulator zone resides. | varchar | 255 | | |||
| Latitude | Latitude coordinate for the location. Values will be positive for locations north of the equator and negative south of the equator. | numeric | 9 (9,6) | | |||
| Longitude | Longitude coordinate for the location. Values will be negative for locations west of the prime meridian up to the international date line. They will be positive for locations east of the prime meridian. | numeric | 9 (9,6) | | |||
| CountryName | Name of the country. | varchar | 255 | | |||
| CRESTAName | Name of the CRESTA. | varchar | 255 | | |||
| AreaName | Name of the area. | varchar | 255 | | |||
| SubareaName | Name of the subarea. | varchar | 255 | | |||
| PostalCode | Name of the postal code. | varchar | 15 | | |||
| Subarea2Name | Name of the location's subarea2 code. | varchar | 255 | | |||
| EventScale | Magnitude of event analyzed. For example, a hurricane category or the intensity of an earthquake. This value is populated from tSpatialDataset Table. | varchar | 255 | | |||
| EventYear | Actual event year. This value is populated from tSpatialDataset Table. | int | 4 | | |||
| GeographySID | Unique system-generated sequential identifier for the geographic record. For a complete list of records, see tGeography Table. | int | 4 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tRRRR_EC_DimSubAccumulator | Table | Stores information about each sub-accumulation object. A sub-accumulation object is a concentric ring that is assigned a peril-specific damage ratio. All locations that lie within this ring are analyzed together as a single group. | 1 |