Stores the possible groups of geographic areas impacted by specific peril sets identified by the Marginal Impact analysis options.
Touchstone 2022 Database Reference
tImpactRegionPerilSet Table
Stores the possible groups of geographic areas impacted by specific peril sets identified by the Marginal Impact analysis options.
| Creation Date | 11/15/2016 6:05 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 14 |
| Data Space Used | 8.00 KB |
| Index Space Used | 8.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | ImpactRegionPerilSetCode | Code that represents the possible geographic area impacted by peril sets.
| smallint | 2 | |||
| ImpactRegionPerilSet | Name of the region peril set. Corresponds to the code in ImpactRegionPerilSetCode. | varchar | 40 | ||||
| GeoLevelCode | Code that represents the geographic levels. For a complete list of codes see tGeoLevel Table. | varchar | 10 |  | |||
| Description | Description of the region peril set. | varchar | 1024 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tImpactRegionPerilSetXref | Table | System reference table used to determine the possible geographic areas impacted by specific peril sets. This table is not human-readable. | 1 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
| tGeoLevel | Table | Stores codes that represent geographic levels. | 1 |