Touchstone 4.0 Database Documentation
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
Rows5
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
Integer4   
 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.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.