Touchstone 4.0 Database Documentation
tUNICEDE2Coverage Table
Description

Stores information regarding coverage types that can be used in UNICEDE/2. This information is used to enable the use of the UNICEDE/2 coverage type codes in Touchstone.

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

Code that represents the UNICEDE/2 coverage type.

  • 1 = B (Buildings only)
  • 2 = C (Contents only)
  • 3 = BC (Buildings and contents combined)
  • 4 = T (Time element only)
  • 7 = BCT (Buildings, contents, and time element combined)
  • 8 = A (Automobiles only)
  • 16 = W (Workers' Compensation)
  • 32 = MS (Market share only)
  • 39 = BCTMS (Buildings, contents, time element, and market share)
  • 40 = AUTOMS (Auto and market share)
  • 48 = WMS (Workers Comp. and market share)
  • 49 = PD (Physical damage -Gulf of Mexico Offshore Platform only)
  • 75 = CL (Custom)
UnsignedTinyInt1   
 UNICEDE2Coverage

Name of the UNICEDE/2 coverage type.

Corresponds to the code in UNICEDE2Coverage.

VarChar40  
 Description

Description of the UNICEDE/2 coverage type.

Corresponds to the code in UNICEDE2Coverage.

VarChar1024  
Objects that depend on tUNICEDE2Coverage
 Database ObjectObject TypeDescriptionDep Level
tUNICEDE2CoverageLOBXref tabletUNICEDE2CoverageLOBXrefTable

System reference table used to identify the Line of Business by coverage that can be used in UNICEDE/2. This information is used to enable the use of the UNICEDE/2 Line of Business by coverage codes 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.