Touchstone 4.0 Database Documentation
tRRRR_NONCAT_DimLayer Table
Description
Stores information about layers that experienced loss in a non-catastrophe loss analysis. This dimension table is created when losses are saved by layer.
Properties
Creation Date5/31/2016 9:46 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 record.

For a complete list of records, see tLayer Table.

Integer4   
 ContractSID

Unique system-generated sequential identifier for the contract record.

For a complete list of records, see tContract Table.

Integer4   
 LayerIDUnique user-provided identifier for the layer.VarChar60  
 OccLimitTypeCode

Code that represents the limit type.

For a complete list of codes, see dbo.tOccLimitType Table.

VarChar10   
Objects that depend on tRRRR_NONCAT_DimLayer
 Database ObjectObject TypeDescriptionDep Level
tRRRR_NONCAT_ByLayer tabletRRRR_NONCAT_ByLayerTableStores layer-level loss results from a non-catastrophe detailed loss analysis.  This table is created when the user specifies "Save Loss by Layer" in the analysis Output Options.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.