Touchstone Re 2022 Database Reference
tPerilSetXref Table
AIRReference Database : tPerilSetXref Table
Description
System reference table used to determine the individual perils that are associated with each peril set.  This table is used extensively for geospatial analytics.
Properties
Creation Date11/23/2011 3:44 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows201326614
Data Space Used3,801,896.00 KB
Index Space Used5,240,984.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key PerilSetCode

Code that represents a single peril or set of perils.

For a complete list of codes, see tPerilSet Table.

int4   
Primary Key PerilCode

Code that represents the peril type.

For a complete list of codes, see tPeril Table.

varchar10   
Objects that tPerilSetXref depends on
 Database ObjectObject TypeDescriptionDep Level
tPeril tabletPerilTable

Stores codes that represent the perils supported by the application.

1
tPerilSet tabletPerilSetTable

Stores codes that represent the perils sets supported by the application.

Additional peril sets used by Touchstone Re are listed in tPerilSetCombined Table.

1
See Also

Related Objects

AIRReference Database

 

 

Verisk Analytics Client Confidential

© 2022. AIR Worldwide is now Extreme Event Solutions. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact Verisk Analytics with questions or comments.