Stores losses for the realistic disaster scenarios (RDS) events included in a marginal impact analysis.
Touchstone 2022 Database Reference
tRRRR_IMPACT_Deterministic Table
| 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 | |
|---|---|---|---|---|---|---|---|
 | ImpactAdminBoundaryPerilID | Identifier for the administrative boundary and peril combination associated with the results. For a complete list of combinations, see tImpactAdminBoundaryPerilSetXref Table. | smallint | 2 | |||
| | OutputTypeCode | Code that represents the type of output generated during the analysis. For a complete list of codes, see tOutputType Table. | varchar | 10 | |||
| | CatalogTypeCode | Code that represents the type of catalog used to produce 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 | |||
| | ModelCode | Code that represents the AIR model associated with the event that produced the loss. For a complete list of codes, see tModel Table. | smallint | 2 | |||
| | YearID | Unique identifier that tracks the scenario associated with the loss. 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. For a complete list of codes, see tPerilSet Table. | 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 |  | |||
| RetainedLoss | Retained loss value, which is the ground-up loss minus the insured gross loss. | float | 9 | | |||
| PreLayerGrossLoss | Pre-layer gross loss value, which is the expected gross loss before the application of layer terms. | float | 9 | | |||
| GrossLoss | Gross loss value, which is the loss after the application of layer terms. | float | 9 | | |||
| NetOfPreCATLoss | New of pre-catastrophe loss value, which is the expected net loss before the application of catastrophe excess of loss reinsurance. | float | 9 | | |||
| PostCATNetLoss | Net of post-catastrophe loss value, which is the expected net loss after the application of catastrophe excess of loss reinsurance. | float | 9 | |