Stores information about the geographic areas to which reinsurance treaties are applied.
Touchstone 2022 Database Reference
tAnalysisReinsAppliesToGeo 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 | |||
| | ReinsuranceSID | Unique system-generated sequential identifier for the reinsurance record. For a complete list of records, see tReinsurance Table. | int | 4 | |||
| | ReinsAppliesToGeoSID | Unique system-generated sequential identifier for the geography filter record to which the reinsurance applies. For a complete list of records, see tReinsAppliesToGeo Table. | int | 4 | |||
| SQLString | SQL representation of the geography filter. | varchar | 16 | ||||
| Expression | XML string that defines the geography filter. Used internally by Touchstone. | xml | 0 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tAnalysisReinsurance | Table | Stores information about any reinsurance treaties considered during the analyses. | 1 |
| 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). | 2 |