Touchstone 4.0 Database Documentation
tRRRR_NONCAT_ByLayer Table
Description
Stores 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.
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   
Primary Key PSOLDType

Code that represents the type of PSOLD data used during a Non-catastrophe analysis.

  • CP5 - Commercial Property 5 years 
  • CP20 - Commercial Property 20 years
  • HO5 - Home Owners 5 years
  • HO20 - Home Owners 20 years
Char4   
 ExpectedLoss

Mean expected loss (expected value). 

Determined by taking the sum of all expected loss from the past "X" years data, where x is 5 or 20 years.

The expected loss (expected value) by layer is the Gross loss after layer conditions are applied to the Ground-Up loss.

Double9  
 LimitedSeverityAverage severity of loss, by year. Double9  
 ExcessClaimCountExpected number of yearly claims for each layer.Integer4  
 LayerAverageSeverityLayer average severity is the average severity per claim for each layer.Double9  
 PercentGroundupExpectedLossPercent of total expected loss that is Ground-Up loss.  Calculated using the following equation: (Gross loss / Ground-Up loss ) *100Double9  
Objects that tRRRR_NONCAT_ByLayer depends on
 Database ObjectObject TypeDescriptionDep Level
tRRRR_NONCAT_DimLayer tabletRRRR_NONCAT_DimLayerTableStores information about layers that experienced loss in a non-catastrophe loss analysis. This dimension table is created when losses are saved by layer.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.