Stores event losses for one detailed loss analysis by each combination of contract, zone, and layer.
Touchstone creates one table for each contract analysis that includes Contract, Zone, 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 that generated the losses. 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 generated the losses. 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 tDataSource Table. | int | 4 | |||
| | ContractSID | Unique system-generated sequential identifier for the contract record. For a complete list of records, see tContract Table. | int | 4 | |||
| | GlobalZoneSID | Unique system-generated identifier for the zone. For a complete list of records, see tGlobalZone Table. | int | 4 | |||
| | LayerSID | Unique system-generated sequential identifier for the layer. For a complete list of records, see tLayer Table. | int | 4 | |||
| GroundUpLoss | Ground-up loss value before Touchstone applies terms. For 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 value before Touchstone applies catastrophe excess of loss reinsurance. | float | 9 | | |||
| PostCATNetLoss | Net of post-catastrophe loss value, which is the expected net loss value after Touchstone applies 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 loss 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 workers' 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 deviation 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 associated with the simulated event. Touchstone computes the claims count by estimating the loss in excess of location deductibles. Consequently, uncertainty is included 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 |