Touchstone 2022 Database Reference
tImpactRegionPerilSetXref Table
AIRReference Database : tImpactRegionPerilSetXref Table
Description
System reference table used to determine the possible geographic areas impacted by specific peril sets. This table is not human-readable.
Properties
Creation Date11/15/2016 6:05 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows176
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key ImpactRegionPerilSetCode

Code that represents the possible geographic area impacted by peril sets.

For a complete list of codes, see tImpactRegionPerilSet Table

smallint2   
Primary Key GeographySID

Unique system-generated sequential identifier for the geographic record.

For a complete list of records, see tGeography Table.

int4   
Primary Key PerilSetCode

Numeric code for the single peril or set of perils.

For a complete list of codes, see tPerilSet Table.

int4   
Objects that tImpactRegionPerilSetXref depends on
 Database ObjectObject TypeDescriptionDep Level
tGeoLevel tabletGeoLevelTable

Stores codes that represent geographic levels.

2
tImpactRegionPerilSet tabletImpactRegionPerilSetTable

Stores the possible groups of geographic areas impacted by specific peril sets identified by the Marginal Impact analysis options.

1
tPerilSet tabletPerilSetTable

Stores codes that represent the perils sets supported by the application.

1
See Also

Related Objects

AIRReference Database

 

 

Verisk Analytics Client Confidential

© 2022. AIR Worldwide is now Extreme Event Solutions. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact Verisk Analytics with questions or comments.