Stores event losses for one analysis by each combination of reinsurance portfolio and net of premiums.
Touchstone Re 2022 Database Reference
tRRRR_LOSS_ByRePortfolioNetOfPremiums Table
| 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 | |||
| | YearID | Unique system-generated identifier of the year that produced the loss. | int | 4 | |||
| | PortfolioSID | Numeric code for the single peril or set of perils. For a complete list of codes, see tPerilSet table. | int | 4 | |||
| NetOfPremiums100Participation | Net of premium loss at 100% participation. | float | 9 |  | |||
| NetOfPremiumsGrossParticipation | Final net of premium loss at the gross participation level. | float | 9 | | |||
| NetOfPremiumsNetParticipation | Final net of premium loss at the net participation level. | float | 9 | | |||
| NetOfPremiumsParticipation3 | Net of premium loss user-defined participation percent. | float | 9 | | |||
| NetOfPremiumsParticipation4 | Net of premium loss user-defined participation percent. | float | 9 | |