Touchstone 4.0 Database Documentation
tRRRR_LOSS_ByGeoPerilAAL Table
Description

Stores average annual loss results, at the peril- and geography-level, from a detailed Loss analysis. This table is created when the user selects "Save Loss By Peril" and also selects a geographic area from the "Geography" drop-down box 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 GeographySID

Unique system-generated sequential identifier for the geographic record.

For a complete set of records, see tGeography 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   
 GeoLevelCode

Code that represents the geography level of the exposure.

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

VarChar10   
 GeoCode

Geocode value.

VarChar15   
 GeoName

Name that corresponds to the GeoCode.

VarChar255   
 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  
 PreLayerGrossLossPre-layer Gross loss value, which is the expected gross loss value before the application of layer-level terms.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.