Touchstone 2022 Database Reference
tFilterAttribute Table
AIRReference Database : tFilterAttribute Table
Description

Stores the possible filters that are available for the activities

Properties
Creation Date2/16/2011 6:00 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows6
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key FilterAttributeCode

Code that represents the filter attribute.

  • 1 = Peril
  • 2 = Geography
  • 3 = Construction Type
  • 4 = Occupancy Type
  • 5 = User Line of Business
int4   
 FilterAttribute

Type of information affected by the filter.

Corresponds to the code in FilterAttributeCode.

varchar40  
 DescriptionDescription of the filter attribute type.varchar1024  
 FilterAttributeGroupCategorization for the filter attribute.varchar40  
Objects that depend on tFilterAttribute
 Database ObjectObject TypeDescriptionDep Level
tFilterAttributeActivityTypeXref tabletFilterAttributeActivityTypeXrefTableSystem reference table used to determine the possible activities that can be applied to specific filter attributes.1
tResultTemplateFilterAttributeXRef tabletResultTemplateFilterAttributeXRefTableSystem reference table used to determine the filter attributes that are applied to the results.1
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.