Stores information about exposure view filters, such as filter code and entered date.
Touchstone 2022 Database Reference
tFilter Table
| Creation Date | 4/4/2022 3:02 AM |
| File Group | PRIMARY |
| Text File Group | PRIMARY |
| System Object |  |
| Published for Replication | |
| Rows | 2 |
| Data Space Used | 8.00 KB |
| Index Space Used | 24.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | FilterSID | Unique system-generated sequential identifier for the filter record. | int | 4 | |||
| FilterTypeCode | Code that represents the filter type. For a complete list of codes, see tFilterType Table. | varchar | 10 | ||||
| FilterName | Name of the filter. | varchar | 255 |  | |||
| EnteredDate | Date and time when the filter was created. | datetime | 4 | (getutcdate()) | |||
| EditedDate | Date and time when the filter was last modified. | datetime | 4 | (getutcdate()) | |||
| RowVersion | Used for version stamping. | timestamp | 8 | ||||
| IsCommerical | Indicates whether the entire commercial contract is part of the exposure view.
| bit | 1 | | ((0)) | ||
| SQLString | SQL representation of the filter conditions. | varchar | 16 | | |||
| Expression | XML string that defines the filter conditions. Used internally by Touchstone. | xml | 0 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tAnalysisFilterXRef | Table | System reference table used to the identify the filters associated with each analysis. | 1 |
| tExposureViewFilterXRef | Table | System reference table used to identify the exposure view filters. | 1 |