Touchstone 4.0 Database Documentation
tImpactRegionPerilSet Table
Description

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

Properties
Creation Date3/18/2011 4:37 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows14
Data Space Used8.00 KB
Index Space Used24.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key ImpactRegionPerilSetCode

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

  • 1 = World All Perils
  • 2 = Europe Wind
  • 3 = Europe Earthquake
  • 4 = UK Flood
  • 5 = Japan Wind
  • 6 = Japan Earthquake
  • 7 = North American Wind
  • 8 = North American Earthquake
  • 9 = US Wind
  • 10 = US Earthquake
  • 11 = Florida Wind
  • 12 = California Earthquake
  • 13 = UK Coastal Storm Surge
  • 14 = US Inland Flood
SmallInt2   
 ImpactRegionPerilSet

Name of the region peril set.

Corresponds to the code in ImpactRegionPerilSetCode.

VarChar40   
 GeoLevelCode

Code that represents the geographic levels.

For a complete list of codes see tGeoLevel Table.

VarChar10  
 Description

Description of the region peril set.

VarChar1024  
Objects that depend on tImpactRegionPerilSet
 Database ObjectObject TypeDescriptionDep Level
tImpactRegionPerilSetXref tabletImpactRegionPerilSetXrefTableSystem reference table used to determine the possible geographic areas impacted by specific peril sets. This table is not human-readable.1
Objects that tImpactRegionPerilSet depends on
 Database ObjectObject TypeDescriptionDep Level
tGeoLevel tabletGeoLevelTable

Stores the geographic levels.

2
See Also

Related Objects

AIRReference Database

 

 


AIR Client Confidential

© 2016. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact AIR Worldwide with questions or comments. For database questions. For documentation comments.