Stores information about reinsurance treaties that incurred loss during the analysis.
You can get more information about the reinsurance treaties by joining the table to the tAnalysisReinsurance Table.
Touchstone creates one table for each analysis that included Treaty as an output option.
| Creation Date | 4/11/2022 6:15 PM |
| File Group | PRIMARY |
| Text File Group | |
| 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 | |
|---|---|---|---|---|---|---|---|
 | ReinsuranceSID | Unique system-generated sequential identifier for the reinsurance record. For a complete list of records, see tReinsurance Table. | int | 4 | |||
| ReinsuranceTypeCode | Code that represents the reinsurance type. For a compete list of codes, see tReinsuranceType Table. | varchar | 10 | ||||
| ReinsuranceID | User-defined identifier for the reinsurance treaty. | varchar | 100 |  |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tRRRR_LOSS_ByReinsurance | Table | Stores event losses for one detailed loss analysis by reinsurance treaty. Touchstone creates one table for each analysis that included a reinsurance program. | 1 |
| tRRRR_LOSS_ByReinsuranceExposureAttribute | Table | Stores event losses for one detailed loss analysis by each combination of reinsurance treaty and exposure attribute. Touchstone creates one table for each analysis that included a Geography as an output option and a reinsurance program as an analysis option. | 1 |
| tRRRR_LOSS_ByReinsuranceExposureAttributeGeo | Table | Stores event losses for one detailed loss analysis by each combination of reinsurance treaty, exposure attribute, and geography. Touchstone creates one table for each analysis that included a Geography and Line of Business as output options and a reinsurance program as an analysis option. | 1 |
| tRRRR_LOSS_ByReinsuranceGeo | Table | Stores event losses for one detailed loss analysis by each combination of reinsurance program and geography. Touchstone creates one table for each analysis that included Subarea (or a higher geographic resolution) as an output option and a reinsurance program as an analysis option. | 1 |