Stores information about databases that contain exposures that have been analyzed. This dimension table is created for every Loss analysis.
Touchstone 2022 Database Reference
tRRRR_LOSS_DimExposureDataSource 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 | |||
| ExposureDataSourceName | Name for the source of the exposure data. | varchar | 255 | ||||
| DataServerName | Name of the server where the exposure data is stored. | varchar | 255 | ||||
| ExposureDataSourceUID | GUID of the exposure data's source. | uniqueidentifier | 16 |  |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tRRRR_LOSS_ByContract | Table | Stores event losses for one detailed loss analysis by contract. Touchstone creates one table for each analysis that includes Contract as an output option. | 2 |
| tRRRR_LOSS_ByContractGeo | Table | Stores event losses for one detailed loss analysis by each combination of contract and geography. Touchstone creates one table for each analysis that includes Contract and Geography as output options. | 2 |
| 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. | 2 |
| tRRRR_LOSS_ByContractSummary | Table | Stores summary losses for one detailed loss analysis by contract. Touchstone creates one table for each analysis that includes Contract Summary as an output option. | 2 |
| tRRRR_LOSS_ByContractZone | Table | Stores event losses for one detailed loss analysis by each combination of contract and zone. Touchstone creates one table for each analysis that includes Contract and Zone as output options. | 2 |
| 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. | 2 |
| 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. | 2 |
| tRRRR_LOSS_ByLocation | Table | Stores location-level loss results from a detailed Loss analysis. This table is created when the user specifies "Save Loss By Location" in the analysis Output Options. | 2 |
| tRRRR_LOSS_ByLocationSummary | Table | Stores summary losses for one detailed loss analysis by location. Touchstone creates one table for each analysis that includes Location Summary as an output option. | 2 |
| 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_DimLayer | Table | Stores information about layers that experienced loss in the analysis. This dimension table is created when losses are saved by layer. | 1 |
| tRRRR_LOSS_DimLocation | Table | Stores information about locations that generated loss during a detailed loss analysis. Touchstone creates one dimension table for each analysis that included Location as an output option. | 1 |