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 5:46 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 the reinsurance treaty loss results from a detailed loss analysis. This table is created when the user specifies any reinsurance type in the analysis Output Options. | 1 |
| tRRRR_LOSS_ByReinsuranceExposureAttribute | Table | Stores the reinsurance results by exposure attribute from a detailed loss analysis. This table is created when the user specifies "Save Loss By Geography" and selects any reinsurance type in the analysis Output Options. | 1 |
| tRRRR_LOSS_ByReinsuranceExposureAttributeGeo | Table | Stores the reinsurance results by exposure attribute from a detailed loss analysis. This table is created when the user specifies "Save Loss By Line of Business and Geography" and selects any reinsurance type in the analysis Output Options. | 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 |