Touchstone 2022 Database Reference
tUNICEDE2CountryAreaTagXref Table
AIRReference Database : tUNICEDE2CountryAreaTagXref Table
Description

System reference table used to identify the CATRADER countries that can be used in UNICEDE/2. This information is used to enable the use of UNICEDE/2 countries codes in Touchstone.

Properties
Creation Date1/10/2012 12:17 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows96
Data Space Used8.00 KB
Index Space Used24.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key AreaTagCode

Code that represents the geographic Area type.

For a complete list of codes, see tUNICEDE2AreaTag Table.

tinyint1   
Primary Key OldAreaLevel1Code that represents the country in CATRADER.smallint2   
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   
 AreaTagFormatFormat for the area tag.varchar1000  
 StepLevel

Used internally to sequence UNICEDE export programmatically.

tinyint1  
Objects that tUNICEDE2CountryAreaTagXref depends on
 Database ObjectObject TypeDescriptionDep Level
tUNICEDE2AreaTag tabletUNICEDE2AreaTagTable

Stores information regarding geographic Area types that can be used in UNICEDE/2. This information is used to enable the use of UNICEDE/2 areas types in Touchstone.

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.