Stores event losses for one analysis by company.
Touchstone Re creates one table for each analysis.
Touchstone Re 2022 Database Reference
tRRRR_LOSS_ByReCompany Table
Stores event losses for one analysis by company.
Touchstone Re creates one table for each analysis.
| Creation Date | 4/11/2022 6:17 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 that 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 | ||||
| DayID | Identifier of the date that generated the losses. | int | 4 | ||||
| YearID | Identifier of the year that generated the losses. | int | 4 | ||||
| ModelCode | Code that represents the catastrophe model that generated the losses. For a complete list of codes, see tModel Table. | smallint | 2 | ||||
| PerilSetCode | Numeric code for the single peril or set of perils. For a complete list of codes, see tPerilSet Table. | int | 4 | ||||
| ReProgramSID | Unique system-provided identifier for the reinsurance program record. For a complete list of records, see tReinsuranceProgram Table. | int | 4 | ||||
| PreCatLoss | Expected loss before the application of treaty reinsurance terms. | float | 9 |  | |||
| NetRetainedLoss | Expected loss retained by the ceding company after netting out reinsurance contract losses. | float | 9 | |