Touchstone Re 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 

Code that represents the filter attribute.

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

Type of information affected by the filter.

Corresponds to the code in FilterAttributeCode.

varchar40  
 Description of the filter attribute type.varchar1024  
 Categorization 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
See Also

Related Objects

AIRReference Database