Touchstone 4.0 Database Documentation
tRRRR_TTTT_CMPLOSS_GeoAAL Table
Description

Stores the deltas in the aggregate average annual losses by location that are calculated during a Comparative Loss analysis.

tRRRR denotes the Results SID for the Comparative Loss analysis and TTTT represents the identifier for the loss analysis.
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 GeoRowID

System-assigned table row identifier for the location. 

BigInt8   
 GroundUpLossGround-Up loss delta.Double9  
 RetainedLossRetained loss delta.Double9  
 PreLayerGrossLossPre-layer Gross loss delta.Double9  
 GrossLossGross loss delta.Double9  
 NetOfPreCATLossNet-of-Pre Catastrophe loss delta.Double9  
 PostCATNetLossNet-of-Post Catastrophe loss delta.Double9  
 GroundUp_RankUnique identifier of the location that produced the highest average annual Ground-Up loss.BigInt8  
 Retained_RankUnique identifier of the location that produced the highest average annual  Retained loss.BigInt8  
 PreLayerGross_RankUnique identifier of the location that produced the highest average annual Pre-layer Gross loss.BigInt8  
 Gross_RankUnique identifier of the location that produced the highest average annual Gross loss.BigInt8  
 NetOfPreCAT_RankUnique identifier of the location that produced the highest average annual Net of Pre-Catastrophe loss.BigInt8  
 PostCATNet_RankUnique identifier of the location that produced the highest average annual Net-of-Post Catastrophe loss.BigInt8  
Objects that tRRRR_TTTT_CMPLOSS_GeoAAL depends on
 Database ObjectObject TypeDescriptionDep Level
tRRRR_CMPLOSS_GeoKey tabletRRRR_CMPLOSS_GeoKeyTableStores information about the location used during the Comparative Loss analysis.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.