Touchstone 2022 Database Reference
TblMexicoHUEQ_Xref Table
AIRGeography Database : TblMexicoHUEQ_Xref Table
Description

Stores the Touchstone CRESTA code that corresponds to each CATRADER CRESTA code for the hurricane and earthquake perils in Mexico.

The application uses the information to export UNICEDE data.

Properties
Creation Date5/31/2012 3:47 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows14137
Data Space Used840.00 KB
Index Space Used16.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key strZone

CRESTA codes.

For a complete list of codes, see tGeography Table.

varchar16   
Primary Key strPostal

Postal code.

For a complete list of codes, see tGeography Table.

varchar16   
 intAltCode2CATRADER CRESTA codes.smallint2  
 strNameName of the CRESTA code.varchar60  
Primary Key intWeightTypeId

Identifier for the weight type. 

For a complete list of weight types, see TblAreaWeightType Table.

int4   
 fltWeightWeight value.numeric9 (10,9)   
See Also

Related Objects

AIRGeography 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.