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 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 | |
|---|---|---|---|---|---|---|---|
 | 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 contract-level loss results from a detailed Loss analysis. This table is created when the user specifies "Save Loss By Contract" in the analysis Output Options. | 2 |
| tRRRR_LOSS_ByContractGeo | Table | Stores contract geography-level loss results from a detailed Loss analysis. This table is created when a user specifies Contract and Geography in the Save Loss By area of the Output Options pane. | 2 |
| tRRRR_LOSS_ByContractGeoLayer | Table | Stores losses for each contract, geography, and layer combination included in a detailed loss analysis. This table is created when a user specifies Layer and Geography in the Save Loss By area of the Output Options pane. | 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 experienced loss in the analysis. This dimension table is created when losses are saved by location. The premium geocodes obtained by licensing this feature are restricted for use only within Touchstone and cannot be used outside of Touchstone. These are identified by the GeocoderCode = 'Syncsort' column in Touchstone AIRExposure, AIRReference, and AIRResults databases. For the Export feature, these premium geocodes are either encrypted or removed during export to comply with these contractual restrictions. Direct extracts of premium geocodes from the Touchstone databases are also contractually prohibited. | 1 |