Touchstone 4.0 Database Documentation
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 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 ContractRowIDSystem-assigned table row identifier for the contract.Integer4   
Primary Key LOBRowIDSystem-assigned table row identifier for the LOB.Integer4   
 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 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

 

 


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.