Touchstone 4.0 Database Documentation
tCountryPerilXref Table
Description
System reference table used to determine the perils that are associated with a country.
Properties
Creation Date7/24/2012 12:08 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows210
Data Space Used8.00 KB
Index Space Used24.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key CountryCode

ISO 2-character code for the country in which the location resides. 

For a complete list of codes, see tCountry Table.

VarChar15   
Primary Key MainPerilSetCode

Code that represents the peril set. 

For a complete list of codes, see tPerilSet Table.

Integer4   
 CombinedPerilSetCode

Code for the combined peril set that is available for use in the country.

For a complete list of codes, see tPerilSet Table.

Integer4   
Objects that tCountryPerilXref depends on
 Database ObjectObject TypeDescriptionDep Level
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.