Stores information about portfolio filters.
Touchstone Re 2022 Database Reference
tPortfolioFilter Table
| Creation Date | 4/11/2022 6:17 PM |
| File Group | PRIMARY |
| Text File Group | PRIMARY |
| System Object |  |
| Published for Replication | |
| Rows | 0 |
| Data Space Used | 0.00 KB |
| Index Space Used | 0.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | PortfolioFilterSID | Unique system-generated sequential identifier for the portfolio filter. | int | 4 | |||
| Expression | XML string that defines the filter conditions. Used internally by Touchstone Re. | varchar | 16 |  | |||
| SqlString | SQL representation of the filter conditions. | varchar | 16 | | |||
| EnteredDate | Date and time the filter was created. | datetime | 4 | | |||
| EditedDate | Date and time the filter was last edited. | datetime | 4 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tPortfolio | Table | Stores information about portfolios. | 1 |
| tPortfolioReinsuranceTreaty | Table | Stores information about reinsurance treaties or layers included in portfolios. | 2 |