Stores information about the events used during the Comparative Loss analysis.
Touchstone 2022 Database Reference
tRRRR_CMPLOSS_EventKey Table
Stores information about the events used during the Comparative Loss analysis.
| 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 | |
|---|---|---|---|---|---|---|---|
 | EventRowID | System-assigned table row identifier for the event. | bigint | 8 | |||
| CatalogTypeCode | Code that represents the catalog type. For a complete list of codes, see dbo.tCatalogType Table. | varchar | 10 | ||||
| ModelCode | Code that represents the model. For a complete list of codes, see dbo.tModel Table. | smallint | 2 | ||||
| EventID | System-generated identifier for the event used during the comparative analysis. | int | 4 |  | |||
| YearID | Unique identifier that tracks the scenario. In multi-year catalogs, each scenario actually consists of five modeled years. | int | 4 | | |||
| PerilSetCode | Numeric code for the single peril or set of perils. For a complete list of codes, see dbo.tPerilSet Table. | int | 4 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tRRRR_TTTT_CMPLOSS_AnnualEP | Table | Stores the deltas for the aggregate annual exceedance probability losses that are calculated during a Comparative Loss analysis.
tRRRR denotes the Results SID for the Comparative Loss analysis and TTTT represents the identifier for the loss analysis.
| 1 |
| tRRRR_TTTT_CMPLOSS_ByEvent | Table | Stores the deltas for the aggregate event losses that are calculated during a Comparative Loss analysis.
tRRRR denotes the Results SID for the Comparative Loss analysis and TTTT represents the identifier for the loss analysis.
| 1 |