Touchstone 2022 Database Reference
tRRRR_TTTT_CMPLOSS_ContractLOBAAL Table
AIRExposureSummary Database : 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 6:15 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_RankUnique 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_LOBKeyTable

Stores information about the Line of Business used during the Comparative Loss analysis.

1
See Also

Related Objects

AIRExposureSummary Database

 

 

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.