Touchstone 4.0 Database Documentation
tRRRR_TTTT_CMPLOSS_ByEvent Table
Description

Stores the deltas for the aggregate event losses 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: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 EventRowIDSystem-assigned table row identifier for the event.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 event that produced the highest Ground-Up loss in the simulated year.BigInt8  
 Retained_RankUnique identifier of the event that produced the highest Retained loss in the simulated year.BigInt8  
 PreLayerGross_RankUnique identifier of the event that produced the highest Pre-layer Gross loss in the simulated year.BigInt8  
 Gross_RankUnique identifier of the event that produced the highest Gross loss in the simulated year.BigInt8  
 NetOfPreCAT_RankUnique identifier of the event that produced the highest Net of Pre-Catastrophe loss in the simulated year.BigInt8  
 PostCATNet_RankUnique identifier of the event that produced the highest Net-of-Post Catastrophe loss in a simulated year.BigInt8  
Objects that tRRRR_TTTT_CMPLOSS_ByEvent depends on
 Database ObjectObject TypeDescriptionDep Level
tRRRR_CMPLOSS_EventKey tabletRRRR_CMPLOSS_EventKeyTable

Stores information about the events used during the Comparative Loss analysis.    

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