When the analysis target is an exposure view, this table defines the exposure set(s) included in the exposure view.
Touchstone 2022 Database Reference
tAnalysisExposureView Table
| Creation Date | 4/11/2022 6:15 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 | |
|---|---|---|---|---|---|---|---|
 | ResultSID | Unique system-generated sequential identifier for the results record. For a complete list of records, see tAnalysisResult Table. | int | 4 | |||
| | ExposureViewSID | Unique system-generated sequential identifier for the exposure view record. For a complete list of records, see tExposureView Table. | int | 4 | |||
| ExposureViewName | Name of the exposure view. | varchar | 255 | ||||
| Description | User-provided description of the exposure view. | varchar | 4000 |  | |||
| SQLString | SQL representation of the exposure view filter. | varchar | 16 | | |||
| Expression | XML string that defines the exposure view filter. Used internally by Touchstone. | xml | 0 | | |||
| IsCommercial | Indicates whether the filter is applied at the contract level or the location level for commercial contracts.
| bit | 1 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tAnalysisExposureViewDefinition | Table | When the analysis target is an exposure view, this table defines the exposure set(s) included in the exposure view. | 1 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
| tAnalysisResult | Table | Contains general information about the analyses that produced the results. The table contains one row for each analysis in the database, regardless of the analysis type (Loss, Loss Grouping, Catastrophe Excess of Loss, or Marginal Impact). | 1 |