Touchstone 4.0 Database Documentation
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 Date2/16/2011 6:00 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows24
Data Space Used8.00 KB
Index Space Used24.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key 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
Integer4   
 DQRuleSubType

Name (categorization) of the sub rule.

Corresponds to the code in DQRuleSubTypeCode.

VarChar200  
 DescriptionDescription of the sub rule.VarChar1024  
 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).

Integer4  
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.