Touchstone Re 2022 Database Reference
tCLFUpgradeDetails Table
AIRReference Database : tCLFUpgradeDetails Table
Description
Stores mappings between legacy and current UNICEDE/2 area and line of business codes.
Properties
Creation Date1/23/2018 1:33 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows98142
Data Space Used4,192.00 KB
Index Space Used48.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key CLFAreaLobIndexInternal identifier for the area and line of business combination.int4   
Primary Key CountrycodeInternal identifier for the country.int4   
Primary Key OldLegacyAreacodeInternal identifier for the legacy area code.bigint8   
Primary Key NewLegacyAreacodeInternal identifier for the corresponding current area code.bigint8   
Primary Key OldLobIndexInternal identifier for the legacy line of business.tinyint1   
Primary Key NewLobIndexInternal identifier for the corresponding current line of business.tinyint1   
 WeightWeight of the mapping.float9   
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.