Stores event losses for a detailed loss analysis by layer.
Touchstone creates one table for each analysis when you select save losses by the "By Treaty" option in a detailed loss analysis. This option appears only for users of the NGM Technical Preview.
| Creation Date | 4/11/2022 6:15 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 0 |
| Data Space Used | 16.00 KB |
| Index Space Used | 0.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
| PartitionID | Unique system-generated identifier used by the loss analysis engine to partition slice tables. | int | 4 | ||||
| CatalogTypeCode | Code that represents the type of catalog used to produce the loss. | 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 consists of five modeled years. | int | 4 | ||||
| PerilSetCode | Numeric code for the peril or set of perils that produced the loss. | int | 4 | ||||
| ExposureDataSourceSID | Unique system-generated sequential identifier for the exposure data source record. For a complete list of records, see tDataSourceType Table. | int | 4 | ||||
| LayerSID | Unique system-generated sequential identifier for the layer record. | int | 4 | ||||
| ReinsuranceSID | Unique system-generated sequential identifier for the reinsurance record. | int | 4 | ||||
| GroundUpLoss | Ground-up loss value, which is the loss prior to the application of terms. For treaty reinsurance, this is the ground-up loss for the treaty. | float | 9 |  | |||
| GrossLoss | Gross loss value, which is the loss after the application of layer terms. | float | 9 | | |||
| NetOfPreCATLoss | Net of pre-catastrophe loss value, which is the expected net loss before the application of catastrophe excess of loss reinsurance. | float | 9 | | |||
| RecoveryLoss | Recovery loss value. | float | 9 | | |||
| GroundUpSD | Standard deviation of the ground-up loss value. | float | 9 | | |||
| GrossSD | Standard deviation of the gross loss value. | float | 9 | | |||
| NetOfPreCATSD | Standard deviation of the net of pre-catastrophe loss value. | float | 9 | | |||
| RecoverySD | Standard deviation of the recovery loss value. | float | 9 | | |||
| GroundUpMaxLoss | Maximum ground-up loss value. | float | 9 | | |||
| GrossMaxLoss | Maximum gross loss value. | float | 9 | | |||
| NetOfPreCATMaxLoss | Maximum of net of pre-catastrophe loss value. | float | 9 | | |||
| RecoveryMaxLoss | Maximum of recovery loss value. | float | 9 | |