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.
| 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 | |
|---|---|---|---|---|---|---|---|
 | CatalogTypeCode | Code that represents the type of catalog used to produced the loss. For a complete list of codes, see tCatalogType Table. | varchar | 10 | |||
| | EventID | Unique system-provided identifier of the event that produced the loss. | int | 4 | |||
| | ModelCode | Code that represents the AIR model, associated with the event that produced the highest loss in the simulated year. For a complete list of codes, see tModel Table. | smallint | 2 | |||
| | YearID | Unique identifier that tracks the scenario. In multi-year catalogs, each scenario actually consists of five modeled years. | int | 4 | |||
| | PerilSetCode | Numeric code for the single peril or set of perils. For a complete list of codes, see tPerilSet Table. | int | 4 | |||
| | ReinsuranceSID | Unique system-generated sequential identifier for the reinsurance record. For a complete list of records, see tReinsurance Table. | int | 4 | |||
| | ExposureAttributeSID | Unique system-generated sequential identifier for the exposure attribute record. | int | 4 | |||
| GroundUpLoss | Ground-Up loss value prior to the application of terms. For reinsurance, this is the ground-up loss for the treaty. | float | 9 |  | |||
| GrossLoss | Gross loss value, which is the loss after layer-level terms are applied. | float | 9 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tRRRR_LOSS_DimExposureAttribute | Table | Stores specific exposure attribute values that were 1) used to aggregate losses and 2) experienced loss in the analysis. For example, if the loss results were saved by line of business, this table will include one row for every line of business that had a loss. The ExposureAttributeTypeCode would be ‘ULOB’, and the ExposureAttribute values would contain the names of the lines of business. This dimension table is created when losses are saved by any exposure attribute, such as Line of Business. | 1 |
| tRRRR_LOSS_DimReinsurance | Table | 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. | 1 |