CEDE 8.0 Database Reference
tMainPerilSubPerilXref Table
AIRReference Database : 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)
  • 139404 (earthquake shake, fire following, tsunami, sprinkler leakage, and landslide)
Properties
Creation Date11/11/2014 11:36 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows64
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.

int4   
Primary Key SubPerilSetCode

Code that represents the sub-perils.

Code values are defined in dbo.tPerilSet Table.

int4   
See Also

Related Objects

AIRReference Database