| Creation Date | 4/11/2022 5:46 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 | 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. 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, 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 value 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 | 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 worker's compensation fatal medical injury. | float | 9 | | |||
| GrossLoss_Minor | Gross loss value for workers's 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 for fatal medical injury. | float | 9 | | |||
| NetOfPreCATLoss_Minor | Net of pre-catastrophe loss value for worker's 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 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 worker's 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 devation 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 uncertainy 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 |