Touchstone 4.0 Database Documentation
tFilter Table
Stores information about exposure view filters, such as filter code and entered date.
Creation Date5/31/2016 9:45 AM
Text File GroupPRIMARY
System Object
Published for Replication
Data Space Used0.00 KB
Index Space Used0.00 KB
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key FilterSIDUnique system-generated sequential identifier for the filter record.Integer4   

Code that represents the filter type.

For a complete list of codes, see tFilterType Table.

 FilterNameName of the filter.VarChar255  
 EnteredDateDate and time when the filter was created.DBTimeStamp4 
 EditedDateDate and time when the filter was last modified.DBTimeStamp4 
 RowVersionUsed for version stamping.Binary8   
 IsCommericalIndicates whether the entire commercial contract is part of the exposure view.
  • 1 = Yes (include)
  • 0 = No (do not include)
 SQLStringSQL representation of the filter conditions.LongVarChar16  
 ExpressionXML string that defines the filter conditions. Used internally by Touchstone.Xml16  
Objects that depend on tFilter
 Database ObjectObject TypeDescriptionDep Level
tAnalysisFilterXRef tabletAnalysisFilterXRefTableSystem reference table used to the identify the analysis IDs, as well as their associated filters.2
tExposureViewFilterXRef tabletExposureViewFilterXRefTableSystem reference table used to identify the exposure view filters.2
See Also

Related Objects

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