tDQRuleSubType Table

Description

Stores the specialized rules (sub rules) that can be applied during a Data Quality analysis. These rules are designed to only affect specific exposure data, such as Employee Count or Secondary Risk Characteristics.

Properties

Creation Date	2/16/2011 6:00 PM
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	24
Data Space Used	8.00 KB
Index Space Used	24.00 KB

Columns

Column Name	Description	Datatype	Length
DQRuleSubTypeCode	Code that represents the sub rule. 1 = Geographic 2 = Coverage 3 = Primary Risk Characteristics 4 = Secondary Risk Characteristics 5 = Construction / Age 6 = Construction / Age / Height 7 = Construction / Occupancy 8 = Construction / Height 9 = Occupancy / Height 10 = Geography / Construction 11 = Geocode Data 12 = Replacement Value A 13 = Primary Risk Characteristics 14 = Secondary Risk Characteristics 15 = Employee Count 17 = If Replacement Value for Building Changes Then Update... 19 = Values and Terms 20 = Building Detail 21 = Roof Detail 22 = Wall Detail 23 = Connection Detail 24 = Tenant Policy 25 = Location Exclusion 26 = Bulk	int	4
DQRuleSubType	Name (categorization) of the sub rule. Corresponds to the code in DQRuleSubTypeCode.	varchar	200
Description	Description of the sub rule.	varchar	1024
ParentDQRuleSubTypeCode	Identifies the parent rule to which these rules apply. For example, sub rule type 18 (Building Detail) has a parent rule sub type of 4 (Secondary Risk Characteristics).	int	4

Related Objects

AIRReference Database

Verisk Analytics Client Confidential

Please contact Verisk Analytics with questions or comments.