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 Date	1/10/2012 12:17 PM
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	13
Data Space Used	8.00 KB
Index Space Used	8.00 KB

Columns

Column Name	Description	Datatype	Length
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)	tinyint	1
UNICEDE2Coverage	Name of the UNICEDE/2 coverage type. Corresponds to the code in UNICEDE2Coverage.	varchar	40
Description	Description of the UNICEDE/2 coverage type. Corresponds to the code in UNICEDE2Coverage.	varchar	1024

Column Name

Description

Datatype

Length

Allow Nulls

Default

Formula

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)

tinyint

UNICEDE2Coverage

Name of the UNICEDE/2 coverage type.

Corresponds to the code in UNICEDE2Coverage.

varchar

Description

Description of the UNICEDE/2 coverage type.

Corresponds to the code in UNICEDE2Coverage.

varchar

1024

Objects that depend on tUNICEDE2Coverage

	Database Object	Object Type	Description	Dep Level
	tUNICEDE2CoverageLOBXref	Table	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

Related Objects

AIRReference Database

Verisk Analytics Client Confidential

Please contact Verisk Analytics with questions or comments.