Touchstone 4.0 Database Documentation
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
Rows193552
Data Space Used3,640.00 KB
Index Space Used5,056.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.

Integer4   
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 the possible perils that are available for use in Touchstone.

1
tPerilSet tabletPerilSetTable

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

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.