Stores event losses for one analysis by each combination of company, line of business (LOB), and zone.
Touchstone Re creates one table for each analysis that includes Geography and Zone as output options.
| 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 | ||||
| LOBCode | Numeric code for the line of business that generated the losses. For a complete list of codes, see tReinsuranceLOB Table. | int | 4 | ||||
| TSZoneSID | Unique system-provided identifier of the geographic zone that generated the losses. For a complete list of zones, see tRRRR_LOSS_DimReZone 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 | |