Touchstone 4.0 Database Documentation
tMainPerilSubPerilXref Table
Description

System reference table that stores information about the sub-perils that are associated with a primary peril set. 

For example, the following sub-perils are associated with MainPerilSetCode "4" (earthquake):

  • 4 (earthquake)
  • 8 (fire following)
  • 12 (earthquake shake, fire following)
  • 128 (sprinkler leakage)
  • 8192 (tsunami)
  • 8196 (earthquake shake, tsunami)
  • 8200 (fire following, tsunami)
  • 8204 (earthquake shake, fire following, tsunami)
Properties
Creation Date11/11/2014 11:36 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows15
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key MainPerilSetCode

Code that represents the main peril set.

Code values are defined in dbo.tPerilSet Table.

Integer4   
Primary Key SubPerilSetCode

Code that represents the sub-perils.

Code values are defined in dbo.tPerilSet Table.

Integer4   
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.