Touchstone 4.0 Database Documentation
tRRRR_LOSS_DimLayer Table
Description
Stores information about layers that experienced loss in the analysis. This dimension table is created when losses are saved by layer.
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   
Primary Key LayerSID

Unique system-generated sequential identifier for the layer.

For a complete list of records, see tLayer Table.

Integer4   
 ExposureSetNameName of the exposure set.VarChar255  
 ContractIDUnique user-provided identifier for the contract.VarChar100  
 LayerIDUser-provided identifier for the layer.VarChar60  
 InsuredNameClient's name.VarChar60  
Objects that depend on tRRRR_LOSS_DimLayer
 Database ObjectObject TypeDescriptionDep Level
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
Objects that tRRRR_LOSS_DimLayer depends on
 Database ObjectObject TypeDescriptionDep Level
tRRRR_LOSS_DimExposureDataSource tabletRRRR_LOSS_DimExposureDataSourceTableStores information about databases that contain exposures that have been analyzed. This dimension table is created for every Loss analysis.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.