Touchstone 4.0 Database Documentation
tRRRR_LOSS_DimExposureDataSource Table
Description
Stores information about databases that contain exposures that have been analyzed. This dimension table is created for every Loss analysis.
Properties
Creation Date5/31/2016 9:45 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows0
Data Space Used0.00 KB
Index Space Used0.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key ExposureDataSourceSID

Unique system-generated sequential identifier for the exposure data source record.

For a complete list of records, see tDataSource Table.

Integer4   
 ExposureDataSourceNameName for the source of the exposure data.VarChar255   
 DataServerNameName of the server where the exposure data is stored.VarChar255   
 ExposureDataSourceUIDGUID of the exposure data's source.GUID16  
Objects that depend on tRRRR_LOSS_DimExposureDataSource
 Database ObjectObject TypeDescriptionDep Level
tRRRR_LOSS_ByContract tabletRRRR_LOSS_ByContractTableStores 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 tabletRRRR_LOSS_ByContractGeoTableStores contract geography-level loss results from a detailed Loss analysis. This table is created when the user specifies "Save Loss By Contract and Geography" in the analysis Output Options.2
tRRRR_LOSS_ByContractSummary tabletRRRR_LOSS_ByContractSummaryTableStores contract summary loss results from a detailed Loss analysis. This table is created when the user selects Contract Summary in the analysis Output Options.2
tRRRR_LOSS_ByLayer tabletRRRR_LOSS_ByLayerTableStores 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
tRRRR_LOSS_ByLocation tabletRRRR_LOSS_ByLocationTableStores 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.1
tRRRR_LOSS_ByLocationSummary tabletRRRR_LOSS_ByLocationSummaryTableStores location summary loss results from a detailed Loss analysis.  This table is created when the user selects Location Summary in the analysis Output Options.1
tRRRR_LOSS_DimContract tabletRRRR_LOSS_DimContractTableStores 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 tabletRRRR_LOSS_DimLayerTableStores information about layers that experienced loss in the analysis. This dimension table is created when losses are saved by layer.1
tRRRR_LOSS_DimLocation tabletRRRR_LOSS_DimLocationTableStores information about locations that experienced loss in the analysis. This dimension table is created when losses are saved by location.1
See Also

Related Objects

AIRResult
Locating Results for a Specific Analysis

 

 


AIR Client Confidential

© 2016. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact AIR Worldwide with questions or comments. For database questions. For documentation comments.