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

Code that represents the filter type.

For a complete list of codes, see tFilterType Table.

VarChar10   
 FilterNameName of the filter.VarChar255  
 EnteredDateDate and time when the filter was created.DBTimeStamp4 
(getutcdate())
 
 EditedDateDate and time when the filter was last modified.DBTimeStamp4 
(getutcdate())
 
 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)
Boolean1
((0))
 
 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.