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.
| 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 | |
|---|---|---|---|---|---|---|---|
 | CatalogTypeCode | Code that represents the type of catalog used to generate the losses. For a complete list of codes, see tCatalogType Table. | varchar | 10 | |||
| | EventID | Unique system-provided identifier of the event that generated the losses. | int | 4 | |||
| | ModelCode | Code that represents the AIR model associated with the event that generated 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, a scenario 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 | |||
| | GeographySID | Unique system-generated sequential identifier for the geographic record. For a complete set of records, see tGeography Table. | int | 4 | |||
| GroundUpLoss | Ground-up loss value before Touchstone applies terms. For reinsurance, GroundUpLoss is the ground-up loss for the treaty. | float | 9 |  | |||
| GrossLoss | Gross loss value, which is the loss after Touchstone applies layer terms. | float | 9 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tRRRR_LOSS_DimExposureAttribute | Table | Stores information about each exposure attribute that:
Touchstone creates the dimension table for each analysis that included an exposure attribute, such as line of business, as an output option. For example, if a user saved losses by line of business, the table includes one row for each line of business that generated loss. The ExposureAttributeTypeCode would be ‘ULOB’, and the ExposureAttribute values would contain the names of the lines 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 |