Touchstone 4.0 Database Documentation
tPerilSet Table
Description

Stores the possible perils sets that are available for use in Touchstone.

Properties
Creation Date11/3/2011 11:46 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows27648
Data Space Used4,104.00 KB
Index Space Used16.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key PerilSetCode

Code that represents the single peril or set of perils.

There are over 1,000 peril sets, please refer to the database for the complete list of codes .

    Integer4   
     PerilSet

    Abbreviated code for the perils included in the peril set. 

    For a complete list of codes, see tPeril Table.

    VarChar255   
     Description

    Description of the perils included in the peril set.

    VarChar1024  
     CoversTropicalCyclone

    Indicates whether the peril set includes tropical cyclone.

    • 1 = Yes (included)
    • 0 = No (not included)
    Boolean1 dbo.D_0 
     CoversThunderstorm

    Indicates whether the peril set includes thunderstorm.

    • 1 = Yes (included)
    • 0 = No (not included)
    Boolean1 dbo.D_0 
     CoversEarthquakeShake

    Indicates whether the peril set includes earthquake - shake.

    • 1 = Yes (included)
    • 0 = No (not included)
    Boolean1 dbo.D_0 
     CoversEarthquakeFire

    Indicates whether the peril set includes earthquake - fire.

    • 1 = Yes (included)
    • 0 = No (not included)
    Boolean1 dbo.D_0 
     CoversCoastalFlood

    Indicates whether the peril set includes coastal flood.

    • 1 = Yes (included)
    • 0 = No (not included)
    Boolean1 dbo.D_0 
     CoversTerrorism

    Indicates whether the peril set includes terrorism.

    • 1 = Yes (included)
    • 0 = No (not included)
    Boolean1 dbo.D_0 
     CoversWinterStorm

    Indicates whether the peril set includes winter storm.

    • 1 = Yes (included)
    • 0 = No (not included)
    Boolean1 dbo.D_0 
     CoversEarthquakeSprinkler

    Indicates whether the peril set includes earthquake - sprinkler.

    • 1 = Yes (included)
    • 0 = No (not included)
    Boolean1 dbo.D_0 
     CoversStormSurge

    Indicates whether the peril set includes storm surge.

    • 1 = Yes (included)
    • 0 = No (not included)
    Boolean1 dbo.D_0 
     CoversWildfire

    Indicates whether the peril set includes wildfire.

    • 1 = Yes (included)
    • 0 = No (not included)
    Boolean1 dbo.D_0 
     CoversMultiPerilCrop

    Indicates whether the peril set includes multi-peril crop.

    • 1 = Yes (included)
    • 0 = No (not included)
    Boolean1 dbo.D_0 
     CoversInlandFlood

    Indicates whether the peril set includes inland flood.

    • 1 = Yes (included)
    • 0 = No (not included)
    Boolean1 dbo.D_0 
     CoversPrecipitationFlood

    Indicates whether the peril set includes precipitation flood.

    • 1 = Yes (included)
    • 0 = No (not included)
    Boolean1 dbo.D_0 
     CoversTsunami

    Indicates whether the peril set includes tsunami.

    • 1 = Yes (included)
    • 0 = No (not included)
    Boolean1 
    ((0))
     
     CoversPandemicFlu

    Indicates whether the peril set includes pandemic flu.

    • 1 = Yes (included)
    • 0 = No (not included)
    Boolean1 
    ((0))
     
     CoversNC

    Indicates whether the peril set includes the non-catastrophe model.

    • 1 = Yes (included)
    • 0 = No (not included)
    Boolean1 
    ((0))
     
    Objects that depend on tPerilSet
     Database ObjectObject TypeDescriptionDep Level
    tConvertUPXPerilSet tabletConvertUPXPerilSetTable

    Stores information regarding the peril codes when using UPX files. This information is used to convert peril codes from UPX files for use in Touchstone.

    1
    tCountryPerilXref tabletCountryPerilXrefTableSystem reference table used to determine the perils that are associated with a country.1
    tEventSetPerilExclusion tabletEventSetPerilExclusionTable

    Stores information regarding the exclusion of a peril set in a specific event set This table is used when writing combined perils for all models in an event set to the AIRUserSetting Database.

    1
    tImpactRegionPerilSetXref tabletImpactRegionPerilSetXrefTableSystem reference table used to determine the possible geographic areas impacted by specific peril sets. This table is not human-readable.1
    tPeril tabletPerilTable

    Stores the possible perils that are available for use in Touchstone.

    1
    tPerilSetXref tabletPerilSetXrefTableSystem reference table used to determine the individual perils that are associated with each peril set.  This table is used extensively for Geospatial analytics.1
    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.