Touchstone 2022 Database Reference
tRRRR_TTTT_CMPLOSS_ContractLOBAAL Table
AIRResult : tRRRR_TTTT_CMPLOSS_ContractLOBAAL Table
Description

Stores the deltas for the aggregate average annual losses by contract LOB 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 Date4/11/2022 5:46 PM
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 ContractRowIDSystem-assigned table row identifier for the contract.int4   
Primary Key LOBRowIDSystem-assigned table row identifier for the LOB.int4   
 GroundUpLossGround-Up loss delta.float9  
 RetainedLossRetained loss delta.float9  
 PreLayerGrossLossPre-layer Gross loss delta.float9  
 GrossLossGross loss delta.float9  
 NetOfPreCATLossNet-of-Pre Catastrophe loss delta.float9  
 PostCATNetLossNet-of-Post Catastrophe loss delta.float9  
 GroundUp_RankUnique identifier of the contract LOB that produced the highest average annual Ground-Up loss.bigint8  
 Retained_RankUnique identifier of the contract LOB that produced the highest average annual Retained loss.bigint8  
 PreLayerGross_RankUnique identifier of the contract LOB that produced the highest average annual Pre-layer Gross loss.bigint8  
 Gross_Rank
Unique identifier of the contract LOB that produced the highest average annual Gross loss.
bigint8  
 NetOfPreCAT_RankUnique identifier of the contract LOB that produced the highest average annual Net-of-Pre Catastrophe loss.bigint8  
 PostCATNet_RankUnique identifier of the contract LOB that produced the highest average annual Net-of-Post Catastrophe loss.bigint8  
Objects that tRRRR_TTTT_CMPLOSS_ContractLOBAAL depends on
 Database ObjectObject TypeDescriptionDep Level
tRRRR_CMPLOSS_ContractKey tabletRRRR_CMPLOSS_ContractKeyTableStores information about the contracts used during the Comparative Loss analysis.1
tRRRR_CMPLOSS_LOBKey tabletRRRR_CMPLOSS_LOBKeyTableStores information about the Line of Business used during the Comparative Loss analysis.1
See Also

Related Objects

AIRResult
Locating Results for a Specific Analysis

 

 

Verisk Analytics Client Confidential

© 2022. AIR Worldwide is now Extreme Event Solutions. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact Verisk Analytics with questions or comments.