Stores information about exposure views used as analysis targets and the filters used to create the exposure views.
Touchstone 2022 Database Reference
tAnalysisExposureView Table
| Creation Date | 4/11/2022 5:46 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 needs to e applied at the contract level (vs. location level) for commercial contracts.
| bit | 1 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tAnalysisExposureViewDefinition | Table | Stores the exposure set(s) included in each exposure view used as an analysis target. | 1 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
| tAnalysisResult | Table | Contains general information about the analyses that produced the results. The table includes one row for each analysis in the database, regardless of the analysis type (Loss, Loss Grouping, Catastrophe Excess of Loss, or Marginal Impact). | 1 |