Stores information about layers that experienced loss in the analysis. This dimension table is created when losses are saved by layer.
Touchstone 2022 Database Reference
tRRRR_LOSS_DimLayer 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 | |
|---|---|---|---|---|---|---|---|
 | ExposureDataSourceSID | Unique system-generated sequential identifier for the exposure data source record. For a complete list of records, see tDataSource Table. | int | 4 | |||
| | LayerSID | Unique system-generated sequential identifier for the layer. For a complete list of records, see tLayer Table. | int | 4 | |||
| ExposureSetName | Name of the exposure set. | varchar | 255 |  | |||
| ContractID | Unique user-provided identifier for the contract. | varchar | 100 | | |||
| LayerID | User-provided identifier for the layer. | varchar | 60 | | |||
| InsuredName | Client's name. | varchar | 60 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tRRRR_LOSS_ByContractGeoLayer | Table | 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. | 1 |
| tRRRR_LOSS_ByContractZoneLayer | Table | 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. | 1 |
| tRRRR_LOSS_ByLayer | Table | Stores layer-level loss results from a detailed Loss analysis. This table is created when the user specifies "Save Loss By Layer" in the analysis Output Options. | 1 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
| tRRRR_LOSS_DimExposureDataSource | Table | Stores information about databases that contain exposures that have been analyzed. This dimension table is created for every Loss analysis. | 1 |