Touchstone 4.0 Database Documentation
tRRRR_LOSS_ByLocationPerilAAL Table
Description

Stores average annual loss results, at the peril- and location-level, from a detailed Loss analysis. This table is created when the user specifies both "Save Loss By Peril" and "Save Loss By Location" 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 LocationSID

Unique system-generated sequential identifier for the location record.

For a complete list of records, see tLocation Table.

Integer4   
Primary Key PerilSetCode

Numeric code for the single peril or set of perils.

For a complete list of codes, see tPerilSet Table.

Integer4   
 GroundUpLossGround-Up loss value prior to the application of terms. For reinsurance, this is the ground-up loss for the treaty.Double9  
 RetainedLossRetained loss value, which is the Ground-Up loss minus the insured Gross loss.Double9  
 PreLayerGrossLossRetained loss value, which is the Ground-Up loss minus the insured Gross loss.Double9  
 GrossLossGross loss value, which is the loss after layer-level terms are applied.Double9  
 NetOfPreCATLossNet-of-Pre Catastrophe loss value, which is the expected net loss value before the application of catastrophe excess of loss reinsurance.Double9  
 PostCATNetLossNet-of-Post Catastrophe loss value, which is the expected net loss value after the application of catastrophe excess of loss reinsurance.Double9  
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.