Touchstone 4.0 Database Documentation
TblMexicoHUEQ_Xref Table
Description
System reference table that stores information used to map Mexico's hurricane and earthquake CRESTA codes between Touchstone and CATRADER. Used for UNICEDE export.
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.

Integer4   
 fltWeightWeight value.Numeric9 (10,9)   
See Also

Related Objects

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