Touchstone 4.0 Database Documentation
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.
Creation Date5/31/2016 9:46 AM
Text File Group
System Object
Published for Replication
Data Space Used0.00 KB
Index Space Used0.00 KB
 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.

Primary Key LayerSID

Unique system-generated sequential identifier for the layer.

For a complete list of records, see tLayer Table.

 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

AIRExposureSummary Database



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.