Stores event losses for one detailed loss analysis by each combination of contract, layer, and geography.
Touchstone creates one table for each analysis that includes Contract, Geography, and Layer as output options.
| 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 | |
|---|---|---|---|---|---|---|---|
 | 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 | Identifier of the event that generated the losses. | int | 4 | |||
| | ModelCode | Code that represents the AIR model associated with the event that generated 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. For a complete list of codes, see tPerilSet Table. | 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 | |||
| | ContractSID | Unique system-generated sequential identifier for the contract record. For a complete list of records, see tContract Table. | int | 4 | |||
| | GeographySID | Unique system-generated sequential identifier for the geographic record. For a complete list of records, see tGeography Table. | int | 4 | |||
| | LayerSID | Unique system-generated sequential identifier for the layer record. For a complete list of records, see tLayer Table. | int | 4 | |||
| GroundUpLoss | Ground-up loss value before Touchstone applies terms. For treaty reinsurance, GroundUpLoss 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 value before Touchstone applies layer terms. | float | 9 | | |||
| GrossLoss | Gross loss value, which is the loss after Touchstone applies 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 | | |||
| PostCATNetLoss | Net of post-catastrophe loss value, which is the expected net loss after the application of catastrophe excess of loss reinsurance. | float | 9 | | |||
| TotalPerRiskReRecoveryLoss | Total expected per-risk reinsurance recovery loss value. | float | 9 | | |||
| GroundUpSD | Standard deviation of the ground-up loss value. | float | 9 | | |||
| RetainedSD | Standard deviation of the retained loss value. | float | 9 | | |||
| PreLayerGrossSD | Standard deviation of the pre-layer gross value. | float | 9 | | |||
| GrossSD | Standard deviation of the gross loss value. | float | 9 | | |||
| GroundUpMaxLoss | Maximum ground-up loss value. | float | 9 | | |||
| RetainedMaxLoss | Maximum retained loss value. | float | 9 | | |||
| PreLayerGrossMaxLoss | Maximum pre-layer gross loss value. | float | 9 | | |||
| GrossMaxLoss | Maximum gross loss value. | float | 9 | | |||
| GroundUpLoss_Minor | Ground-up loss value for workers' compensation minor medical injury. | float | 9 | | |||
| GroundUpLoss_Moderate | Ground-up loss value for workers' compensation moderate medical injury. | float | 9 | | |||
| GroundUpLoss_Major | Ground-up loss value for workers' compensation major medical injury. | float | 9 | | |||
| GroundUpLoss_Fatal | Ground-up loss value for workers' compensation fatal medical injury. | float | 9 | | |||
| GrossLoss_Minor | Gross loss value for workers' compensation minor medical injury. | float | 9 | | |||
| GrossLoss_Moderate | Gross loss value for workers' compensation moderate medical injury. | float | 9 | | |||
| GrossLoss_Major | Gross loss value for workers' compensation major medical injury. | float | 9 | | |||
| GrossLoss_Fatal | Gross loss value for workers' compensation fatal medical injury. | float | 9 | | |||
| NetOfPreCATLoss_Minor | Net of pre-catastrophe loss value for workers' compensation minor medical injury. | float | 9 | | |||
| NetOfPreCATLoss_Moderate | Net of pre-catastrophe loss value for workers' compensation moderate medical injury. | float | 9 | | |||
| NetOfPreCATLoss_Major | Net of pre-catastrophe loss value for workers' compensation major medical injury. | float | 9 | | |||
| NetOfPreCATLoss_Fatal | Net of pre-catastrophe loss value for workers' compensation fatal medical injury. | float | 9 | | |||
| PostCATNetLoss_Minor | Net of post-catastrophe loss value for workers' compensation minor medical injury. | float | 9 | | |||
| PostCATNetLoss_Moderate | Net of post-catastrophe loss value for workers' compensation moderate medical injury. | float | 9 | | |||
| PostCATNetLoss_Major | Net of post-catastrophe loss value for workers' compensation major medical injury. | float | 9 | | |||
| PostCATNetLoss_Fatal | Net of post-catastrophe loss value for workers' compensation fatal medical injury. | float | 9 | | |||
| InjuryCount_Minor | Number of workers' compensation minor medical injuries. | float | 9 | | |||
| InjuryCount_Moderate | Number of workers' compensation moderate medical injuries. | float | 9 | | |||
| InjuryCount_Major | Number of workers' compensation major medical injuries. | float | 9 | | |||
| InjuryCount_Fatal | Number of worker's compensation fatal medical injuries. | float | 9 | | |||
| GroundUpLoss_A | Ground-up loss value for Coverage A. | float | 9 | | |||
| GroundUpLoss_B | Ground-up loss value for Coverage B. | float | 9 | | |||
| GroundUpLoss_C | Ground-up loss value for Coverage C. | float | 9 | | |||
| GroundUpLoss_D | Ground-up loss value for Coverage D. | float | 9 | | |||
| RetainedLoss_A | Retained loss value for Coverage A. | float | 9 | | |||
| RetainedLoss_B | Retained loss value for Coverage B. | float | 9 | | |||
| RetainedLoss_C | Retained loss value for Coverage C. | float | 9 | | |||
| RetainedLoss_D | Retained loss value for Coverage D. | float | 9 | | |||
| PreLayerGrossLoss_A | Pre-layer gross loss value for Coverage A. | float | 9 | | |||
| PreLayerGrossLoss_B | Pre-layer gross loss value for Coverage B. | float | 9 | | |||
| PreLayerGrossLoss_C | Pre-layer gross loss value for Coverage C. | float | 9 | | |||
| PreLayerGrossLoss_D | Pre-layer gross loss value for Coverage D. | float | 9 | | |||
| GrossLoss_A | Gross loss value for Coverage A. | float | 9 | | |||
| GrossLoss_B | Gross loss value for Coverage B. | float | 9 | | |||
| GrossLoss_C | Gross loss value for Coverage C. | float | 9 | | |||
| GrossLoss_D | Gross loss value for Coverage D. | float | 9 | | |||
| NetOfPreCATLoss_A | Net of pre-catastrophe loss value for Coverage A. | float | 9 | | |||
| NetOfPreCATLoss_B | Net of pre-catastrophe loss value for Coverage B. | float | 9 | | |||
| NetOfPreCATLoss_C | Net of pre-catastrophe loss value for Coverage C. | float | 9 | | |||
| NetOfPreCATLoss_D | Net of pre-catastrophe loss value for Coverage D. | float | 9 | | |||
| GroundUpSD_A | Ground-up loss standard deviation for Coverage A. | float | 9 | | |||
| GroundUpSD_B | Ground-up loss standard deviation for Coverage B. | float | 9 | | |||
| GroundUpSD_C | Ground-up loss standard deviation for Coverage C. | float | 9 | | |||
| GroundUpSD_D | Ground-up loss standard deviation for Coverage D. | float | 9 | | |||
| RetainedSD_A | Retained loss standard deviation for Coverage A. | float | 9 | | |||
| RetainedSD_B | Retained loss standard deviation for Coverage B. | float | 9 | | |||
| RetainedSD_C | Retained loss standard devation for Coverage C. | float | 9 | | |||
| RetainedSD_D | Retained loss standard deviation for Coverage D. | float | 9 | | |||
| PreLayerGrossSD_A | Pre-layer gross loss standard deviation for Coverage A. | float | 9 | | |||
| PreLayerGrossSD_B | Pre-layer gross loss standard deviation for Coverage B. | float | 9 | | |||
| PreLayerGrossSD_C | Pre-layer gross loss standard deviation for Coverage C. | float | 9 | | |||
| PreLayerGrossSD_D | Pre-layer gross loss standard deviation for Coverage D. | float | 9 | | |||
| GrossSD_A | Gross loss standard deviation for Coverage A. | float | 9 | | |||
| GrossSD_B | Gross loss standard deviation for Coverage B. | float | 9 | | |||
| GrossSD_C | Gross loss standard deviation for Coverage C. | float | 9 | | |||
| GrossSD_D | Gross loss standard deviation for Coverage D. | float | 9 | | |||
| GroundUpMaxLoss_A | Maximum ground-up loss for Coverage A. | float | 9 | | |||
| GroundUpMaxLoss_B | Maximum ground-up loss for Coverage B. | float | 9 | | |||
| GroundUpMaxLoss_C | Maximum ground-up loss for Coverage C. | float | 9 | | |||
| GroundUpMaxLoss_D | Maximum ground-up loss for Coverage D. | float | 9 | | |||
| RetainedMaxLoss_A | Maximum retained loss for Coverage A. | float | 9 | | |||
| RetainedMaxLoss_B | Maximum retained loss for Coverage B. | float | 9 | | |||
| RetainedMaxLoss_C | Maximum retained loss for Coverage C. | float | 9 | | |||
| RetainedMaxLoss_D | Maximum retained loss for Coverage D. | float | 9 | | |||
| PreLayerGrossMaxLoss_A | Maximum pre-layer gross loss for Coverage A. | float | 9 | | |||
| PreLayerGrossMaxLoss_B | Maximum pre-layer gross loss for Coverage B. | float | 9 | | |||
| PreLayerGrossMaxLoss_C | Maximum pre-layer gross loss for Coverage C. | float | 9 | | |||
| PreLayerGrossMaxLoss_D | Maximum pre-layer gross loss for Coverage D. | float | 9 | | |||
| GrossMaxLoss_A | Maximum gross loss for Coverage A. | float | 9 | | |||
| GrossMaxLoss_B | Maximum gross loss for Coverage B. | float | 9 | | |||
| GrossMaxLoss_C | Maximum gross loss for Coverage C. | float | 9 | | |||
| GrossMaxLoss_D | Maximum gross loss for Coverage D. | float | 9 | | |||
| ClaimsCount | Number of claims caused by the simulated event. Touchstone calculates the count by estimating the loss in excess of location deductibles. Consequently, Touchstone considers uncertainty in the damage estimates. | float | 9 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tRRRR_LOSS_DimContract | Table | Stores information about contracts that experienced Loss in the analysis. This dimension table is generated when losses are saved by contract or by location. | 1 |
| tRRRR_LOSS_DimExposureDataSource | Table | Stores information about databases that contain exposures that have been analyzed. This dimension table is created for every Loss analysis. | 2 |
| tRRRR_LOSS_DimLayer | Table | Stores information about layers that experienced loss in the analysis. This dimension table is created when losses are saved by layer. | 1 |