Touchstone 4.0 Database Documentation
tRRRR_NONCAT_ByLocation Table
Description
Stores location-level loss results from a non-catastrophe loss analysis.  This table is created when the user specifies "Save Loss by Location" in the analysis Output Options.
Properties
Creation Date5/31/2016 9:45 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   
 GrossLossGross loss value, which is the loss after layer-level terms are applied.Double9  
 GroundUpLossGround-Up loss value prior to the application of terms.  For reinsurance, this is the ground-up loss for the treaty.Double9  
 NetOfPreCATLossNet-of-Pre Catastrophe loss value, which is the expected net loss value before the application of catastrophe excess of loss reinsurance.Double9  
 RetainedLossRetained loss value, which is the Ground-Up loss minus the insured Gross loss.Double9  
Objects that tRRRR_NONCAT_ByLocation depends on
 Database ObjectObject TypeDescriptionDep Level
tRRRR_NONCAT_DimLocation tabletRRRR_NONCAT_DimLocationTableStores information about locations that experienced loss in a non-catastrophe loss analysis. This dimension table is created when losses are saved by location.1
See Also

Related Objects

AIRResult
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.