Touchstone 4.0 Database Documentation
tRRRR_NONCAT_ByLayer Table
Stores layer-level loss results from a non-catastrophe loss analysis.  This table is created when the user specifies "Save Loss by Layer" in the analysis Output Options.
Creation Date5/31/2016 9:45 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 record.

For a complete list of records, see tLayer Table.

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

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.

 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

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.