Touchstone 4.0 Database Documentation
tFilterAttribute Table

Stores the possible filters that are available for the activities

Creation Date2/16/2011 6:00 PM
Text File Group
System Object
Published for Replication
Data Space Used8.00 KB
Index Space Used8.00 KB
 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

Type of information affected by the filter.

Corresponds to the code in FilterAttributeCode.

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