Touchstone 4.0 Database Documentation
tNonCatPerilGroup Table
Description
Stores the ISO peril groups.  These are applicable for commercial, non-catastrophe analyses only.
Properties
Creation Date9/2/2014 2:22 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows3
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key PerilGroupCode

Code that represents the ISO peril groups.

  • BGI = Basic Group 1
    (fire, lightening explosion, vandalism, or sprinkler leakage)
  • CMB = Combined BGI and SCL
  • SCL = Special Causes of Loss
    (theft, weight of snow, ice, or sleet,  falling objects, or water damage)
VarChar5   
 PerilGroup

Name of the peril group.

Corresponds to the code in PerilGroupCode.

VarChar255   
 DescriptionDescription of the types of events that are categorized within the peril group.VarChar1024  
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.